I backup db2 using NBU 7.5 with a script and it all backups fine. Now I need to restore it to the same server under as a different database on the same server. I looked all day long and I am completely confused. I have checked the following sources but nothing:
1. NBU DB2 Admin Guide for Unix, Windows and Linux.
I wonder if there is a straight forward script outthere or step-by-step that I can follow to do my restore.
I want to place the restored db into the following directory /backup. Can I just modify the db2_restore sample script to accomplish this?
I've tried to use the NBU recovery wizard but it does not work since I cannot login as the db2 user. I am confident it is pretty simple, and I am just missing that "check mark".
I cannot login as the db2 user....
You need to login as db2 user. The restore will only work if done by same user that performed the backup.
See the following in NBU for DB2 Admin Guide: http://www.symantec.com/docs/DOC5166
About an alternate restore (topic starts on p. 90)
p. 91: Table 4-5 Types of restores permitted
@Marianne. I have read the admin guide several times now, and I can tell you that is confusing, for example on page 94 it talks about using the "Backup, Archive andRestore Interface" but it does not work, then on the same section (step 3) talks about entering the db2 restore command:
3. On the destination client, type the DB2 RESTORE command.
Type this command in the following format:
db2 restore db db_being_restored load lib_path into
So do I still need to modify the db2.conf, use the GUI and then run a command?
just modify the db2.conf, then run the db restore command, if this is the case:
How many commands do I need to execute on the client?
And, how do I tell the db2 restore from which NBU backup to restore?