+

Search Tips   |   Advanced Search

Installing and preparing DB2

Use this information to install DB2 or DB2 pureScale for use with HCL Digital Experience.

All DB2 instructions apply to DB2 pureScale except where specifically noted.

  1. To install DB2 or the DB2 client and the required fix pack, follow the instructions that are provided with the DB2 documentation.

  2. If DB2 is installed on another system than HCL Portal, copy the driver JAR files from the DB2 server to the Portal server. The typical location for these files on the DB2 server is in the db2_home/java directory. Place these driver files within the wp_profile_root directory, for example:

  3. Ensure that the DB2 instance port was added to the services file during the DB2 installation.AIX Linux :

    1. Get the value for the TCP/IP service name (SVCENAME). Open a shell and log in as the instance owner. Enter the following command:

        db2 "get dbm cfg"|grep (SVCENAME)

      A typical value for the SVCENAME is (SVCENAME) = db2c_db2inst1

    2. Get the DB2 port number by using the SVCENAME value. Enter the following command:

        echo /etc/services | grep your_SVCENAME_value

      A typical output for the port number:

      your_SVCENAME_value 50000/tcp

      In this example, 50000 is the port number.

    Windows :

    1. Get the value for the TCP/IP service name (SVCENAME). Open a DB2 Command Window and enter the following command:

        db2 get dbm cfg | findstr (SVCENAME)

      A typical value for the SVCENAME is (SVCENAME) = db2c_DB2

    2. Get the DB2 port number by using the SVCENAME value. Enter the following command:

        type %SystemRoot%\system32\drivers\etc\services | findstr db2c_DB2

      A typical output for the port number:

      your_SVCENAME_value 50000/tcp

      In this example, 50000 is the port number.


What to do next

Use the Configuration Wizard to set up and configure the database to work with HCL. We can use the wizard to create custom scripts that you or your database administrator can use to configure the database. We can also use the wizard to automatically set up and configure the database. The wizard creates instructions and scripts that are based on your selections and provided data. More topic information about Configuration Wizard can be found in our product base documentation here.

When using the wizard and provide information about the database for your environment, be aware of the following considerations:

(Optional) After you transfer your data to DB2 , run a configuration task to enable support for high availability recovery (HADR) and rollforward recovery.