DB2 - Problem description
Problem IT33710 | Status: Closed |
RARE DB2CKBKP ERROR : TABLESPACE PAGE SIZE INCONSISTENT | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
Sometimes db2ckbkp may report inconsistent tablespace page size errors as below : BUFFER 8287 ================== BufAddr MemberNum PoolID Token Type Offset FileSize ObjectSize OrigSize Object Name -------- --------- ------ ----- ---- ---------- ---------- ---------- ---------- ----------- 00000000: -1 10 0 12 809984 0 16777216 0 "DMS.TABLESPACE.DATA" ERROR - Tablespace page size inconsistent for tablespace ID 10. ????, ObjPG: ????????, PoolPG: 000C5C00, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C01, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C02, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C03, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C04, BPS obj type: empty ????, ObjPG: ????????, PoolPG: 000C5C05, BPS obj type: empty ????, ObjPG: ????????, PoolPG: 000C5C06, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C07, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C08, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5C09, BPS obj type: unknown, possible LOB ... ????, ObjPG: ????????, PoolPG: 000C5FF8, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FF9, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FFA, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FFB, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FFC, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FFD, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FFE, BPS obj type: unknown, possible LOB ????, ObjPG: ????????, PoolPG: 000C5FFF, BPS obj type: unknown, possible LOB ERROR: VerifyBufferObject - error in object type 12 at location 139083514368 The problem is that db2ckbkp reports false negative when verifying DMS page. In theory, any DMS page(including lob page) that has or seems to have valid page size but fails at page constants verification can result in this issue. Hence the RESTORE using this backup image will still succeed. Â Note this reporting false negative issue happens very very rarely. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users below v11.1m4FP5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v11.1m4fp5 * **************************************************************** | |
Local Fix: | |
NA | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * All users below v11.1m4FP5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to v11.1m4fp5 * **************************************************************** | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.07.2020 28.07.2020 28.07.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |