Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Corrupted database backups db2ckbck

Status
Not open for further replies.
juliecd

juliecd

IS-IT--Management
Sep 7, 2010
1
CA
Hi,

We have a problem that the db2ckbck command return unsuccessful results. The same result is returned with online backups and offline ones. However, the system is working properly, connections to the database are working and all "inconsistent tablespaces" are available as well.

The database backups used to work and somehow, they became corrupted.

DB2 version is 8.2.4 and OS is Windows Server 2003 32 bit.

C:\Documents and Settings\Administrator>db2ckbkp D:\backupcgs\CGS.0\DB2\NODE0000\CATN0000\20100829\181354.001

[1] Buffers processed: #######ERROR - Tablespace page size inconsistent for tablespace ID 8.
ERROR - Tablespace page size inconsistent for tablespace ID 8.
ERROR - Tablespace page size inconsistent for tablespace ID 8.
ERROR - Tablespace page size inconsistent for tablespace ID 8.
ERROR - Tablespace page size inconsistent for tablespace ID 8.
###ERROR - Tablespace page size inconsistent for tablespace ID 2.
#ERROR - Tablespace page size inconsistent for tablespace ID 11.
ERROR - Tablespace page size inconsistent for tablespace ID 11.
ERROR - Tablespace page size inconsistent for tablespace ID 11.
ERROR - Tablespace page size inconsistent for tablespace ID 11.
ERROR - Tablespace page size inconsistent for tablespace ID 11.
ERROR - Tablespace page size inconsistent for tablespace ID 11.
#####ERROR - Tablespace page size inconsistent for tablespace ID 2.
#ERROR - Tablespace page size inconsistent for tablespace ID 2.
#ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
ERROR - Tablespace page size inconsistent for tablespace ID 0.
#ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
#####ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.
ERROR - Tablespace page size inconsistent for tablespace ID 2.

1.
1.

ERROR! No DATA.POOL.TABLE!
ERROR! No DB configuration!
ERROR! No BUFFER.POOL.FILE found!
ERROR! No MIRRORLOG.FILE.HEADER found!
ERROR! No END.OF.INITIAL.DATA found!

Image Verification Complete - ERRORS DETECTED: 697
 
Status
Not open for further replies.

Similar threads

handle907
  • Locked
  • Question
ADM10501W - Health indicator "Database Automatic Storage Utilization"
Replies
0
Views
394
handle907
handle907
ColeFern
  • Locked
  • Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
239
ColeFern
ColeFern
Khaleel2408
  • Locked
  • Question
Unable to connect to DB2 database server over sec port using SSL from windows ODBC DSN client
Replies
0
Views
229
Khaleel2408
Khaleel2408
jayanthsid
  • Locked
  • Question
Will Decode function works in IBM DB2 Database?
Replies
1
Views
141
fredericofonseca
fredericofonseca
jpotucek
  • Locked
  • Question
Recovering a Dropped Database
Replies
0
Views
81
jpotucek
jpotucek

Part and Inventory Search

Sponsor

Back
Top