Rolling forward through an online load with incremental
indexing, copy yes and delete phase might corrupt the index or
fail the rollforward command.
The following are examples of error information from output of
DB2 commands and db2diag.log:
rollforward db TEST to end of logs tablespace (DMS1, DMS2)
online
SQL1042C An unexpected system error occurred. SQLSTATE=58004
2012-04-05-23.03.56.989500-240 I328151E655 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_data (secondary
logging function), probe:50
MESSAGE : GPTG_LOG
DATA #1 : Hexdump, 32 bytes
0x00002AAB2A362128 : 026B 0300 0400 0300 0400 0100 0400 0000
.k..............
0x00002AAB2A362138 : 0000 0000 0600 0000 0500 0100 4200 1000
............B...
2012-04-05-23.03.56.991662-240 I328807E531 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:2112
RETCODE : ZRC=0x87090052=-2029453230=SQLI_SMP_ERR "SMP problems"
DIA8573C An invalid space map page was found.
2012-04-05-23.03.57.016404-240 I329339E522 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:2112
MESSAGE : Index object = {TBSPACEID=<3>; OBJECTID=<4>} Parent
object =<
{TBSPACEID=<3>; OBJECTID=<4>}
2012-04-05-23.03.57.018267-240 I329862E556 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:2112
MESSAGE : Dumping index page, page size (in hex):
DATA #1 : Hexdump, 4 bytes
0x00002AAACC7DBD28 : 0010 0000
....
... ...
2012-04-05-23.03.57.056487-240 I337706E585 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging function), probe:30
DATA #2 : String, 108 bytes
Index object = {TBSPACEID=<3>; OBJECTID=<4>; OBJECTTYPE=<INX>}
Parent object = {TBSPACEID=<3>; OBJECTID=<4>}
... ...
2012-04-05-23.03.57.074556-240 I341644E771 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging function), probe:30
DATA #1 : String, 173 bytes
Running the following command before and after restart database<
may provide useful problem determination information.<
Replace DBNAME with the real DB name if not provided.
DATA #2 : String, 94 bytes
db2dart TEST /di /tsi 3 /oi 4 /ps 10923 /np 100 /v h /scr n
/rptn iTsi3oi4pg10923o+99.rpthex
2012-04-05-23.03.57.076299-240 E342416E795 LEVEL:
Error
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, index manager, sqliLogDartDumpPagesCmd,
probe:20
MESSAGE : ADM14005E The following error occurred: "IndexError".
First<
Occurrence Data Capture (FODC) has been invoked in the
following<
mode: "Automatic". Diagnostic information has been
recorded in the<
directory named<
"/home/test/sqllib/db2dump/FODC_IndexError_2012-04-05-23.03
.57.076224_12965_150_000/".
... ...
2012-04-05-23.03.57.167761-240 I360335E494 LEVEL:
Warning
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, recovery manager,
sqlpForwardRecoveryTblSpace, probe:2000
MESSAGE : Tablespaces left in rollforward-in-progress state.
2012-04-05-23.03.57.170011-240 E360830E581 LEVEL:
Severe
PID : 12965 TID : 46913063741760 KTID :
13374<
PROC : db2sysc
INSTANCE: test NODE : 000 DB : TEST
APPHDL : 0-59 APPID: *LOCAL.test.120406030336
AUTHID : test<<
EDUID : 150 EDUNAME: db2agent (TEST)
FUNCTION: DB2 UDB, data protection services, sqlpRfwFillSQLCA,
probe:11500
MESSAGE : SQL1042C An unexpected system error occurred.
DATA #1 : String, 19 bytes
Roll Forward Error:
DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
0x87090052 |
