db2 7.1 fixpack 12 backup error

[bill.shannon]

Trying to do an offline backup (no database connections, no programs
running) shows an error in the db2diag.log as follows:

Obj={pool:0;obj :24;type:0} State=x27 Page=5728 Cont=0 Offset=5728
BlkSize=12 BadPage

After a bit of research, I found out that "pool:0;obj:24; type:0" refers
to the table "SYSCOLDIST " in the SYSIBM schema (select tabname,
tabschema from syscat.tables where tbspaceid = 0 and tableid = 24).

Seeing as how this is an IBM system table I'm assuming that the
production database is still intact. Is there some way that I can setup
a replication of sorts to another database server on the network in
order to accomplish a clean backup? Otherwise this error message is
stopping me from getting any sort of backup (online or offline).
I've also been suggested to run a chkdsk or scandisk on the drives
(even though it is a raid1 setup, i'm still going to inspect the
drives).

[Gert van der Kooij]

In article <11************ *********@z14g2 000cwz.googlegr oups.com>,
(bi**********@g mail.com) says...

Trying to do an offline backup (no database connections, no programs
running) shows an error in the db2diag.log as follows:

Obj={pool:0;obj :24;type:0} State=x27 Page=5728 Cont=0 Offset=5728
BlkSize=12 BadPage

After a bit of research, I found out that "pool:0;obj:24; type:0" refers
to the table "SYSCOLDIST " in the SYSIBM schema (select tabname,
tabschema from syscat.tables where tbspaceid = 0 and tableid = 24).

Seeing as how this is an IBM system table I'm assuming that the
production database is still intact. Is there some way that I can setup
a replication of sorts to another database server on the network in
order to accomplish a clean backup? Otherwise this error message is
stopping me from getting any sort of backup (online or offline).
I've also been suggested to run a chkdsk or scandisk on the drives
(even though it is a raid1 setup, i'm still going to inspect the
drives).

You can run db2dart on the table and try to find what's the real
problem. If it's in the index you can mark the index invalid and let
the system rebuild it.

[clilush]

>From what I understand, db2dart has to be run with nobody connected,
but does it make any changes to the data when I run it? Biggest thing
I'm worried about is running it and then having a chunk of "bad data"
go missing from the tables.

[Gert van der Kooij]

In article <11************ **********@z14g 2000cwz.googleg roups.com>,
clilush (bi**********@g mail.com) says...

From what I understand, db2dart has to be run with nobody connected,

but does it make any changes to the data when I run it? Biggest thing
I'm worried about is running it and then having a chunk of "bad data"
go missing from the tables.

If you run db2dart without any special parm it only checks the
database integrity without changing anything.