IBM Support

Stopping DB2 when using MSCS

Question & Answer


Question

How should you stop a DB2 server when DB2 is configured for use with Microsoft Clustering?

Answer

It is recommended to use the Microsoft Cluster Administration user interface to start and stop the DB2 server.

You can also use the Windows command line to start or stop the DB2 server.

With Windows 2008 and earlier version you can use the commands:

To start the DB2 instance:

cluster resource <resourcename> start

To stop the DB2 instance:

cluster resource <resourcename> stop

With Windows 2012 you can use the commands:

To start the DB2 instance:

Start-ClusterResource <resourcename>

To stop the DB2 instance:

Stop-ClusterResource <resourcename>

If you try to stop the DB2 server using the 'db2stop' command then this will be treated as a failure of the resource by the Microsoft Cluster. This failure will then trigger the action configured the Microsoft Cluster configuration, for example, a failover or a restart of the resource.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"High Availability - Cluster Management","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21675599

Page Feedback