Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    15

    Unanswered: DB2 10.5 Express-C Packed Desriptor Corruption.

    I have tonight had a power failure (and a UPS failure .. siiigh) that has resulted in a Packed Descriptor corruption, rendering one of my tables inaccessible. I have read up on the issue and the documentation states that resolution requires I obtain the service password from IBM Support in order to run the DB2CAT command. Ok, well seeing as this is the free version, is that even possible ?? There is no way I am able to afford IBM support for this and frankly all I want to do is to DROP the table in question, but it keeps returning the following error and subsequenty FODC dumps:

    2014-08-21-17.40.11.286000-240 I15293F537 LEVEL: Severe
    PID : 2780 TID : 1256 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : dbname
    APPHDL : 0-14 APPID: *LOCAL.DB2.140821213424
    AUTHID : DB2ADMIN HOSTNAME: My-PC
    EDUID : 1256 EDUNAME: db2agent (dbname)
    FUNCTION: DB2 UDB, catcache support, sqlrlc_systables_fetch_from_disk, probe:200
    MESSAGE : Corrupt PD->length in tableB2ADMIN.tablename

    2014-08-21-17.40.11.302000-240 I15832F8010 LEVEL: Severe
    PID : 2780 TID : 1256 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000 DB : db2_name
    APPHDL : 0-14 APPID: *LOCAL.DB2.140821213424
    AUTHID : DB2ADMIN HOSTNAME: My-PC
    EDUID : 1256 EDUNAME: db2agent (db2name)
    FUNCTION: DB2 UDB, catcache support, sqlrlc_systables_fetch_from_disk, probe:201
    MESSAGE : Length in PD=15280, LFD length=8288, DMS length=8288
    DATA #1 : LOB Descriptor, PD_TYPE_LOB_DESCRIPTOR, 60 bytes
    SQLDX_LD: Size:60
    x0000 lfd_check 0x49
    x0001 lfd_version 10
    x0002 lfd_numsegs 1
    x0003 lfd_flags 0x00
    x0004 lfd_size 8288
    x000C lfd_life_lsn 000002ED8B3A8068
    x0014 lfd_mini_numsegs 0
    x0015 lfd_first 4
    x0016 lfd_descsize 60
    x0018 lfd_last_pages 16
    x001C lfd_last_bytes 8288
    x0038 lfd_dir Regular Directory Offsets
    lfd_dir[0]: 320 (16K)
    Hexdump of LOB descriptor follows:
    490A 0100 0000 0000 6020 0000 6880 3A8B
    ED02 0000 0004 3C00 1000 0000 6020 0000
    0000 0000 0000 0000 0000 0000 0000 0000
    0000 0000 0000 0000 4001 0000
    DATA #2 : String, 11 bytes
    Corrupt PD:
    DATA #3 : Hexdump, 1256 bytes
    0x000000024D58D9C0 : B03B 0000 0001 0400 A0B2 1100 0000 0000 .;..............
    0x000000024D58D9D0 : 7A18 0000 0000 0000 8A18 0000 0000 0000 z...............
    0x000000024D58D9E0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58D9F0 : 0000 0001 4300 FFFF 0000 0001 4300 FFFF ....C.......C...
    0x000000024D58DA00 : 0000 0000 0000 0000 0600 0000 0000 0000 ................
    0x000000024D58DA10 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DA20 : 0000 0000 0000 80BF 0000 0000 FEFF FFFF ................
    0x000000024D58DA30 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DA40 : 0000 0000 0002 8000 0400 0000 0600 0000 ................
    0x000000024D58DA50 : 0400 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DA60 : 0000 0000 0600 0000 F01A E03F F301 C742 ...........?...B
    0x000000024D58DA70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DA80 : 0000 0000 8008 0000 3810 0000 0000 0000 ........8.......
    0x000000024D58DA90 : 0000 0000 4008 0000 0000 0000 0000 0000 ....@...........
    0x000000024D58DAA0 : 0000 0000 C83A 0000 0000 0000 4810 0000 .....:......H...
    0x000000024D58DAB0 : 0010 0800 0000 0200 E703 0000 0000 FEFF ................
    0x000000024D58DAC0 : E404 0000 0000 0000 0000 0000 0000 1200 ................
    0x000000024D58DAD0 : 1200 0000 0001 0400 0000 0000 0000 0000 ................
    0x000000024D58DAE0 : 0000 004E 0030 204E 2052 2020 0000 2020 ...N.0 N R ..
    0x000000024D58DAF0 : 2020 0120 4E4E 534E 0000 0000 0000 0000 . NNSN........
    0x000000024D58DB00 : 0000 0000 0000 2012 0919 1609 5709 8001 ...... .....W...
    0x000000024D58DB10 : 2014 0219 1558 0027 7004 2014 0820 1811 ....X.'p. .. ..
    0x000000024D58DB20 : 1619 6000 2012 0919 1609 5709 8001 2014 ..`. .....W... .
    0x000000024D58DB30 : 0219 1558 0027 7005 2020 2020 2020 2020 ...X.'p.
    0x000000024D58DB40 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DB50 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DB60 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DB70 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DB80 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DB90 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DBA0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DBB0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DBC0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DBD0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DBE0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DBF0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DC00 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DC10 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DC20 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DC30 : 2020 2020 2020 2020 4442 3241 444D 494E DB2ADMIN
    0x000000024D58DC40 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DC50 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DC60 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DC70 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DC80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DC90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DCA0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DCB0 : 0000 0000 0000 0000 5241 5744 4154 4120 ........RAWDATA
    0x000000024D58DCC0 : 2020 2020 2020 2020 2020 494E 4445 5845 INDEXE
    0x000000024D58DCD0 : 5320 2020 2020 2020 2020 2020 2020 2020 S
    0x000000024D58DCE0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DCF0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD00 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD10 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD20 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD30 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD40 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD50 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD60 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD70 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD80 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DD90 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DDA0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DDB0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DDC0 : 2020 2020 2020 2020 2020 2020 2020 2020
    0x000000024D58DDD0 : 2020 2020 2020 2020 2020 2020 0000 0000 ....
    0x000000024D58DDE0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DDF0 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DE00 : 0000 0000 0000 0000 FFFF FFFF FFFF FFFF ................
    0x000000024D58DE10 : 7E00 0000 0000 0000 0000 0000 0000 0000 ~...............
    0x000000024D58DE20 : 0000 0000 0000 0000 0000 0000 0400 0000 ................
    0x000000024D58DE30 : 0000 0020 0000 0000 0000 0000 0400 0000 ... ............
    0x000000024D58DE40 : FFFF FFFF 7A55 BC37 0000 0000 0000 0000 ....zU.7........
    0x000000024D58DE50 : 0000 0000 400C 0000 0400 0501 6400 0000 ....@.......d...
    0x000000024D58DE60 : FFFF FFFF 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DE70 : 0800 0008 00FF 4EFF 0000 0000 0000 0000 ......N.........
    0x000000024D58DE80 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DE90 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
    0x000000024D58DEA0 : 4143 545F 4441 5445 ACT_DATE


    Is any kind soul please advise how I am able to simply drop this table, so I may re-create it.
    Many thanks, Fin.
    Last edited by tembo; 08-22-14 at 04:08.

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    If you have archive-logging enabled, recover the database to the point in time just before the power-failure - because you have have other errors.

    Otherwise (circular logging), If you can connect to the database and successfully access *other* tables then Create a new empty database. Copy the DDL from old database and run into the new database. Copy the data from old database to new database. Drop the old database. Recreate the missing table. You can use the db2move tool to automate much of this if you carefully study the docs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •