Question & Answer
Question
How can I tell if corruption in DB2 is with the Table or the index?
Cause
DB2dart indicates page corruption
Answer
Results from a DB2dart may indicate corruption in a DB page. This corruption could be due to a problem within the table or with the tables index/indices.
Sample DB2dart corruption entry may be like the following example:
- Traversing extent map for:
OTR ID: 225
Parent object ID = 225 pool ID = 2 <----- Note Pool ID is 2 (see below example)
For all table objects in tablespace: 2
DAT extent anchor: 9440, in pool: 2
Traversing extent map for object type: 0
Error: Extent already marked usedin SMP (# 0, pool page 32)! Page: 9440
Extent Map traversal complete.
And:
Error: Extent number 274 in tablespace 2 is orphaned
To determine whether the corruption is in the table or index search/grep the DB2diag.log
for "Obj: {pool:2;" where the pool number is the pool from the db2dart corruption entry. This will provide the "type: #" (table or index)
- Example of out
Obj: {pool:2;obj:98;type:0} Parent={2;98} <---- type is 0
Obj: {pool:2;obj:98;type:0} Parent={2;98}
Obj: {pool:2;obj:150;type:0} Parent={2;150}
Obj: {pool:2;obj:150;type:0} Parent={2;150}
type:0 is table
type:1 is index
If type:1 is found then the index can be rebuilt to resolve the corruption.
[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"All Supported Versions","Edition":"All Editions","Line of Business":{"code":"LOB26","label":"Storage"}}]
Product Synonym
TSM ITSM ADSM tivoli storage manager
Was this topic helpful?
Document Information
More support for:
Tivoli Storage Manager
Software version:
All Supported Versions
Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows
Document number:
543749
Modified date:
17 June 2018
UID
swg21978101