Identify a db2 backup file type

[martynh]

We create 2 types of full backup: online with logs included and (once a week) offline. The backup file names have the same format but, of course, if you want to restore from them, the commands are slightly different. I'm trying to script automatic restores from these files onto a different server. Is there anyway I can ask DB2 what sort of backup is in one of these files?

DB2 8.2.4, RHEL 3 on Compaq DL380 G3

Thanks

Martyn Hodgson
Integrated International Payroll Ltd.

 

[gregsimpson]

Martyn,

not got db2 in front of me today. Have you tried commands such as

db2 list history backup

Cheers
Greg

 

[martynh]

The list history command is fine so long as you have the source DB2 instance available. In my scenario I'm trying to set up something that would work if the source DB server had died and all I had was the backup file.

In fact I have managed to answer my own question. The command db2ckbkp, when given a backup file name, gives you everything you could ever want to know about the backup. The -h option was enough for me, but there's loads more.