Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11

    Unanswered: migration and hadr

    db2 ese 9.5 on p/linux (planning for V10)
    reading the doc about db2 migration I came across some restrictions.
    rolling upgrade is only supported for modification level (fixpack)
    so if we want to migrate from 9.5 to 9.7 or 10 we need to stop hadr and upgrade the primary - which means this environment is not available.
    Yes the db2 code can be installed before - but while executing the migration the instance needs to be stopped..
    after this : drop all db on standby machine and upgrade this machine - backup on primary and restore on standby and activate hadr again
    this backup restore does not impact the availability.
    but if something goes wrong in the migration of primary it might be possible, you need to restore v9.5 db to return to previous situation
    as we have 12 db in this instance with reasonable size, this can take a while
    The question would : has anyone already done a similar migration 9.5 to 10 with hadr. Can you confirm the roadmap I indicated for this process..
    thanks for any idea/info that might help
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You could set up the DB2 10.1 instance separately from the DB2 9.5 instance (on both HADR members), then upgrade databases one by one via backup/restore. This way only one database at a time will be unavailable.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    thanks for the update..
    checking this solution.... (related to the size of db's and time needed to b/r )
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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