Hi,
I am using db2 v 9.5. I have stored the back up file 'DQ5A.0.DB2.NODE0000.CATN0000.20100322180707.001' under the directory 'G:\DBRestore\DQ5A.0\db2\NODE0000\CATN0000\2010032 2'.
I tried to restore using the below command
restore database DQ5A from G:\DBRestore\ without prompting

It is giving below error:
SQL2542N No match for a database image file was found based on the source database alias "DQ5A" and timestamp "" provided.

I executed the below command to know about the db and node

db2 => list db directory

System Database Directory

Number of entries in the directory = 1

Database 1 entry:

Database alias = DQ5A
Database name = DQ5A
Local database directory = G:
Database release level = c.00
Comment = Cataloged by db2relocate
Directory entry type = Indirect
Catalog database partition number = 0
Alternate server hostname =
Alternate server port number =

db2 => list node directory

Node Directory

Number of entries in the directory = 2

Node 1 entry:

Node name = NDE2005A
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = sew08895
Service name = 50000

Node 2 entry:

Node name = NODE1
Comment =
Directory entry type = LOCAL
Protocol = TCPIP
Hostname = localhost
Service name = test

Please tell me how to restore successfully.

where did you get the DQ5A.0.DB2.NODE0000.CATN0000.20100322180707.001 from ?

you can copy this file in the directory G:\DBRestore and then issue the command or cd to the location of the file and issue your restore command.

In one of the earlier versions, the backup file naming/location on Windows was bought in line with the Unix platforms.

Cheers
Sathyaram

I upgraded to DB2 V 9.5. After that the backup file is getting created with name DQ5A.0.DB2.NODE0000.CATN0000.20100322180707.001 under the directory G:\dbbkups\db2\q500 instead of 'G:\dbbkups\db2\q500\DQ5A.0\DB2\NODE0000\CATN0000\ yyyymmdd directory.