Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Auxerre, France
    Posts
    6

    Question Unanswered: How to repair a corrupt table ?

    <Newbie>

    After a backup error and using the following logfiles I discovered that a table is corrupt into my database. The problem is that I cannot export it (the export request never stop, I aborted it after more than 30 min)
    Now I just wanna now what a hell is going wrong with this table, why I cannot nor export nor reorg it, and more than all, how I can repair it...
    Thanks for your help

    Kerseub

    Joining an extract of the db2diag Logfile
    Starting a full database backup.

    2004-01-22-16.45.01.859000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbcres Probe:25

    DiagData
    0801 0000 ....

    2004-01-22-16.45.01.875000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:1143

    DIA8400C A bad page was encountered.
    ZRC=0x86020001

    2004-01-22-16.45.01.875001 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:1143

    Obj={pool:2;obj:109;type:1} State=x27 Page=264 Cont=0 Offset=264 BlkSize=12
    BadPage

    PID:1092 TID:960 Node:000 Title: SQLB_OBJECT_DESC
    0200 6d00 0200 6d00 0100 0000 0000 00af ..m...m........
    2d1b 0000 0000 0000 0000 0000 0000 0000 -...............
    0000 0000 0100 0000 2700 0000 0000 0000 ........'.......
    0010 0000 2000 0000 0100 0000 0200 6d01 .... .........m.
    508c da03 708e da03 P.p.

    2004-01-22-16.45.01.890000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:71

    DiagData
    0200 6d00 0200 6d00 0100 0000 0000 00af ..m...m........
    2d1b 0000 0000 0000 0000 0000 0000 0000 -...............
    0000 0000 0100 0000 2700 0000 0000 0000 ........'.......
    0010 0000 2000 0000 0100 0000 0200 6d01 .... .........m.
    508c da03 708e da03 P.p.

    2004-01-22-16.45.01.890001 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:72

    DiagData
    0000 0000 ....

    2004-01-22-16.45.01.890002 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:73

    DiagData
    0801 0000 0900 0f87 0c00 0000 .... ......

    2004-01-22-16.45.01.890003 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:74

    DiagData
    5453 5453 2020 2020 2020 2020 2020 2020 TSTS
    2020 204f 2030 3030 3030 3030 3030 3030 O 00000000000
    3030 3030 3030 3030 3030 3030 3030 2020 00000000000000

    2004-01-22-16.45.01.890004 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:75

    DiagData
    0801 0000 ....


    Dump File:G:\IBM\SQLLIB\DB2\1092960.000 Data:SQLB_PAGE

    2004-01-22-16.45.01.890006 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbReadPage Probe:71

    ** Failure on first attempt to read the page **
    0100 0286 ...

    2004-01-22-16.45.01.890007 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbcres Probe:25

    DiagData
    0801 0000 ....

    2004-01-22-16.45.01.906000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:1143

    DIA8400C A bad page was encountered.
    ZRC=0x86020001

    2004-01-22-16.45.01.906001 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:1143

    Obj={pool:2;obj:109;type:1} State=x27 Page=264 Cont=0 Offset=264 BlkSize=12
    BadPage

    PID:1092 TID:960 Node:000 Title: SQLB_OBJECT_DESC
    0200 6d00 0200 6d00 0100 0000 0000 00af ..m...m........
    2d1b 0000 0000 0000 0000 0000 0000 0000 -...............
    0000 0000 0100 0000 2700 0000 0000 0000 ........'.......
    0010 0000 2000 0000 0100 0000 0200 6d01 .... .........m.
    508c da03 708e da03 P.p.

    2004-01-22-16.45.01.906003 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:71

    DiagData
    0200 6d00 0200 6d00 0100 0000 0000 00af ..m...m........
    2d1b 0000 0000 0000 0000 0000 0000 0000 -...............
    0000 0000 0100 0000 2700 0000 0000 0000 ........'.......
    0010 0000 2000 0000 0100 0000 0200 6d01 .... .........m.
    508c da03 708e da03 P.p.

    2004-01-22-16.45.01.906004 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:72

    DiagData
    0000 0000 ....

    2004-01-22-16.45.01.906005 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:73

    DiagData
    0801 0000 0900 0f87 0c00 0000 .... ......

    2004-01-22-16.45.01.906006 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:74

    DiagData
    5453 5453 2020 2020 2020 2020 2020 2020 TSTS
    2020 204f 2030 3030 3030 3030 3030 3030 O 00000000000
    3030 3030 3030 3030 3030 3030 3030 2020 00000000000000

    2004-01-22-16.45.01.906007 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbrdpg Probe:75

    DiagData
    0801 0000 ....


    Dump File:G:\IBM\SQLLIB\DB2\1092960.000 Data:SQLB_PAGE

    2004-01-22-16.45.01.921000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbReadPage Probe:73

    ** Second read was also unsucessful ** 0100 0286 ...


    Dump File:G:\IBM\SQLLIB\DB2\1092960.000 Data:SQLB_PAGE2

    2004-01-22-16.45.01.921002 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbReadPage Probe:74

    ** Page off disk *****0000 0000 ....


    Dump File:G:\IBM\SQLLIB\DB2\1092960.000 Data:SQLB_PAGE3

    2004-01-22-16.45.01.921004 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    buffer pool services sqlbReadPage Probe:1140

    DIA8400C A bad page was encountered.
    ZRC=0x86020001

    2004-01-22-16.45.01.921005 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:50

    DiagData
    0100 0286 ...

    2004-01-22-16.45.01.921006 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:32

    DiagData
    0200 ..

    2004-01-22-16.45.01.921007 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:29

    DiagData
    6d00 m.

    2004-01-22-16.45.01.921008 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:30

    DiagData
    01 .

    2004-01-22-16.45.01.937000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:31

    DiagData
    0801 0000 ....

    2004-01-22-16.45.01.937001 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:33

    DiagData
    0040 1200 .@..

    2004-01-22-16.45.01.937002 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:28

    DiagData
    0100 0286 0100 0000 .......

    2004-01-22-16.45.01.953000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:960 Appid:none
    database utilities sqlubreadreg Probe:2228

    0100 0286 0100 0000 .......

    2004-01-22-16.45.01.968000 Instance:DB2 Node:000
    PID:1092(db2syscs.exe) TID:1484 Appid:*LOCAL.DB2.00C082154442
    database utilities sqlubcka Probe:140 Database:MIC110B

    Backup Terminated.

    P.S.: W2000 with DB2/NT 8.1.0
    </newbie>

  2. #2
    Join Date
    Jan 2004
    Location
    Auxerre, France
    Posts
    6

    More information

    I tried to reorg the indexes of this table ( with the cleaning inbdexes option )but it do not change anything : the db2diag says that the probleme is coming from this, whereas the reorg seems being successfully done...
    Don't know what I'm suppose to do right now :-(
    Please help, thanks
    Regards
    Kerseub

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to repair a corrupt table ?

    Did you try marking the speicified index bad on the table as recommended in the IBM Website

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Jan 2004
    Location
    Auxerre, France
    Posts
    6

    Question

    I'm afraid to use the /MI command.
    Do this command could crash the database?
    In case of, how can I declare this index as valid after... just in case of...
    Thanks
    Regards
    Kerseub

  5. #5
    Join Date
    Jan 2004
    Location
    Auxerre, France
    Posts
    6

    Smile GOTCHAAAAAAAAAAAAAAAA

    finally I did it... And as you can imagine it was so easy: all I've got to do was a basic reorg. I don't know why it did not work before I made reorg on specific tables and backup command is absolutely OK !!!
    Thanks to sathyaram_s for his (her ?) support...

Posting Permissions

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