Topic
1 reply Latest Post - ‏2012-12-11T15:37:24Z by db2girl_bella
SystemAdmin
SystemAdmin
5837 Posts
ACCEPTED ANSWER

Pinned topic Please help with corrupted database

‏2012-12-10T09:11:12Z |
Hi folks,

A v8.01 database on AIX 5.3 (both will be upgraded in the coming days) gives me serious errors when I run db2dart on it. Errors are on some indexes and LOB tables. All data entry operations on this database were done with JDBC, and no exceptions were returned, so these errors are a complete surprise.

Are there fixing tools/procedures for such problems?

What should be my next step?

Below are a few snippets from the report.

Thanks for any help you can give me.

George


Error: The page retrieved is not a root page
Error: in page 0, pool page 0, of obj 10, in tablespace 2.
Error: In reading root page, page number 0.
Error: Attempt to find the index root page for this page unsuccessful
Error: in page 656, pool page 656, of obj 10, in tablespace 2.
Scanning pages for unique index itoken(0) root page:1p.
Scanning pages for unique index itoken(1) root page:2p.
Error: forward-node-pointer for page(318) is (653) but in reality the next node
at this level is (348)
1 keyErrs found in index itoken(1) root page:2p. Dumping Page 2p.
Error: Page data will be dumped to report.


LOB inspection phase start. LOB obj: 2 In pool: 4
Error: Pool Page Number: 0 Object Page Number: 0 SBS: 4 RBS: 1178
RBS page still has SBS status for address 39424
Error: Pool Page Number: 0 Object Page Number: 0 SBS: 4 RBS: 1179
RBS page still has SBS status for address 39680
Error: Pool Page Number: 0 Object Page Number: 0 SBS: 4 RBS: 1180
RBS page still has SBS status for address 39936
LOB inspection phase end.


ERROR:
Some tables were found to have
architectural problems, and may not be usable.

ERROR:
Some tables indexes may be corrupt;
errors will be cleared for index objects
with invalid state after they have been succesfully rebuilt.

ERROR:
Some tables LOBs were found
to have problems, and may not be usable.

DB2DART Processing completed with warning(s)!
Warning(s) detected during processing.
Updated on 2012-12-11T15:37:24Z at 2012-12-11T15:37:24Z by db2girl_bella
  • db2girl_bella
    db2girl_bella
    3 Posts
    ACCEPTED ANSWER

    Re: Please help with corrupted database

    ‏2012-12-11T15:37:24Z  in response to SystemAdmin
    Do you have any database backups or have you attempted to perform a database backup?

    Index corruption can be fixed by marking the index as bad (using db2dart /mi option) and then rebuilding it.
    LOB corruption - you can try to do a table reorg with longlobdata option.