Install CDP for DB2 on IBM DB2 pureScale

CDP can be installed and configured in IBM DB2 pureScale, a clustered environment. CDP must be installed on every node of the cluster. One node requires the full installation; all other nodes in the cluster require the files only installation using the install_files option.

Prerequisites

• Download and extract the CDP for DB2 software

• Check version compatibility

• Enable SSL on each node

• Set the PATH variable on each node

• Set the VWSPATH Variable on each node

• Check the page size requirements

• Check the Shell

• Create the “ingrian” user

• Change permissions for the lib/ext folder” on each node

Steps

1. Perform full installation on one node using the steps mentioned in Quick Start the section. This step installs CDP files, loads associated Java files, and creates metadata tables, stored procedures, and UDFs.

2. Perform files only installation on the other nodes. Run the following command to perform files only installation on all other nodes.

           sh install.sh install_files
   

   Respond to all installer prompts and wait for the installer to complete before performing installations on other nodes. This step installs shared libraries required for CDP on nodes other than the node where full CDP installation is done.

3. Configure the CDP_DB2.properties file on each node.

Upgrade CDP on IBM DB2 pureScale

To upgrade CDP on IBM DB2 pureScale, use any of the following options:

Upgrade full CDP installation on one node

This option allows you to perform full upgrade on one node using the following command. Refer to the Upgrade CDP section for detailed instructions.

        sh install.sh upgrade_db <destination_db>

Respond to all installer prompts and wait for the installer to complete before performing upgrading on other nodes.

Upgrade “files only” installation on all other nodes

Run the following command to perform “files only” upgrade on all other nodes in the cluster.

        sh install.sh upgrade_files

Respond to all installer prompts and wait for the installer to complete before performing installations on other nodes.

Uninstall CDP from IBM DB2 pureScale

To completely uninstall CDP from IBM DB2 pureScale:

Uninstall full CDP installation from one node

On the node where full CDP installation exists, execute:

        sh install.sh uninstall_db <destination_db>

Respond to all installer prompts and wait for the installer to complete before performing uninstallation on other nodes.

Uninstall “files only” installation from all other nodes

Run the following command to perform “files only” uninstallation on all other nodes in the cluster:

        sh install.sh uninstall_files

Ensure to complete the uninstallation on one node before proceeding to the other nodes.