Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2008
    Posts
    1

    Unanswered: can't restore without database name

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    execute the following command in CMD:
    Code:
    type your_db_image_file | more
    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

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Use the db2ckbkp tool
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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