If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > db2ckbkp on multi partition

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-24-06, 16:38
akhilg24 akhilg24 is offline
Registered User
 
Join Date: Oct 2003
Location: Austin,TX
Posts: 4
db2ckbkp on multi partition

I am using db2 V8.1 and created sample database on 4 logical nodes on one windows box. I am using the following backup commands to perform full database offline backup.

db2 backup db sample user db2admin using db2admin to d:\db2dump

db2_all "<<-0<||db2 backup db sample user db2admin using db2admin to d:\ db2dump, e:\ db2dump, f:\ db2dump, g:\ db2dump

After successful backup, created the following structure and I would like to verify the below backup image using db2ckbkp command. How to use db2ckbkp command to verify below backup image? Any help greatly appreciated.

Thanks!
GNR

d:\db2dump\sample.0\DB2\NODE0000\CATN0000\20060116 \143032.001
d:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.001
d:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143158.001
d:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.001

e:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.002
e:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143112.002
e:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.002

f:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.003
f:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143112.003
f:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.003

g:\db2dump\sample.0\DB2\NODE0001\CATN0000\20060116 \143112.004
g:\db2dump\sample.0\DB2\NODE0002\CATN0000\20060116 \143112.004
g:\db2dump\sample.0\DB2\NODE0003\CATN0000\20060116 \143198.004
Reply With Quote
  #2 (permalink)  
Old 01-24-06, 18:01
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Check the manual for information on db2ckbkp command.
Here is the portion I guess is likely to help you
  1. If the complete backup consists of multiple objects, the validation will only succeed if db2ckbkp is used to validate all of the objects at the same time.
  2. When checking multiple parts of an image, the first backup image object (.001) must be specified first.
Cheers
Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #3 (permalink)  
Old 01-24-06, 18:19
akhilg24 akhilg24 is offline
Registered User
 
Join Date: Oct 2003
Location: Austin,TX
Posts: 4
I gone through Manual but It doesn't say much on it except those two notes. I tried using *.001 first but giving somekind of errors.
Reply With Quote
  #4 (permalink)  
Old 01-24-06, 20:28
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
If you are keen to increase the chances of getting a useful response, post the command you are using and the error message you get.

I wish I were a superhuman to know what 'somekind of errors' means


Cheers
Sathyaram
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On