For online load (ALLOW READ ACCESS) without specifying USE
<tablespace> option, the shadow index will be created in the
same tablespace as the index object, and if an escalation of an
internal extent movement lock is needed at the same time, the
Load might fail in acquiring the extent movement lock followed
by an "Invalid pool ID" error, then subsequent commit operation
might ultimately mark the database bad.
Additionally, subsequent crash recovery might fail with the same
symptoms as what you saw from failed load previously so that
the database cannot be recovered.
The errors in db2diag.log are as below.
2012-07-29-15.33.25.412726+480 I8038741E568 LEVEL: Error
PID : 12348 TID : 139821397829968PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 998-10015 APPID:
*N998.db2inst1.120729081747
AUTHID : JOB_ETL
EDUID : 32298 EDUNAME: db2lrid 24
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
DATA #1 : String, 145 bytes
LOADID: 206.2012-07-29-15.32.36.252376.998 (65530;36218)
Error requiring extent movement lock. , 1, (nil), Detected in
file:sqlulinx.C, Line:1677
<strip>
2012-07-29-15.34.00.649555+480 I8083036E498 LEVEL: Error
PID : 12348 TID : 139827399878992PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 998-10015 APPID:
*N998.db2inst1.120729081747
AUTHID : JOB_ETL<
EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24
FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0
MESSAGE : Check pool , -2029911946, 0x10040, Detected in
file:sqluvppo.C,<
Line:2895
2012-07-29-15.34.00.649806+480 I8083535E459 LEVEL:
Warning
PID : 12348 TID : 139827399878992PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 998-10015 APPID:
*N998.db2inst1.120729081747
AUTHID : JOB_ETL<
EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 27 bytes
TS info 0, 139827399872756
<strip>
2012-07-29-15.34.00.650140+480 I8084519E498 LEVEL: Severe
PID : 12348 TID : 139827399878992PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : Sample
APPHDL : 998-10015 APPID:
*N998.db2inst1.120729081747
AUTHID : JOB_ETL
EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24
FUNCTION: DB2 UDB, database utilities,
sqlu_process_pending_operation, probe:1904
RETCODE : ZRC=0x87020076=-2029911946=SQLB_INV_POOLID "Invalid
pool ID"
<strip>
2012-07-29-15.34.01.133561+480 E8130570E465 LEVEL: Severe
PID : 12348 TID : 139827399878992PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 998-10015 APPID:
*N998.db2inst1.120729081747
AUTHID : JOB_ETL<
EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24
FUNCTION: DB2 UDB, base sys utilities,
sqeLocalDatabase::MarkDBBad, probe:10
MESSAGE : ADM7518C "SAMPLE " marked bad.
Subsequent crash recovery may fail with following error message
in db2diag.log.
2012-07-29-19.20.16.799120+480 E3337E457 LEVEL:
Warning
PID : 32185 TID : 139900972165456PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 24-64 APPID: *N24.db2inst1.120729112008
AUTHID : DB2INST1
EDUID : 38 EDUNAME: db2agent (SAMPLE) 24
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : ADM1530E Crash recovery has been initiated.
<strip>
2012-07-29-19.20.18.424328+480 I7474E542 LEVEL: Severe
PID : 32185 TID : 139900863113552PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 24-64 APPID: *N24.db2inst1.120729112008
AUTHID : DB2INST1
EDUID : 68 EDUNAME: db2redom (SAMPLE) 24
FUNCTION: DB2 UDB, data management, sqldLoadTCBObjDesc,
probe:1744
RETCODE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
Header"
DIA8547C An error occurred in a database page header.
<strip>
2012-07-29-19.20.18.425125+480 I10137E743 LEVEL: Severe
PID : 32185 TID : 139900863113552PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 24-64 APPID: *N24.db2inst1.120729112008
AUTHID : DB2INST1
EDUID : 68 EDUNAME: db2redom (SAMPLE) 24
FUNCTION: DB2 UDB, data management, sqldFixTCBObj, probe:6459
MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page
Header"
DIA8547C An error occurred in a database page header.
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 12 bytes
Obj: {pool:39;obj:29465;type:1} Parent={39;29465}
DATA #2 : tcbFixFlags, PD_TYPE_SQLD_TCB_FIXFLAGS, 4 bytes
0x00000020
- TCB_EXPECT_NOTAVAIL
<strip>
2012-07-29-19.20.18.427185+480 I13813E480 LEVEL:
Warning
PID : 32185 TID : 139900863113552PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 24-64 APPID: *N24.db2inst1.120729112008
AUTHID : DB2INST1
EDUID : 68 EDUNAME: db2redom (SAMPLE) 24
FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0
DATA #1 : String, 49 bytes
Following tablespace does not exist. TS ID: 0, 0
<strip>
2012-07-29-19.20.23.464184+480 E35002E955 LEVEL:
Critical
PID : 32185 TID : 139900972165456PROC :
db2sysc 24
INSTANCE: db2inst1 NODE : 024 DB : SAMPLE
APPHDL : 24-64 APPID: *N24.db2inst1.120729112008
AUTHID : DB2INST1
EDUID : 38 EDUNAME: db2agent (SAMPLE) 24
FUNCTION: DB2 UDB, base sys utilities,
sqeLocalDatabase::MarkDBBad, probe:10
Note: To skip crash recovery on the damaged tablespace, please
contact DB2 support. |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* For online load (ALLOW READ ACCESS) without specifying USE *
* <tablespace> option, the shadow index will be created in the *
* same tablespace as the index object, and if an escalation of *
* an *
* internal extent movement lock is needed at the same time, *
* the *
* Load might fail in acquiring the extent movement lock *
* followed *
* by an "Invalid pool ID" error, then subsequent commit *
* operation *
* might ultimately mark the database bad. *
* *
* Additionally, subsequent crash recovery might fail with the *
* same *
* symptoms as what you saw from failed load previously so that *
* the database cannot be recovered. *
* *
* The errors in db2diag.log are as below. *
* *
* 2012-07-29-15.33.25.412726+480 I8038741E568 LEVEL: *
* Error *
* PID : 12348 TID : 139821397829968PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* APPHDL : 998-10015 APPID: *
* *N998.db2inst1.120729081747 *
* AUTHID : JOB_ETL *
* EDUID : 32298 EDUNAME: db2lrid 24 *
* FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 *
* DATA #1 : String, 145 bytes *
* LOADID: 206.2012-07-29-15.32.36.252376.998 (65530;36218) *
* Error requiring extent movement lock. , 1, (nil), Detected *
* in *
* file:sqlulinx.C, Line:1677 *
* *
* <strip> *
* *
* 2012-07-29-15.34.00.649555+480 I8083036E498 LEVEL: *
* Error *
* PID : 12348 TID : 139827399878992PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* *
* APPHDL : 998-10015 APPID: *
* *N998.db2inst1.120729081747 *
* AUTHID : JOB_ETL< *
* EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24 *
* FUNCTION: DB2 UDB, database utilities, DIAG_ERROR, probe:0 *
* MESSAGE : Check pool , -2029911946, 0x10040, Detected in *
* file:sqluvppo.C,< *
* Line:2895 *
* *
* 2012-07-29-15.34.00.649806+480 I8083535E459 LEVEL: *
* Warning *
* PID : 12348 TID : 139827399878992PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* *
* APPHDL : 998-10015 APPID: *
* *N998.db2inst1.120729081747 *
* AUTHID : JOB_ETL< *
* EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24 *
* FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0 *
* DATA #1 : String, 27 bytes *
* *
* TS info 0, 139827399872756 *
* *
* <strip> *
* *
* 2012-07-29-15.34.00.650140+480 I8084519E498 LEVEL: *
* Severe *
* *
* PID : 12348 TID : 139827399878992PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* Sample *
* *
* APPHDL : 998-10015 APPID: *
* *N998.db2inst1.120729081747 *
* AUTHID : JOB_ETL *
* EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24 *
* FUNCTION: DB2 UDB, database utilities, *
* sqlu_process_pending_operation, probe:1904 *
* RETCODE : ZRC=0x87020076=-2029911946=SQLB_INV_POOLID *
* "Invalid *
* pool ID" *
* *
* <strip> *
* *
* 2012-07-29-15.34.01.133561+480 E8130570E465 LEVEL: *
* Severe *
* *
* PID : 12348 TID : 139827399878992PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* *
* APPHDL : 998-10015 APPID: *
* *N998.db2inst1.120729081747 *
* AUTHID : JOB_ETL< *
* EDUID : 161 EDUNAME: db2agnta (SAMPLE) 24 *
* FUNCTION: DB2 UDB, base sys utilities, *
* sqeLocalDatabase::MarkDBBad, probe:10 *
* MESSAGE : ADM7518C "SAMPLE " marked bad. *
* *
* *
* Subsequent crash recovery may fail with following error *
* message *
* in db2diag.log. *
* *
* *
* 2012-07-29-19.20.16.799120+480 E3337E457 LEVEL: *
* Warning *
* PID : 32185 TID : 139900972165456PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* APPHDL : 24-64 APPID: *
* *N24.db2inst1.120729112008 *
* AUTHID : DB2INST1 *
* EDUID : 38 EDUNAME: db2agent (SAMPLE) 24 *
* FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410 *
* MESSAGE : ADM1530E Crash recovery has been initiated. *
* *
* <strip> *
* *
* 2012-07-29-19.20.18.424328+480 I7474E542 LEVEL: *
* Severe *
* PID : 32185 TID : 139900863113552PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* APPHDL : 24-64 APPID: *
* *N24.db2inst1.120729112008 *
* AUTHID : DB2INST1 *
* EDUID : 68 EDUNAME: db2redom (SAMPLE) 24 *
* FUNCTION: DB2 UDB, data management, sqldLoadTCBObjDesc, *
* probe:1744 *
* RETCODE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page *
* Header" *
* DIA8547C An error occurred in a database page *
* header. *
* *
* <strip> *
* *
* 2012-07-29-19.20.18.425125+480 I10137E743 LEVEL: *
* Severe *
* PID : 32185 TID : 139900863113552PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* APPHDL : 24-64 APPID: *
* *N24.db2inst1.120729112008 *
* AUTHID : DB2INST1 *
* EDUID : 68 EDUNAME: db2redom (SAMPLE) 24 *
* FUNCTION: DB2 UDB, data management, sqldFixTCBObj, *
* probe:6459 *
* MESSAGE : ZRC=0x87020036=-2029912010=SQLB_BADHDR "Bad Page *
* Header" *
* DIA8547C An error occurred in a database page *
* header. *
* DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 12 *
* bytes *
* Obj: {pool:39;obj:29465;type:1} Parent={39;29465} *
* DATA #2 : tcbFixFlags, PD_TYPE_SQLD_TCB_FIXFLAGS, 4 bytes *
* 0x00000020 *
* - TCB_EXPECT_NOTAVAIL *
* *
* <strip> *
* *
* 2012-07-29-19.20.18.427185+480 I13813E480 LEVEL: *
* Warning *
* PID : 32185 TID : 139900863113552PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* APPHDL : 24-64 APPID: *
* *N24.db2inst1.120729112008 *
* AUTHID : DB2INST1 *
* EDUID : 68 EDUNAME: db2redom (SAMPLE) 24 *
* FUNCTION: DB2 UDB, database utilities, DIAG_NOTE, probe:0 *
* DATA #1 : String, 49 bytes *
* *
* Following tablespace does not exist. TS ID: 0, 0 *
* *
* <strip> *
* *
* 2012-07-29-19.20.23.464184+480 E35002E955 LEVEL: *
* Critical *
* PID : 32185 TID : 139900972165456PROC : *
* db2sysc 24 *
* INSTANCE: db2inst1 NODE : 024 DB : *
* SAMPLE *
* APPHDL : 24-64 APPID: *
* *N24.db2inst1.120729112008 *
* AUTHID : DB2INST1 *
* EDUID : 38 EDUNAME: db2agent (SAMPLE) 24 *
* FUNCTION: DB2 UDB, base sys utilities, *
* sqeLocalDatabase::MarkDBBad, probe:10 *
* *
* Note: To skip crash recovery on the damaged tablespace, *
* please *
* contact DB2 support. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 V97FP8 or higher version *
**************************************************************** |
