My company bought a new server for DB2. I'm tring to migrate database from the old server to the new server.
I've finished DB2 installation. After installing the application system, I'm going to do offline backup and restore it to the new server. Then, I'm going to test database/application from some desktops. If everything is OK, I'll move the new server to the rack.
Since test needs time/I also need some buffer time/production enviroment cannot put down for half day, I'll have to do the second backup/restore. I'm wondering which type of backup I should go with, offline or online?
1) Perform an online backup of you production system. Be sure to INCLUDE LOGS.
2) Restore the backup image to you new server. Be sure to use the LOGTARGET clause.
3) ROLLFORWARD the newly restored DB
a) copy the logs from step 2 to the active log directory of the DB
b) execute "ROLLFORWARD DB MyDB COMPLETE". This will either work or give you the minimum time to rollforward.
c) if you got the minimum time do: "ROLLFORWARD DB MyDB to <timestamp in b> AND COMPLETE"