Restore Questions

jyoung · #1 (**permalink**) 02-11-08, 13:11

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.

n_i · #2 (**permalink**) 02-11-08, 14:40

Code:

db2 list utilities show detail

jyoung · #3 (**permalink**) 02-12-08, 07:10

Thank you for the help.

jyoung · #4 (**permalink**) 02-12-08, 07:15

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