Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2006

Tip: Looking for answers? Try searching our database.

db2 7.1 fixpack 12 backup error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bill.shannon@gmail.com - 06 Feb 2006 19:04 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.