DB2 FOR LUW / DB2FORLUW / B10 - DB2

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.

****************************************************************
* USERS AFFECTED:                                              *
* All users below v11.1m4FP5                                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to v11.1m4fp5                                        *
****************************************************************

NA

****************************************************************
* USERS AFFECTED:                                              *
* All users below v11.1m4FP5                                   *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to v11.1m4fp5                                        *
****************************************************************

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

27.07.2020
28.07.2020
28.07.2020