IBM Support

Upgrade guide for DB2 Servers in HACMP Environments

Preventive Service Planning


Abstract

If your DB2 server is configured in a HACMP environment and you plan to upgrade the server, refer to this guide.

Content

DB2 servers can be configured to make use of the High Availability Cluster Multi-Processing (HACMP™) strategy to help ensure high availability. Upgrading your DB2 servers in this environment is similar to any other DB2 server upgrade, with minor differences that you should be aware of.


Assumptions:

  • Two node HACMP cluster
  • DB2 instances and databases located on shared disks
  • Each node contains its own locally installed DB2 server product. (Note: You must have the exact same install path on both nodes)

High level overview of the steps:

1. Install the DB2 server product you are upgrading to on both nodes.
2. Stop HACMP on both the active and standby nodes.
3. Upgrade your DB2 server on the active node only, as per the standard documentation found in the DB2 Knowledge Center.
4. Install the sample HACMP scripts on both the active and standby nodes.
5. Startup your HACMP environment.
6. Perform post-upgrade verification steps.

Example
Upgrading from DB2 UDB Version 9.7 to DB2 for LUW Version 10.1 (or higher), running HACMP for AIX cluster managing software with two nodes; active and standby. Here are the steps you would follow:

1) Stop HACMP on both nodes
Stop the HACMP environment on both the active and standby server:

smitty hacmp → System Management → Manage HACMP services → Stop Cluster Services

2) Install DB2 for LUW Version v10.1, v10.5 or v11.1
Install DB2 for LUW Version 10.1, 10.5 or 11.1 (preferably the latest fix pack available) on both the active and standby nodes. Install to a different path than where your previous product is installed.

DB2 UDB Version (previous version) will be installed under:

/opt/IBM/db2/V9.7

Install DB2 for LUW Version 10.1, 10.5 or 11.1 in a different path such as :

/opt/IBM/db2/V10.1

Refer to the DB2 Knowledge Center documentation for details on installing your new DB2 server and ensure you meet all the specified pre-requisites.

3) Upgrade your DB2 Server
Perform the DB2 server upgrade on your active node only. Refer to the "Upgrading a DB2 server (Linux and UNIX)" page of the DB2 Knowledge Center for the DB2 version you are upgrading to for upgrade instructions. Follow all the necessary steps including: pre-upgrade steps, upgrading the DB2 server itself and performing post-upgrade steps.

4) Install sample HACMP scripts (Optional)
Install the sample HACMP scripts provided in the DB2 instance you have just upgraded on both the active and standby nodes.

These scripts can be found in the <INSTANCE_HOME>/sqllib/samples/es path. This step will install those scripts to the default installation location, /usr/bin. You should check if there are already HACMP scripts installed in your environment and if they have been customized. If they have been customized, do not install new scripts as this would overwrite the customization.

As an example, installing sample HACMP scripts includes the following steps:

1. Go to <INSTANCE_HOME>sqllib/samples/es path
2. Locate the following three files:
    • rc.db2pe.eee (DPF) or rc.db2pe.ee (non-DPF)
    • db2_proc_restart.eee (DPF) or db2_proc_restart.ee (non-DPF)
    • db2_inst_ha.local
3. Copy rc.db2pe.eee/ee to rc.db2pe
4. Copy db2_proc_restart.eee/ee to db2_proc_restart
5. Use db2_inst_ha.local to install the HACMP scripts (run once for each clustered database).
    • db2_inst_ha.local <hostname> . <database_name>


    • Where:
      hostname is the host of the node
      . is the current directory
      database_name is the database name


5) Start up your HACMP environment
As root, run the following command on both active and standby nodes:

Smitty hacmp → System Management → Manage HACMP services → Start Cluster Services


6) Post-upgrade verification
After the DB2 server environment has been upgraded and the HACMP services have been restarted on both nodes, verify that the DB2 server and your HACMP services are running correctly.

Refer to the Knowledge Center documentation for post-upgrade verification steps.

To verify your HACMP services, some basic steps include:
  • Run 'clstat' on both active and standby nodes to verify the cluster is back online.
  • Perform a failover test, i.e. as root run:
Smitty hacmp → System Management → Manage HACMP services → Stop Cluster Services (select action, "Move Resource Groups")

  • Analyze /var/hacmp/logs/hacmp.out log file to make sure everything is setup as expected.

Refer to Knowledge Center documentation on HACMP for further details on how you can best validate that your environment is ready.

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"High Availability - Cluster Management","Platform":[{"code":"PF002","label":"AIX"}],"Version":"9.7;10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Workgroup Server"}]

Document Information

Modified date:
16 June 2018

UID

swg21461186