Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009

    Unanswered: DB2 Restore Status

    Hi Guys,

    I am running db2 v7.1 on SunOS 5.8 with circular logging. I was attempting to do a full db restore with an offline backup using the command "db2 restore database tdwdb from /backup2 taken at 20080929133559 into tdwdb". However it gave the error no start db manager. So, I issued the db2start command and used the same resrore command.

    It's been 2 days and I wanted to check the status of the restore. So I issued the command "db2 get db cfg for tdwdb". However I noticed "Restore Pending" had a value of No. Does this mean that the db isn't being restored? Also, since I was doing a full restore and all the backups where offline; shouldn't the restore have taken place while the db was offline?

    Thanks for the assistance, this is my first restore

  2. #2
    Join Date
    May 2003
    DB2 V7 is very old, but I assume this will work:

    db2 list utilities show detail

    If a restore is still active, it will show up in the output of the above command.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2009


    Thanks for the quick response. It was listed as running after I used the "db2 list applications command". Thanks once again

Posting Permissions

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