Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2014
    Posts
    5

    Red face Unanswered: Corrupted SYSIBM.SYSAUDITUSE

    Hi,

    db2dart shows that my SYSIBM.SYSAUDITUSE is corrupted, I am not able to connect to database please help. How to recover SYSIBM.SYSAUDITUSE table......

    Table inspection start: SYSIBM.SYSAUDITUSE

    Data inspection phase start. Data obj: 1283 In pool: 0
    Data inspection phase end.


    Index inspection phase start. Index obj: 1283 In pool: 0
    Error: CSUM read error for pool page 3435, from object ID 1283, pool 0,
    Error: BPS Tail incorrect CBITS value -- (a)
    Error: in page 3, pool page 3435, of obj 1283, in tablespace 0.
    Error: CSUM read error for pool page 3435, from object ID 1283, pool 0,
    Error: Page data will be dumped to report.
    Error: BPS Header Checksum Flag incorrect.
    Error: BPS Header problems found
    Error: in page 3, pool page 3435, of obj 1283, in tablespace 0.
    Error: CSUM read error for pool page 3435, from object ID 1283, pool 0,
    Error: Failed to determine object relative page number, for given pool page 3435 of object ID 1283 pool 0 type (x1)
    Error: Bad header field root page 3435
    Error: in page 3, pool page 3435, of obj 1283, in tablespace 0.
    Error: CSUM read error for pool page 3435, from object ID 1283, pool 0,
    Error: CSUM read error for pool page 3435, from object ID 1283, pool 0,
    Index inspection phase end.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    you should open a pmr for this
    after db2-lab has requested some page-dumps they might be able to zap some pages to correct corruptions ..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Feb 2014
    Posts
    5
    Quote Originally Posted by przytula_guy View Post
    you should open a pmr for this
    after db2-lab has requested some page-dumps they might be able to zap some pages to correct corruptions ..
    Is it possible to restore SYSIBM.SYSAUDITUSE from old backup without loosing new data? ....

  4. #4
    Join Date
    Feb 2014
    Posts
    5

    Cool Solved

    After 3 days of extensive research i brought back my database online without any loss of data.

    Procedure i did to recover my database after corruption is as follows:

    1) Brought the database offline
    2) Ran db2dart utility again

    db2 dbname /db > D:\report.txt

    3) Noted down the corrupted table as mentioned in the report
    that is: Index Object id and tablespace id
    In my case it is 1283 and 0

    4) Ran db2dar dbname /MI
    Enter Index object id and tablespace id

    VOILA thats it.......your database and data is recovered and you are back into business.

    cheers

  5. #5
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    You have the index object corrupted, not the data object.
    So you can try to mark the index object as invalid by:
    Code:
    db2dart your_dbname /MI /TSI 0 /OI 1283
    DB2 should rebuild this index automatically afterwards depending on your INDEXREC db parameter setting either during db restart or the first access to this table.
    Regards,
    Mark.

  6. #6
    Join Date
    Feb 2014
    Posts
    5
    Thanks a lot.......It is working fine now

Posting Permissions

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