Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2005
    Posts
    31

    Unanswered: Restore Questions

    Hello,
    I have copied a backup of my database from one server to another and attempted a restore using the following command from the Unix prompt:
    Code:
    db2 restore database prod user xxxxxxxx using xxxxxxxx from /backups taken at 20080207000514 without rolling forward without prompting
    Unfortunately my connection was canceled so when I tried to connect to the database I received an error stating that the database PROD is in a restore/pending state. I restarted the restore with the above command, but not sure how I can tell if it is running or not. Can anyone direct me to some commands that I can run to see if the restore is currently running?

    The database and instance names are the same on both machines and the DB2 version is 8.1. Thank you.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Code:
    db2 list utilities show detail
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jul 2005
    Posts
    31
    Thank you for the help.

  4. #4
    Join Date
    Jul 2005
    Posts
    31
    Hi,
    When I tried your suggestion I get the following:
    Code:
    >db2 list utilities show detail
    SQL0104N  An unexpected token "utilities" was found following "LIST".
    Expected tokens may include:  "ACTIVE".  SQLSTATE=42601
    I also did a help on "list" and "utilities" does not come up as an option. Thank you

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    May be it's not available at your fixpak level, which you chose not to share with us. Try "db2pd -d yourdb -recovery"
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Jul 2005
    Posts
    31
    How do I determine what fix pack I am at? Thank you.

  7. #7
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    db2level
    ........
    ---
    "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
  •