Upgrading a Db2 server to Db2 pureScale environment

Upgrading to Db2 pureScale environment on Linux® and UNIX requires that you first upgrade to Db2 version 12.1 and then convert to Db2 pureScale environment.

Before you begin


Restrictions

  • Only automatic storage table spaces are supported in a Db2 pureScale environment and all the table spaces must be on an IBM® Storage Scale storage path.
  • Additional upgrade restrictions apply. Refer to Upgrade restrictions for Db2 servers. Review the complete list.

About this task

The following tasks describe the steps for direct upgrade from Db2 version 10.1 or earlier to Db2 version 12.1 pureScale environment.

Scenario 1

About this task

In this scenario, the catalog table space is Database Managed Space (DMS) and the user table spaces are mostly System Managed Space (SMS). The database is not enabled for automatic storage.

Procedure

To upgrade a Db2 server to Db2 version 12.1 pureScale environment:

  1. Log on to the Db2 server as root.
  2. Install Db2 version 12.1.
    Run the db2setup command and select the Install New option on the Install a Product panel to install a new copy of Db2 version 12.1. Do not create an instance.
  3. Run the db2ckupgrade command from the new Db2 installation path to verify that your databases and instance are ready for upgrade.
  4. Upgrade your Db2 version 9.7 or version 10.1 instances.
    Refer to Upgrading Db2 11.5 and 11.1 instances.
  5. Upgrade your databases.
    Refer to Upgrading databases.
  6. Run the db2cluster_prepare command to set up IBM Storage Scale storage path. Refer to Setting up IBM Storage Scale file system for a Db2 pureScale environment.
  7. Create a new automatic storage enabled Db2 version 12.1 database on the IBM Storage Scale storage path.
  8. Load the data into the new database using the db2move with the copy option.
  9. Run the db2checkSD command to verify that your database is ready to be upgraded to a Db2 pureScale environment.
  10. Convert the instance to a Db2 version 12.1 pureScale environment. Refer to Converting your existing Db2 instances to a Db2 pureScale environment.

Scenario 2

About this task

In this scenario, the catalog table space is System Managed Space (SMS) and the user table spaces are Database Managed Space (DMS). The database is not managed by automatic storage.

Procedure

To upgrade a Db2 server to Db2 version 12.1 pureScale environment:

  1. Log on to the Db2 server as root.
  2. Install Db2 version 12.1.
    Run the db2setup command and select the Install New option on the Install a Product panel to install a new copy of Db2 version 12.1. Create an ESE instance.
  3. Run the db2cluster_prepare command to set up IBM Storage Scale storage path. Refer to Setting up IBM Storage Scale file system for a Db2 pureScale environment.
  4. Create a new automatic storage enabled Db2 version 12.1 database on the IBM Storage Scale storage path.
  5. Convert the table spaces to use automatic storage. Use a redirected restore operation with the TRANSPORT and SET TABLESPACE CONTAINERS command and specify the USING AUTOMATIC STORAGE parameter, to move all the schemas to the new database. Refer to Converting table spaces to use automatic storage.
  6. Run the db2checkSD command to verify that your database is ready to be upgraded to a Db2 pureScale environment.
  7. Convert the instance to a Db2 version 12.1 pureScale environment. Refer to Converting your existing Db2 instances to a Db2 pureScale environment.

Scenario 3

About this task

In this scenario, the catalog table space is Database Managed Space (DMS) and the user table spaces are mostly Database Managed Space (DMS).

Procedure

To upgrade a Db2 server to Db2 version 12.1 pureScale environment:

  1. Log on to the Db2 server as root.
  2. Run the ALTER DATABASE command with the ADD STORAGE ON storage-path option to enable your database for automatic storage.
  3. Install Db2 version 12.1.
    Run the db2setup command and select the Install New option on the Install a Product panel to install a new copy of Db2 version 12.1. Create a Db2 Enterprise Server Edition instance.
  4. Run the db2cluster_prepare command to set up IBM Storage Scale storage path. Refer to Setting up IBM Storage Scale file system for a Db2 pureScale environment.
  5. Run the db2ckupgrade command from the new Db2 installation path to verify that your databases and instance are ready for upgrade.
  6. Take a full offline backup of your database.
  7. Do a redirected restore of the backup database into the Db2 version 12.1 instance. Convert the table spaces to automatic storage and move the table spaces to IBM Storage Scale storage path. Refer to Converting table spaces to use automatic storage.
  8. Run the db2checkSD command to verify that your database is ready to be upgraded to a Db2 pureScale environment.
  9. Convert the instance to a Db2 version 12.1 pureScale environment. Refer to Converting your existing Db2 instances to a Db2 pureScale environment.