Hi Guys,

I will be involved in DB2 upgrade this Wed.

I will be taking following steps to do it.

1. Save a copy of DBM and DB settings Via DB2SUPPORT.
2. Online backup with Logs included. and additional logs till the database is brought down.
3. Installing DB2 on the server using "Work with existing".
4. Migrating DB with Migrate DB command.


At this moment I do not remember anything else, please help me if I am miss anything.

And also, please help me with commnad to restore database and rollforward till most recent transaction in case any thing fails and I need to rollback.


I had few problems with test on mirror. Rollback was forced via fresh installation of previous version.

Please help me if I am missing anything.

Thanks
DBFinder

In addition to dbm cfg, you also need to save "db2set -all". You can use the db2cfexp command with the backup option to save the config info. Online backup can be used to go back to v8 (save all the logs created while the backup is running and until db is brought down for migration in some dir). However, if the migrate db command fails and you decide to migrate via restore, you have to use an offline image. So, if you have time, it's best
to take an offline db backup prior to starting the migration.

i would rather go with an offline bkp

YES! Another version of DB2 can read the backup image, but not the logfiles required for the rollforeward!

Hi,

We are Upgrading to V9.5 Workhgroup Server edition from V8.1.9 WSE

It seems that on this upgrade are skipping taking Offline Backup of database POS. (To Save Time)

I don’t really recommend that but the point was to use online backup already taken as a scheduled job.



ONLINE backup starts at 1:00am and finishes by 2:45 am. The LOGS are included.

We restore the database and rollforward to the END OF LOGS.

ROLLFORWARD DATABASE POS TO end of logs and stop OVERFLOW LOG PATH (G:\POS_Daily_Backup')


This is only for the situation if we have to rollback to 8.2.



We are going to stop at 5:30 am whereas online backup finishes @ 2:45 am.



So, I will copy the all the logs after the last LOG included.



Question:

To rollforward to last transaction committed till 5:30,
Do I have to issue another rollforward till 5:30 am (2:45 -5:30) ??
or the same will rollforward till 5:30am .



Please advise me.

As stated above and in your other post. you will have to do an offline backup. V9.5 cannot read the logs of V8.x.

Andy

To go back to v8 using an online backup taken prior to migration, you need:

- extract the logs stored in the backup image plus all the logs created between 2:45-5:30. Place all required logs in the same dir (ie. G:\POS_Daily_Backup')

- restore db

- rollforward using the following command:
ROLLFORWARD DATABASE POS TO end of logs and stop OVERFLOW LOG PATH (G:\POS_Daily_Backup') noretrieve

This command will apply the logs stored in the overflow log path

Prior to issuing the rollforward command, check the active log dir to make sure that there are no log files... this is so that db2 doesn't try to apply them first.

Actually this was for the case if we have to roll back to 8.2.



Please advise

Bella,

Which is better
POS TO end of logs and stop OVERFLOW

OR

POS TO end of logs and Complete OVERFLOW

Thanks

stop and complete are equivalent, doesn't matter which one you specify