Latest versionsfixlist
11.1.0.6 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC79630 Status: Closed

DB2DART & INSPECT NEED TO REMOVE THE CHECK DMS HEADER FREE SPACE OFFSET

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
db2dart & INSPECT report a false message about DMS Header free 
space offset, this is normal to have this, and the REDIST should 
already be fixed to cope with this condition.  the check should 
be remove from both db2dart & INSPECT commands. 
 
db2dart: 
 
         Traversing extent map for object type: 0 
      Extent Map traversal complete. 
   Table inspection start: DB2INST1.SAMPLE 
 
      Data inspection phase start. Data obj: 17183  In pool: 8 
      Error: DMS Header free space offset 0x2BC points inside 
the slot directory space 0x2D4. 
      Error: in page 4212, pool page 12100596, of Object 17183, 
in tablespace 8. 
      Error: Page data will be dumped to report. 
 
        000       *0030 3FD0 0000 1074 0500 0002 0000 0008* 
*.0.....t........* 
        010       *00B8 A3F4 431F 0000 0000 0000 0000 0E2F* 
*....C...........* 
        020       *0000 0238 AF16 F5E0 1E08 0204 0000 0000* 
*...8............* 
        030       *                                         ** 
        030  000  *016A 0012 0012 0000 0046 02BB 0000 0C20* 
*.j.......F......* 
        040  010  *84C7 0000 3F8E 3F66 3F38 3F10 3EE2 3EBA* 
*.......f.8......* 
        050  020  *3E8C 3E64 3E36 3E0E 3DE0 3DB8 3D8A 3D62* 
*...d.6.........b* 
 
INSPECT: 
 
Action: CHECK DATABASE 
Result file name: SAMPLE.dat 
 
        Database phase start. 
        Tablespace phase start. Tablespace ID: 8 
        Table phase start (ID Signed: 17183, Unsigned: 17183; 
Tablespace ID: 8) : 
        Data phase start. Object: 17183  Tablespace: 8 
        Error: In page 4212, physical page 4212 of object 17183 
in tablespace 8, pagesize 16384. 
        Error: Hexadecimal dump of page contents. 
0000  *00303FD0 00001074 05000002 00000008* *.0.....t........* 
0010  *00001074 431F0000 00000000 0000DF0F* *...tC...........* 
0020  *00000238 AF16F5E0 1E080204 00000000* *...8............* 
0030  *016A0012 00120000 004602BB 00000C20* *.j.......F......* 
... 
        Error: Found error type (invalid free block pointer 
field value 0x2BC in the data header points inside the slot 
directory space 0x2D4). 
      Data phase end. 
    Table phase end. 
  Tablespace phase end. 
Database phase end. 
 
You could also see the following : 
 
         Index inspection phase start. Index obj: 17183  In 
pool: 8 
          Scanning pages for unique index itoken(0) root 
page:1p. 
          Scanning pages for index itoken(1) root page:2p. 
          Error: Number of data rows 99913 does not match number 
of index entries 100000. 
          Total key errors found: 1. 
         Index inspection phase end.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* DB2DART & INSPECT NEED TO REMOVE THE CHECK DMS HEADER FREE   * 
* SPACE                                                        * 
* OFFSET                                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to to DB2 v9.5 Fixpack 9                             * 
****************************************************************
Local Fix:
Run Classic REORG: 
 db2 "REORG TABLE DB2INST1.SAMPLE" 
or 
 db2 "REORG TABLE DB2INST1.SAMPLE USE <tablespace>"
available fix packs:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
First Fixed in DB2 v9.5 Fixpack 9
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC84122 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
04.11.2011
08.03.2012
28.03.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP9
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.9 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.