Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2007
    Posts
    2

    Unanswered: Apply fixpack on HADR Servers

    I have to apply fixpack on DB2 V9.1 FP5 to upgrade it to fp7. The database has HADR implementation.

    I know about the rolling fixpack option but the team wants to shut down the HADR completely on both primary & standby, apply the fixpack and bring up the hadr.

    The steps i can think of are: -

    Stop HADR ON peer:-
    db2 deactivate db zinga
    db2 STOP HADR ON db zinga
    db2stop

    Stop HADR ON primary:-
    db2 STOP HADR ON DB zinga
    db2stop

    Apply fixpack on both the servers/update instance/das update

    Start HADR ON peer:-
    db2 START HADR ON DB zinga AS STANDBY

    Start HADR ON primary:-
    db2 START HADR ON DB zinga AS PRIMARY

    Let me know in case I am doing something wrong since I am not sure with the steps right now.

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You can't stop HADR completely without using a backup and restore to re-establish the standby. I am not 100% sure about 9.1, but you should be able to:

    1. deactivate db on standby
    2. db2stop on standby
    3. db2iupdt on standby
    4. db2start on standby
    5. activate db on standby (this should casue HADR to be Peer mode again)
    6. Takeover HADR on standby to switch roles
    7. deactivate db on old primary (now standby)
    8. db2stop on old primary (now standby)
    9. db2iupdt on old primary (now standby)
    10. db2start on old primary (now standby)
    11. activate db on old primary (now standby)
    12. Takeover HADR on standby (old primary) to switch roles back to original state
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Even if the application is stopped for you to do an upgrade, I don't see a problem with Marcus_A's approach. There is no need to shut down the servers.

    When shutting down the databases/instances, you should always do the primary first. This will ensure that no transaction happens after standby is shut down.

    HTH

    Sathyaram

    --
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    "You can't stop HADR completely without using a backup and restore to re-establish the standby. "
    There is no problem in stopping and starting hadr completely. as long as you do not bring the standby out of rollforward - no problem. we even have tsa and on accept we stop the both servers and apply fixpack and restart all - without backup/restore..

    The first procedure requested can be followed without problem..
    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

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Hi There,
    In the thread listed below: -
    Apply fixpack on HADR Servers
    you wrote that you did stop the HADR on both servers,apply fixpack and restart all.
    Can you please list down the steps to be taken on primary/standby server for it. It is quite imp for me.Thanks in advance
    Yes, my salary is also very important to me. I did stop spoonfeeding long time ago. All info is in the book, so at least : have a look and try to understand, OR hire somebody that does and could inform you how to do this in the future..
    Maintaining a cluster domain using db2haicu
    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

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by przytula_guy View Post
    I did stop spoonfeeding long time ago. All info is in the book, so at least : have a look and try to understand
    I agree 100% with you, Guy.

    Personally, I don't mind the very basic questions even, as long as it shows that they have put in efforts to understand, like this one

    http://www.dbforums.com/db2/1669494-...ror-query.html

    But, the ones below are annoying.

    http://www.dbforums.com/db2/1669487-...ry-urgent.html
    http://www.dbforums.com/db2/1669386-...out-folks.html

    -
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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