I have a database backup that has been sent to me, but I am not sure of the database name; the default name may not have been used. Also I have a date but not a full timestamp.
I can’t find a way to restore the database without knowing the db name and a timestamp.

Is there a way to get this information from the backup file, or is there a command that will restore without that info.

Thanks
Matt

DB2 8 – UDB on windows:
DB2 administration tools level:
Product identifier SQL08024
Level identifier 03050106
Level DB2 v8.1.11.973
Build level s060120
PTF WR21365
Java development kit (JDK):
Level IBM Corporation 1.4.1

Hi,
execute the following command in CMD:
You will get something like:
SQLUBRMEDHEAD
SAMPLE
20080804220005

Second row is database name and third row is database backup timestamp. DB2 v8 on Windows is using folders. So create the following folders tree: C:\SAMPLE.0\DB2\NODE0000\CATN0000\20080804 and copy db2 image file 220005.001 to above folder.

Note: you need to change bolded text with your data.

Hope this helps,
Grofaty

Use the db2ckbkp tool