Upgrade the patch package for DB2pureScale, and upgrade RSCT, TSA, GPFS, and DB2 by process.

DB2pureScale is a database cluster with both high scalability and high availability. The db2pureScale cluster contains separate software products such as RSCT, TSA, and GPFS. These products are included in the DB2 installation media. If you want to upgrade the patch package for DB2pureScale, you must follow certain procedures to upgrade RSCT, TSA, GPFS, and DB2.

DB2 pureScale is a database cluster with both high scalability and high availability. The db2 pureScale cluster contains separate software products such as RSCT, TSA, and GPFS. These products are included in the DB2 installation media. If you want to upgrade the patch package for DB2 pureScale, you must follow certain procedures to upgrade RSCT, TSA, GPFS, and DB2.

DB2 pureScale cluster is a cluster solution with high scalability and availability. This solution integrates multiple products, including hardware and software. The DB2 pureScale cluster adopts the shared storage cluster architecture.

Figure 1. architecture of the DB2 pureScale Cluster

This figure describes the DB2 pureScale cluster architecture. DB2 pureScale can be composed of multiple hosts (nodes) that communicate with each other over the IB network and Ethernet. Each node is connected to shared storage. The cluster schedules resources of each node through the automatic load balancing function. From the perspective of the client, DB2 pureScale is a database environment and does not need to worry about which node to connect and how the cluster is formed. The key technology of the DB2 pureScale cluster is the proven global locking and memory management technologies in the IBM mainframe.

In this cluster solution, software products include GPFS products that manage shared storage, TSA products that integrate all resources, and DB2 products. These components are included in the installation media of the entire DB2 product. The new patch Package released by DB2 pureScale may include updates to these three products. Therefore, when upgrading the DB2 pureScale patch, check whether these products need to be upgraded and how to perform security upgrades.

Preparations before the patch upgrade

Before upgrading the patch package, you need to confirm whether the GPFS and TSA need to be upgraded, and you also need to completely stop the DB2 pureScale database cluster. During the upgrade, ensure that the DB2 pureScale database is not restarted.

Check the TSA version

First, check whether the TSA version in the new patch package is higher than the installed version. Check that the tool is included in the new patch package. In this case, the patch pack DVD is decompressed under/home/temp/DB2v9.8/v9.8fp5.

List 1. supported versions of TSA

 # /home/temp/DB2v9.8/v9.8fp5/server/db2/aix/tsamp/db2cktsa -v install  3.2.6.2 

Listing 2. Target TSA version

 # /home/temp/DB2v9.8/v9.8fp5/server/db2/aix/tsamp/db2cktsa -v media  3.2.7.1 

In this case, the target version of TSA is 3.2.7.1, which is higher than the installed version 3.2.6.2. Therefore, you need to upgrade multiple TSA clusters.

Check GPFS version

The method for checking the GPFS version is similar to checking the TSA, and the tool is included in the new patch package.

Listing 3. Installed GPFS version

 # /home/temp/DB2v9.8/v9.8fp5/server/db2/aix/gpfs/db2ckgpfs -v install  3.3.0.14 

Listing 4. Target GPFS version

 # /home/temp/DB2v9.8/v9.8fp5/server/db2/aix/gpfs/db2ckgpfs -v media  3.4.0.13 

The installed version 3.3.0.14 listed in the List is earlier than the target version 3.4.0.13. Therefore, you need to upgrade the GPFS cluster software and environment.