db2 restore db in a separate server in DB2 8.1.5 in AIX 5.1
Posted on 2004-10-08
My env is: DB2 8.1.5 in AIX 5.1 system and on connecting to database we can see:
Database Connection Information...
Database server = DB2/6000 8.1.5
SQL authorization ID = DB2INST1
Local database alias = xxxxx
I have a full backup from Server A, but I need to restore the it on Server B to create a testdb with the same
name. When I try to do a restore,
by: db2 restore db xxxxx from xxxxx.0.db2inst1.NODE0000.CATN0000.20040910133320.001
I get the error: SQL2036N The path for the file or device
"xxxxx.0.db2inst1.NODE0000.CATN0000.20040910133320.001" is not valid.
I know the bkup exists because I FTP'ed it from prod to test. verified by listing it in test. How do I
recover successfully to create a testdb in the target server? Same name of db, instance, and every thing else.
Do I need to drop the exiting database befor doing the recover? Quickly need to fix this. Any help will be appreciated.