Troubleshooting
Problem
Index corruption for system catalog table "SYSIBM". "SYSCOLDIST
Symptom
You may see below error messages in db2diag.log
2015-09-29-00.08.09.358104-300 I60674A599 LEVEL: Severe
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDataFetch, probe:5364
MESSAGE : Row not found on data fetch from index!
DATA #1 : Hexdump, 8 bytes
0x07000001690AEDD0 : 0000 045E 0000 001E ...^....
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDataFetch, probe:5364
MESSAGE : Row not found on data fetch from index!
DATA #1 : Hexdump, 8 bytes
0x07000001690AEDD0 : 0000 045E 0000 001E ...^....
2015-09-29-00.08.09.359231-300 I61274A712 LEVEL: Error
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDumpKeyDataMismatch, probe:586
DATA #1 : String, 32 bytes
Table(0:264)=SYSIBM .SYSCOLDIST
DATA #2 : String, 19 bytes
Data page not fixed
DATA #3 : String, 44 bytes
Rid found in dmsWA - recid:x00000000045E001E
DATA #4 : String, 8 bytes
Page no:
DATA #5 : unsigned integer, 4 bytes
1118
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDumpKeyDataMismatch, probe:586
DATA #1 : String, 32 bytes
Table(0:264)=SYSIBM .SYSCOLDIST
DATA #2 : String, 19 bytes
Data page not fixed
DATA #3 : String, 44 bytes
Rid found in dmsWA - recid:x00000000045E001E
DATA #4 : String, 8 bytes
Page no:
DATA #5 : unsigned integer, 4 bytes
1118
2015-09-29-00.08.09.360188-300 I61987A1453 LEVEL: Error
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDumpKeyDataMismatch, probe:646
DATA #1 : String, 53 bytes
Index used to fetch the row: index root page 2, IID 1
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDumpKeyDataMismatch, probe:646
DATA #1 : String, 53 bytes
Index used to fetch the row: index root page 2, IID 1
2015-09-29-00.08.09.383041-300 E83026A787 LEVEL: Error
PID : 34930826 TID : 50030 PROC : db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-22366 APPID: *LOCAL.db2inst1.150929050825
AUTHID : DB2INST1 HOSTNAME: MYHOST1
EDUID : 50030 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, data management, sqldDataFetch, probe:5383
MESSAGE : ADM5595E An index data inconsistency is detected on table
"SYSIBM
". "SYSCOLDIST". Please run "INSPECT CHECK TABLE NAME
"SYSCOLDIST"
SCHEMA "SYSIBM " INDEXDATA RESULTS KEEP "SYSCOLDIST"_resfile.
out" on
the node that failed, and then contact DB2 support team to
report the
problem.
[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Database Objects\/Config - Indexes","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1;10.5","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
30 April 2025
UID
swg21967922