Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2010
    Posts
    11

    Unanswered: Need to know the time stamp of my backup file to issue restore command

    Hi,
    if someone can help me on this:
    i have dropped my database XYZ and now cannot issue restore command. I tried "list history all for DB XYZ" but i a getting "database alias name or database name XYZ cannot be found"
    Any idea?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What is your DB2 version and OS? What is the file name of the backup image?

    Andy

  3. #3
    Join Date
    Feb 2010
    Posts
    11
    I am running DB2 version 7 on WIN2000 and the file name is 010004.001 in a dated folder 20100618.
    ... CATN0000/20100618/010004.001

    thanks.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    The timestamp is in the directory name and filename: 2010/06/18 01:00:04.

    Andy

  5. #5
    Join Date
    Feb 2010
    Posts
    11
    Thanks Andy. Now if you don't mind looking at my restore command and the message i am getting.

    Thanks a lot.
    Attached Thumbnails Attached Thumbnails Restore Command on DB2.gif  

  6. #6
    Join Date
    Feb 2010
    Posts
    11
    Also I am having problem to recreate the database I dropped in order to get me restore command working.
    Do you have any idea?

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    It's a device problem. Check db2diag.log for more information.

  8. #8
    Join Date
    Feb 2010
    Posts
    11
    I am getting exceeding number of processors in one log file.
    Also what it the best practice to recreate the same database you dropped?
    I should let you know that I am beginer with DB2...

    Thanks.
    Attached Thumbnails Attached Thumbnails 1- Restore Command on DB2.gif   2- Restore Command on DB2.gif  

  9. #9
    Join Date
    Feb 2010
    Posts
    11
    Sorry, I noticed the attachment were not clear in my previous reply.
    Attached Thumbnails Attached Thumbnails 1- Restore Command on DB2.gif   2- Restore Command on DB2.gif  

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Can you cd to D:\Backups and do ls?

Posting Permissions

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