View Single Post
  #5 (permalink)  
Old 12-29-08, 11:18
ak835 ak835 is offline
Registered User
 
Join Date: Apr 2008
Posts: 29
Arrow

modified my script:

db2 -v restore db AAUD2305 from <PATH1> to <PATH> into AAUD2305 redirect without rolling f
orward
db2 -v "set tablespace containers for 2 using (path '/../../NODE0000/SQL00001/SQLT0002.0')"
db2 -v "set tablespace containers for 3 using (path '/../../tmpts02/AAUD2305/tmp02')"
db2 -v "set tablespace containers for 5 using (path '/../../tmpts02/AAUD2305/usr01')"
db2 -v "set tablespace containers for 6 using (path '/../../srvr2287/NODE0000/SQL00001/SYSTOOLSPACE')"

db2 -v restore database AAUD2305 continue
#db2 -v rollforward database AAUD2305 complete
#db2 connect to AAUD2305
#db2 list tables

db2 -v terminate


i tried verifying my backup image & found few error there:

[1] Buffers processed: #ERROR: Tablespace control block checksum error detected against tablespace SYSCATSPACE,PoolID 0
ERROR: Tablespace container list checksum error detected against tablespace TEMPSPACE1,PoolID 1
ERROR: Tablespace container list checksum error detected against tablespace USERSPACE1,PoolID 2
ERROR: Tablespace container list checksum error detected against tablespace TEMPSPACE02,PoolID 3
ERROR: Tablespace control block checksum error detected against tablespace COG0001T,PoolID 4
ERROR: Tablespace container list checksum error detected against tablespace USERSPACE01,PoolID 5
ERROR: Tablespace container list checksum error detected against tablespace SYSTOOLSPACE,PoolID 6
###############

Image Verification Complete - ERRORS DETECTED: 7

Any clues?
Regards
Abhijeet
Reply With Quote