Clonnig db2 in AIX

[nmorph]

Hello to ALL

I have a 2 diferent servers running AIX 5.2 and DB2 8.2.0. The first server is a productive machine and the second is a test environment. My question is that can anyone explai how could I update the second server with the productive DB. I have tried out to run an online backup on the productive machine and perform an restore on the second machine, but for some reason the restore was not sucessfully done. The second DB it's on rollforwd pendding. The is anyone that could help me???

Regards

Nuno Catarino

 

[gregsimpson]

There's a couple of things. If you're storage etc, is the same on both then I think you won't have had to do a re-directed restore, so I'm assuming you didn't.

I am assuming the following

You've entered something similar to

db2 restore db "dbname" continue

to get it into the rollforward pending state.

I think you now need to let it rollforward through the logs, so you need to get a copy of the logs from the time the backup was taken on your other machine. You should be able to identify these by entering

db2 get db cfg for "dbname" |grep –I log)

Once you've got the logs copied across enter

db2 “rollforward db "dbanme" and complete”

This will probably not work, but will give you a timestamp whereby you can then enter the following, using the timestamp returned above

db2 “rollforward db "dbname" to <timestamp> and complete”

Good luck

Cheers
Greg