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 - 06 Feb 2006 19:34 GMT
> Trying to do an offline backup (no database connections, no programs
> running) shows an error in the db2diag.log as follows:
[quoted text clipped - 14 lines]
> (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 - 07 Feb 2006 04:07 GMT
>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 - 07 Feb 2006 07:43 GMT
> >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.