This problem affects DB2 10.5 fix pack 4 only.
Rollforward through a load with copy yes with delete phase might
result in index corruption, causing rollforward to fail with an
index manager programming error.
The rollforward command might generate FODC_IndexError with
db2diag.log entries like the following:
2014-10-06-03.32.31.936640-240 I18863096A566 LEVEL: Error
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliUpdateHighKeyInPlace,
probe:802
MESSAGE : flagsFromLogRecord =
DATA #1 : Hexdump, 2 bytes
0x07000000073ED140 : 0024
.$
2014-10-06-03.32.31.938636-240 I18863663A566 LEVEL: Error
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliUpdateHighKeyInPlace,
probe:803
MESSAGE : updateHighKeyFlags =
DATA #1 : Hexdump, 2 bytes
0x07000000073ECD36 : 0022
."
2014-10-06-03.32.31.940060-240 I18864230A4846 LEVEL:
Severe
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliUpdateHighKeyInPlace,
probe:803
MESSAGE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
DATA #1 : String, 15 bytes
spaceToBeFreed:
DATA #2 : unsigned integer, 8 bytes
10
DATA #3 : String, 15 bytes
spaceForInsert:
DATA #4 : unsigned integer, 8 bytes
779
...
2014-10-06-03.32.31.965169-240 I18871101A555 LEVEL:
Severe
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:500
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
....
2014-10-06-03.32.32.087116-240 I18887879A556 LEVEL:
Severe
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:2764
RETCODE : ZRC=0x87090054=-2029453228=SQLI_PRG_ERR "Program
error"
DIA8575C An index manager programming error occurred.
2014-10-06-03.32.32.091101-240 I18888436A541 LEVEL:
Severe
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:2764
MESSAGE : Index object = {TBSPACEID=<15>; OBJECTID=<9>} Parent
object =
{TBSPACEID=<11>; OBJECTID=<15>}
2014-10-06-03.32.32.093068-240 I18888978A572 LEVEL:
Severe
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:2764
MESSAGE : Dumping index page, page size (in hex):
DATA #1 : Hexdump, 4 bytes
0x07000000073ECE90 : 0000 1000
....
2014-10-06-03.32.32.098525-240 E18890166A824 LEVEL: Error
PID : 11796628 TID : 34925 PROC :
db2sysc 0
INSTANCE: hachi NODE : 000 DB : BEER
APPHDL : 0-7243 APPID: *N0.hachi.141006075357
AUTHID : HACHI HOSTNAME: coralpib111
EDUID : 34925 EDUNAME: db2agent (BEER) 0
FUNCTION: DB2 UDB, index manager,
sqliDumpFlightRecFromAllMembers, 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/hachi/sqllib/db2dump/DIAG0000/FODC_IndexError_2014-10-06-
03.32
.32.096152_11796628_34925_000/". |
