Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2015
    Posts
    1

    Unanswered: stop db2 in a hadr environment

    Hi,

    We have a hadr environemnt with db2 10.1 ,AIX and TSA configured.I need to know the steps for bringing down db2(db2stop) in a hadr environment.Do we need to bring down TSA as well so that nodes do not get failover to secondary site.Please help.We have a two node system.

  2. #2
    Join Date
    Sep 2003
    Location
    United States
    Posts
    65
    Provided Answers: 1
    Put the TSA in maintenance mode, in that mode it is basically in disabled mode. So if you stop db2 it will NOT do what it usually does when its active - that is one way.

    Other way is using TSA commands stop the resource offline - this is more appropriate method and when maintenance is done, bring the resource online. Here is one article that can help you do this - http://www.ibm.com/developerworks/ti...em-automation/

    IBM Could have made this simple, but that's what it is.
    >>
    >> Learn PHP/MySQL for free https://www.youtube.com/watch?v=mpQts3ezPVg
    >> Free Web Hosting with PHP, MySQL, Website Builder : http://www.000webhost.com/862861.html

  3. #3
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    db2stop is a cluster-aware command.
    http://www-01.ibm.com/support/knowle...0.html?lang=en

    So, it should be enough to do the following:
    1. On standby:
    deactivate db ...
    db2stop
    2. On primary:
    deactivate db ...
    db2stop force

    You can check the state of resources with lssam then.
    They should be locked.
    Regards,
    Mark.

Posting Permissions

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