Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Upgrading Production database to v9.5

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    i would rather go with an offline bkp
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by rahul_s80
    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!

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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.
    Last edited by DBFinder; 05-26-09 at 11:15.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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.

  8. #8
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by ARWinner
    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
    Actually this was for the case if we have to roll back to 8.2.



    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

  9. #9
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Bella,

    Which is better
    POS TO end of logs and stop OVERFLOW

    OR

    POS TO end of logs and Complete OVERFLOW

    Thanks

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    stop and complete are equivalent, doesn't matter which one you specify

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •