DB2DART and INSPECT fail on valid database objects, when these
objects do contain very old page headers from previous DB2
releases. Normal DML statements are working as expected against
these objects and do not report any issues.
INSPECT fails with SQL1141N and the following additional
information in the result file:
Error: The object table in tablespace ID XX does not have valid
entry for table with ID YY.
Error(s) identified during processing.
DB2DART /T on the object in question will report problems like
this:
Error: Version 500 BPS Header DATLEN (4040) incorrect, DB2DART
processing will assume value of 4048, in pool page 64,
object page 0, from object ID 65535, pool 0.
Error: Data file header record has bad offset 3988, expected
3996.
Error: Unable to obtain the page count of DAT object, assume 1
page.
Error: Version 500 BPS Header DATLEN (4040) incorrect, DB2DART
processing will assume value of 4048, in pool page 64,
object page 0, from object ID 65535, pool 0.
Error: Version 500 BPS Header DATLEN (4040) incorrect, DB2DART
processing will assume value of 4048, in pool page 64,
object page 0, from object ID 65535, pool 0.
Error: Unable to get table descriptor record.
Error: DMS DFHR (a) -- Invalid record offset.
Error: in page 0, pool page 64, of Object 65535, in tablespace
0.
Error: Page data will be dumped to report. |
****************************************************************
* USERS AFFECTED: *
* N/A *
****************************************************************
* PROBLEM DESCRIPTION: *
* DB2DART and INSPECT fail on valid database objects, when *
* these *
* objects do contain very old page headers from previous DB2 *
* *
* releases. Normal DML statements are working as expected *
* against *
* these objects and do not report any issues. *
* *
* *
* *
* INSPECT fails with SQL1141N and the following additional *
* *
* information in the result file: *
* *
* *
* *
* Error: The object table in tablespace ID XX does not have *
* valid *
* entry for table with ID YY. *
* *
* Error(s) identified during processing. *
* *
* *
* *
* DB2DART /T on the object in question will report problems *
* like *
* this: *
* *
* *
* *
* Error: Version 500 BPS Header DATLEN (4040) incorrect, *
* DB2DART *
* processing will assume value of 4048, in pool page 64, *
* *
* object page 0, from object ID 65535, pool 0. *
* *
* Error: Data file header record has bad offset 3988, expected *
* *
* 3996. *
* *
* Error: Unable to obtain the page count of DAT object, assume *
* 1 *
* page. *
* *
* Error: Version 500 BPS Header DATLEN (4040) incorrect, *
* DB2DART *
* processing will assume value of 4048, in pool page 64, *
* *
* object page 0, from object ID 65535, pool 0. *
* *
* Error: Version 500 BPS Header DATLEN (4040) incorrect, *
* DB2DART *
* processing will assume value of 4048, in pool page 64, *
* *
* object page 0, from object ID 65535, pool 0. *
* *
* Error: Unable to get table descriptor record. *
* *
* Error: DMS DFHR (a) -- Invalid record offset. *
* *
* Error: in page 0, pool page 64, of Object 65535, in *
* tablespace *
* 0. *
* *
* Error: Page data will be dumped to report. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to V98FP4 and above. *
**************************************************************** |
