连接数据库SQL0290N

情况描述：

得到通知数据库有个数据库无法连接，报错。获取ＩＰ的登陆账号后进行排查。

$ db2 connect to testdb SQL0290N Table space access is not allowed. SQLSTATE=55039

错误分析：

从上述的错误信息可以看出应该是因为表空间错误导致数据库无法连接。

采用db2pd查看表空间信息

$ db2pd -d testdb -table Database testdb not activated on database partition 0. Option -table requires -db <database> or -alldbs option and active database.

因为数据库没有启动，db2pd无法访问。

查看Dialog信息

2012-12-03-14.19.40.846240+480 I316319A603 LEVEL: Error (OS) PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, SQO Memory Management, sqloMemPinSet, probe:100 MESSAGE : ZRC=0x800F006B=-2146500501=SQLO_BAD_AUTH "Unsupported authentication" DIA8118 Failure processing SQL statement. CALLED : OS, -, shmctl OSERR : EPERM (1) "Operation not permitted." DATA #1 : String, 34 bytes Failure locking segment in memory. 2012-12-03-14.19.40.846537+480 I316923A636 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, SQO Memory Management, sqloMemCreateSingleSegment, probe:110 MESSAGE : ZRC=0x800F006B=-2146500501=SQLO_BAD_AUTH "Unsupported authentication" DIA8118 Failure processing SQL statement. DATA #1 : String, 129 bytes No permission to pin memory segment. Check CAP_BYPASS_RAC_VMM capability for the instance owner. Continuing with unpinned memory. 2012-12-03-14.19.40.928678+480 I317560A363 LEVEL: Warning PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30 MESSAGE : Crash Recovery is needed. 2012-12-03-14.19.41.039812+480 I317924A3940 LEVEL: Severe PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:100 DATA #1 : String, 20 bytes *pTag(CONTAINER_TAG) DATA #2 : Hexdump, 512 bytes 0x00000001118F2600 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2610 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2620 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2630 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2640 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2650 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2660 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2670 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2680 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2690 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F26A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F26B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F26C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F26D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F26E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F26F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2700 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2710 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2720 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2730 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2740 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2750 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2760 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2770 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2780 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F2790 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F27A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F27B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F27C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F27D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F27E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x00000001118F27F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ CALLSTCK: [0] 0x0900000002A6B5BC sqlbContainerTagIsValid__FP13CONTAINER_TAGiP8SQLP_LSNT2UiP12SQLB_GLOBALSbT7 + 0x37C [1] 0x090000000301C374 sqlbDMSDoContainerOp__FiP8SQLP_LSNT1P16SQLB_POOLCONT_CB12SQLB_CONT_OPUiT2P12SQLB_GLOBALS + 0x244 [2] 0x090000000301C0A0 sqlbDMSDoContainerOp__FiP8SQLP_LSNT1P16SQLB_POOLCONT_CB12SQLB_CONT_OPUiP12SQLB_GLOBALS + 0x38 [3] 0x0900000003008AEC sqlbDMSStartPool__FP12SQLB_GLOBALSP12SQLB_POOL_CB + 0x104 [4] 0x0900000003007FF0 sqlbStartPools__FP12SQLB_GLOBALS + 0x1C8 [5] 0x0900000002FF1A44 sqlbinit + 0x3A8 [6] 0x0900000002F45C30 sqledint__FP20sqle_agent_privatecbP8sqledbcbP5sqlcacPci + 0x150 [7] 0x0900000002F43110 sqleFirstConnect__FP7sqlebwaRcP20sqle_agent_privatecbP8sqlo_gmtP12SQLB_GLOBALSPiP8sqledbcb + 0xC4 [8] 0x0900000002F58234 sqleserl__FP7sqlebwaP13sqle_agent_cbRccP8sqlo_gmt + 0xF4 [9] 0x0900000002FA8170 sqlesrsu__FP7sqlebwaP13sqle_agent_cbcT3P5sqlcaPc + 0x2A4 2012-12-03-14.19.41.040201+480 I321865A3011 LEVEL: Severe PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:200 DATA #1 : String, 19 bytes iTag(CONTAINER_TAG) DATA #2 : Hexdump, 512 bytes 0x0FFFFFFFFFFE92C0 : 4442 3243 4F4E 5400 0000 0000 8537 5633 DB2CONT......7V3 0x0FFFFFFFFFFE92D0 : 0000 0003 0000 0000 0000 0000 0000 0001 ................ 0x0FFFFFFFFFFE92E0 : 0000 017A 04AC 5043 4144 4220 2020 0070 ...z..TESTDB .p 0x0FFFFFFFFFFE92F0 : 6361 696E 7374 0000 0000 0000 0000 017A cainst.........z 0x0FFFFFFFFFFE9300 : 04AC 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9310 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9320 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9330 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9340 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9350 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9360 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9370 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9380 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9390 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE93A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE93B0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE93C0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE93D0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE93E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE93F0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9400 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9410 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9420 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9430 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9440 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9450 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9460 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9470 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9480 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE9490 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE94A0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0x0FFFFFFFFFFE94B0 : 0000 0000 0000 0000 0000 0000 FBE6 4A75 ..............Ju 2012-12-03-14.19.41.040425+480 I324877A402 LEVEL: Severe PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:900 DATA #1 : String, 31 bytes sqloHasSameVnode returned false 2012-12-03-14.19.41.040549+480 I325280A443 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:840 MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE "Container not accessible" 2012-12-03-14.19.41.040664+480 I325724A437 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:840 DATA #1 : String, 70 bytes Error checking container 0 (/dev/rts_part01) for tbsp 3. Rc = 8402001E 2012-12-03-14.19.41.040775+480 I326162A439 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSStartPool, probe:800 MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE "Container not accessible" 2012-12-03-14.19.41.040888+480 I326602A386 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSStartPool, probe:800 DATA #1 : String, 24 bytes Tablespace 3 (TESTSPACE) 2012-12-03-14.19.41.040981+480 E326989A512 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30 MESSAGE : ADM6023I The table space "TESTSPACE" (ID "3") is in state 0x"0". The table space cannot be accessed. Refer to the documentation for SQLCODE -290. 2012-12-03-14.19.41.041159+480 I327502A436 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:30 MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE "Container not accessible" 2012-12-03-14.19.41.041292+480 E327939A526 LEVEL: Severe PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbStartPoolsErrorHandling, probe:55 MESSAGE : ADM6023I The table space "TESTSPACE" (ID "3") is in state 0x"0". The table space cannot be accessed. Refer to the documentation for SQLCODE -290. 2012-12-03-14.19.41.041584+480 E328466A1272 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:63 MESSAGE : ADM6049E The database cannot be restarted because one or more table spaces cannot be brought online. To restart the database specify the "DROP PENDING TABLESPACES" option on the RESTART DATABASE command. WARNING! PUTTING A TABLESPACE INTO THE DROP PENDING STATE MEANS THAT NO FURTHER ACCESS TO THE TABLESPACE WILL BE ALLOWED. ITS CONTENTS WILL BE INACCESSIBLE THROUGHOUT THE REMAINDER OF THE LIFE OF THE TABLESPACE AND THE ONLY OPERATION THAT WILL BE ALLOWED ON IT IS "DROP TABLESPACE". There is no way in which it can be brought back. It is important that you consider the consequences of this action as data can be lost as a result. Before proceeding consult the DB2 documentation and contact IBM support if necessary. The table spaces to specify in the DROP PENDING TABLESPACES list are: "TESTSPACE ". 2012-12-03-14.19.41.041748+480 I329739A452 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:182 MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P "Access not allowed. Tblspc Recovery Pend." 2012-12-03-14.19.41.041893+480 I330192A446 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:590 MESSAGE : ZRC=0x80020035=-2147352523=SQLB_NOT_ALLOWED_RECOVERY_P "Access not allowed. Tblspc Recovery Pend." 2012-12-03-14.19.41.048417+480 I330639A422 LEVEL: Severe PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160 DATA #1 : Hexdump, 4 bytes 0x0FFFFFFFFFFEA710 : 8002 0035 ...5 2012-12-03-14.19.41.048601+480 I331062A421 LEVEL: Error PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:160 DATA #2 : Hexdump, 4 bytes 0x0FFFFFFFFFFEA710 : 8002 0035 ...5 2012-12-03-14.19.41.048693+480 I331484A430 LEVEL: Severe PID : 3932256 TID : 1 PROC : db2agent (TESTDB) 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-75 APPID: *LOCAL.db2inst1.121203061940 AUTHID : db2inst1 FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100 DATA #1 : Hexdump, 4 bytes 0x000000011185B26C : FFFF FEDE

虽然信息有点多（这视乎是DB2一贯作风），但是我们还是可以清晰的看到容器/dev/rts_part01无法访问的错误信息

/dev/rts_part01可以直接看出是使用裸设备，裸设备不能访问怀疑是存储有问题（下列信息进行了简化）

$ lsvg -l rootvg rootvg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT hd5 boot 1 1 1 closed/syncd N/A hd6 paging 48 48 1 open/syncd N/A ts_part01 raw 40 40 1 closed/syncd N/A ts_part02 raw 24 24 1 closed/syncd N/A

从上面的信息可以看出裸设备是关闭的，这着不能完全说明裸设备问题，因为裸设备没有访问的时候也可能处于关闭状态。因为该服务器上还有另一个实例db2inst2使用ts_part02的裸设备，为了确认问题切换到实例db2inst2下进行检查。db2inst2数据库连接正常，查看裸盘对应的表空间：

db2pd –d testdb2 -table Database Partition 0 -- Database TESTDB2 -- Active -- Up 0 days 00:06:24 Tablespace Configuration: Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name 0x0780000026C42720 3 DMS Large 32768 32 Yes 192 2 2 On 1 0 31 TESTDB2_TSPACE2 ....................省略若干信息 Containers: Address TspId ContainNum Type TotalPgs UseablePgs StripeSet Container 0x0780000026C42E00 3 0 Disk 98304 98272 0 /dev/rts_part02

查看表空间快照：

$ db2 get snapshot for tablespaces on TESTDB2|more Tablespace name = TESTDB2_TSPACE2 Tablespace ID = 3 Tablespace Type = Database managed space Tablespace Content Type = All permanent data. Large table space. Tablespace Page size (bytes) = 32768 Tablespace Extent size (pages) = 32 Automatic Prefetch size enabled = Yes Buffer pool ID currently in use = 2 Buffer pool ID next startup = 2 Using automatic storage = No Auto-resize enabled = No File system caching = Yes Tablespace State = 0x'00004000' Detailed explanation: Offline ....................省略若干信息

Dialog

2012-12-03-14.16.35.158380+480 I179855A402 LEVEL: Severe PID : 8716386 TID : 1 PROC : db2agent (TESTDB2) 0 INSTANCE: db2inst2 NODE : 000 APPHDL : 0-78 APPID: *LOCAL.db2inst2.121203061634 AUTHID : db2inst2 FUNCTION: DB2 UDB, buffer pool services, sqlbContainerTagIsValid, probe:900 DATA #1 : String, 31 bytes sqloHasSameVnode returned false 2012-12-03-14.16.35.158513+480 I180258A443 LEVEL: Error PID : 8716386 TID : 1 PROC : db2agent (TESTDB2) 0 INSTANCE: db2inst2 NODE : 000 APPHDL : 0-78 APPID: *LOCAL.db2inst2.121203061634 AUTHID : db2inst2 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:840 MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE "Container not accessible" 2012-12-03-14.16.35.158633+480 I180702A440 LEVEL: Error PID : 8716386 TID : 1 PROC : db2agent (TESTDB2) 0 INSTANCE: db2inst2 NODE : 000 APPHDL : 0-78 APPID: *LOCAL.db2inst2.121203061634 AUTHID : db2inst2 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDoContainerOp, probe:840 DATA #1 : String, 73 bytes Error checking container 0 (/dev/rts_part02) for tbsp 3. Rc = 8402001E 2012-12-03-14.16.35.158745+480 I181143A439 LEVEL: Error PID : 8716386 TID : 1 PROC : db2agent (TESTDB2) 0 INSTANCE: db2inst2 NODE : 000 APPHDL : 0-78 APPID: *LOCAL.db2inst2.121203061634 AUTHID : db2inst2 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSStartPool, probe:800 MESSAGE : ZRC=0x8402001E=-2080243682=SQLB_CONTAINER_NOT_ACCESSIBLE "Container not accessible" 2012-12-03-14.16.35.158856+480 I181583A390 LEVEL: Error PID : 8716386 TID : 1 PROC : db2agent (TESTDB2) 0 INSTANCE: db2inst2 NODE : 000 APPHDL : 0-78 APPID: *LOCAL.db2inst2.121203061634 AUTHID : db2inst2 FUNCTION: DB2 UDB, buffer pool services, sqlbDMSStartPool, probe:800 DATA #1 : String, 28 bytes Tablespace 3 (TESTDB2_TSPACE2)

看到这里问题已经很明显了，两块裸盘都处于closed状态，使用裸盘的两个数据库一个无法连接报表空间错误，另一个连接后发现表空间offline。马上通知系统组检查存储问题。

结论：

没啥结论，后来得到系统组的反馈是裸设备问题，从新克隆后正常。

这里需要再去研究的两个问题：

1. 如果没有其他参考的条件下怎么判断裸设备是否正常呢？
2. 为何第一个数据库连接错误而第二个数据库连接正常呢？