Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010

    Unanswered: Getting error while trying to restore

    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.

  2. #2
    Join Date
    Aug 2001
    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.

    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2010
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts