After a database restore, recreating indexes could result in an
sqlcode -901 and instance panic.
The db2diag.log would show messages similar to the following:
2012-02-27-00.31.46.561547-300 I211947272E3836 LEVEL:
Severe
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, data management, sqldBeginIndexCreate,
probe:9891
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 40 bytes
numIndexes not set for index recreation!
DATA #2 : String, 10 bytes
sqldmcri.C
CALLSTCK: (Static functions may not be resolved correctly, as
they are resolved to the nearest symbol)
[0] 0x00002AAAABFE51C0 pdLog + 0x790
[1] 0x00002AAAAFA106C7 sqlzSetAndLog901 + 0x267
[2] 0x00002AAAAC65DEB1
_Z20sqldBeginIndexCreateP8sqeAgentP17SQLD_CREATEINX_CB+ 0x25D1
[3] 0x00002AAAAEF8B179
_Z24sqlrlRecreateIndexObjectP8sqlrr_cbP8sqlrg_idP17SQLD
_CREATEINX_CBjtmP25sqlyk_keyXform_threadListP23SqlthJobProgressM
onitor + 0x79
[4] 0x00002AAAAEF895E8
_Z20sqlrlRecreateIndexesP8sqlrr_cbttP8sqlrg_idiPhiS3_ij
PshP8SqlthJobtP9SQLP_LSN8tP14SQLP_LOCK_INFOS3_ + 0x528
[5] 0x00002AAAAEF8820E
_Z15sqlrlCheckIndexP8sqlrr_cbttP8sqlrg_idiPhiS3_ijhPsjP
8SqlthJob + 0x2AE
[6] 0x00002AAAAEF85CC1
_Z25sqlrlNonRestartCheckIndexP8sqlrr_cbttPhiS1_iP8sqlrg
_pdj + 0xE1
[7] 0x00002AAAAF097ADF
_Z8sqlrlaltP8sqlrr_cbPhsS1_sS1_sS1_sP8sqlrg_pdP17sqlrl_
table_parmsilP18sqlrg_datapartinfo + 0x3E3F
[8] 0x00002AAAAD9C60D5 _Z21sqlnq_alter_table_endP9sqlnq_qtb +
0x1CF5
[9] 0x00002AAAAD9C4313
_Z22sqlnq_alter_table_stmtPP8stknode_i10actiontypePhP3l
oc + 0xB3
[10] 0x00002AAAAD8727B4 _Z12sqlnp_smactnP8sqlnp_cbi + 0x3C4
[11] 0x00002AAAAD86285E _Z12sqlnp_parserP8sqlnp_cb + 0x1AAE
[12] 0x00002AAAAD86B875
_Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x8B
5
[13] 0x00002AAAAD474B58
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compile
ModesP14sqlrr_cmpl_enviiPP9sqlnq_qur + 0x1998
[14] 0x00002AAAAD4731B1
_Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compile
ModesP14sqlrr_cmpl_env + 0x21
[15] 0x00002AAAAEAA25AD
_Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitii
iiiP14SQLP_LOCK_INFOP16sqlra_cached_varPi + 0xEFD
[16] 0x00002AAAAEAB6BAB
_Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlr
a_stmt_idjjPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P1
4SQLP_LOC + 0x7F
B
[17] 0x00002AAAAEB39B5E _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ +
0xB3E
[18] 0x00002AAAAED41560 _Z21sqlri_ddl_get_sectionP8sqlrr_cb +
0x80
[19] 0x00002AAAAED3F337 _Z16sqlri_ddl_commonP8sqlrr_cb + 0x667
[20] 0x00002AAAAED3EC69 _Z8sqlriddlP8sqlrr_cb + 0x79
[21] 0x00002AAAAED67E33
_Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x3A3
[22] 0x00002AAAAE8F7507 _Z23sqlrr_execute_immediateP8sqlrr_cbi
+ 0x697
[23] 0x00002AAAAE8DB0FA
_Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo
+ 0x84A
[24] 0x00002AAAACEC63B2
_Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObje
ct + 0x672
[25] 0x00002AAAACE8E9EE
_Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObj
ectP14db2UCinterface + 0x42E
[26] 0x00002AAAACE8F869
_Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAg
entb + 0x549
[27] 0x00002AAAACE80FFA /home/mayumi/sqllib/lib64/libdb2e.so.1
+ 0x21A0FFA
[28] 0x00002AAAACE883C2 /home/mayumi/sqllib/lib64/libdb2e.so.1
+ 0x21A83C2
[29] 0x00002AAAACE89332
_Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0x142
[30] 0x00002AAAAC9BB2E0 _ZN8sqeAgent6RunEDUEv + 0xD70
[31] 0x00002AAAAFA0F61B _ZN9sqzEDUObj9EDUDriverEv + 0x12B
[32] 0x00002AAAAFA0F4E9 _Z10sqlzRunEDUPcj + 0x9
[33] 0x00002AAAAE4360CF sqloEDUEntry + 0x52F
[34] 0x00002AAAAABCD193 /lib64/libpthread.so.0 + 0x6193
[35] 0x00002AAAB38FCDFD __clone + 0x6D
2012-02-27-00.31.46.580338-300 I211951109E494 LEVEL:
Error
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, data management, sqldBeginIndexCreate,
probe:9891
DATA #1 : Hex integer, 8 bytes
0x0000000002000010
2012-02-27-00.31.46.581324-300 I211951604E604 LEVEL:
Error
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlCheckIndex, probe:99
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
2012-02-27-00.31.46.581889-300 I211952209E615 LEVEL:
Error
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlNonRestartCheckIndex,
probe:100
RETCODE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
2012-02-27-00.31.46.582326-300 I211952825E600 LEVEL:
Error
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlalt, probe:10160
RETCODE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
2012-02-27-00.31.46.582744-300 I211953426E1059 LEVEL:
Severe
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, catalog services, sqlrlalt, probe:8991
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 40
sqlerrmc: numIndexes not set for index recreation!
sqlerrp : SQLD11F
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFD95D (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
2012-02-27-00.31.46.583217-300 E211954486E1569 LEVEL: Info
(Origin)
PID : 1515 TID : 46919619438912 PROC :
db2sysc 0
INSTANCE: mayumi NODE : 000 DB :
FITDB
APPHDL : 0-108 APPID: *N0.mayumi.120227053151
AUTHID : MAYUMI HOSTNAME: coralxib18
EDUID : 214 EDUNAME: db2agent (FITDB) 0
FUNCTION: DB2 UDB, SW- common services, sqlnn_cmpl, probe:650
MESSAGE : ZRC=0x82040001=-2113667071=SQLD_NONSEVERE_PRGERR
"non-severe dms programming error"
DIA8532C An internal processing error has occurred.
DATA #1 : String, 62 bytes
An unexpected error was detected during statement compilation.
DATA #2 : Boolean, 1 bytes
true
DATA #3 : Boolean, 1 bytes
false
DATA #4 : Boolean, 1 bytes
true
DATA #5 : Boolean, 1 bytes
false
DATA #6 : Hex integer, 4 bytes
0x00000000
DATA #7 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 40
sqlerrmc: numIndexes not set for index recreation!
sqlerrp : SQLD11F
sqlerrd : (1) 0x82040001 (2) 0x00000000 (3)
0x00000000
(4) 0x00000000 (5) 0xFFFFD95D (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
DATA #8 : Hex integer, 4 bytes
0x00000040
DATA #9 : String, 167 bytes
Compiler error stack for rc = -2113667071:
sqlnn_cmpl[300] |
