Preparing for a fresh installation Product Master service

Before you install the Product Master service, you must meet the following requirements.

Product Master supports Db2® service, IBM® Db2 Version 11.5, or Oracle Database Version 19c database. These database services are not installed with Product Master and hence you need to complete following tasks before you start the Product Master service installation.
Important: IBM Db2 and Oracle administration topics are not with in the scope of this information.
  1. If you are want to connect to the Db2 service, complete the tasks that are listed in the Db2 service-related tasks section.
  2. If you are want to connect to an external IBM Db2 database, you need to install and set up the IBM Db2 database. For more information, see Setting up your Db2 database in the Product Master documentation.
  3. If you are want to connect to the Oracle database, you need to install and set up the Oracle database. For more information, see Setting up your Oracle Database in the Product Master documentation.
  4. To use the Free text feature, you need to install OpenSearch on the Red Hat® OpenShift® Container Platform. For more information, see Installing OpenSearch on the Red Hat OpenShift Container Platform.
  5. If you want to enable single sign-on for Product Master service, follow the instructions that are listed in the Enabling single sign-on topic.

Db2 service-related tasks

If you choose the Db2 service within the Cloud Pak for Data as your database, you need to complete following.
  1. Collect Db2 pod details.
  2. Creating table spaces in the Db2 pod for the Product Master.
Note: The Db2 operator should be installed in the same namespace where IBM Cloud Pak® for Data is deployed. The default namespace is zen.

Collect Db2 pod details

Proceed as follows to get the password, database name, and service name details for the Db2 pod. These details are required in the app-secret while installing Product Master.
  1. Go to a project where the Db2 instance pod is running and log in to the pod.
  2. Get the password of the db2inst1 user by using the following commands.
    oc rsh c-<instancename>-db2u-0
cat /secrets/db2instancepwd/password
  3. Get the created database name by using the following commands.
    oc rsh c-<instancename>-db2u-0
su db2inst1
db2 list database directory
  4. Get the service name of the database that is going to be used as the IBM Db2 host database name in the app-secret by using the following command. The port number is 50000.
    oc get svc  | grep db2 | grep -v None | grep <Db2host>

Creating table spaces in the Db2 pod for Product Master

Proceed as follows to create table spaces in the Db2 pod. This is a one-time activity.
  1. Log in to the IBM Db2 instance pod.
  2. Run the following commands.
    $oc rsh c-<instancename>-db2u-0
$ su db2inst1
$ cd
$db2 list database directory
  3. Create tablespaces_creation.sh script file by using the following content. Replace <database_name> with the actual database name that you are going to use for the Product Master. 
    db2 connect to <database name>
db2 CREATE BUFFERPOOL USERSBP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL INDXBP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL BLOBBP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL TEMPUSRBP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL TEMPSYSBP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL TEMPUSRBP32 SIZE AUTOMATIC PAGESIZE 32K;
db2 CREATE BUFFERPOOL TEMPSYSBP32 SIZE AUTOMATIC PAGESIZE 32K;
db2 CREATE BUFFERPOOL XML_DATA_BP SIZE AUTOMATIC PAGESIZE 32K;
db2 CREATE BUFFERPOOL XML_LARGE_BP SIZE AUTOMATIC PAGESIZE 32K;
db2 CREATE BUFFERPOOL XML_INDX_BP SIZE AUTOMATIC PAGESIZE 32K;
db2 CREATE BUFFERPOOL ITA_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ITA_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ITD_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ITD_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ITM_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ITM_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ICM_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL ICM_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL LCK_DATA_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE BUFFERPOOL LCK_IX_BP SIZE AUTOMATIC PAGESIZE 16K;
db2 CREATE LARGE TABLESPACE USERS PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL USERSBP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE INDX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL INDXBP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE BLOB_TBL_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL BLOBBP FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE XML_DATA PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL XML_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 100M;
db2 CREATE LARGE TABLESPACE XML_LARGE_DATA PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL XML_LARGE_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 100M;
db2 CREATE LARGE TABLESPACE XML_INDEX PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL XML_INDX_BP FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 100M;
db2 CREATE LARGE TABLESPACE ITA_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITA_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ITM_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITM_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ITD_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITD_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ICM_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ICM_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE LCK_DATA PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL LCK_DATA_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ITA_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITA_IX_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ITM_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITM_IX_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ITD_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ITD_IX_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE ICM_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL ICM_IX_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE LARGE TABLESPACE LCK_IX PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL LCK_IX_BP NO FILE SYSTEM CACHING AUTORESIZE YES INCREASESIZE 1G;
db2 CREATE USER TEMPORARY TABLESPACE TEMP_USER PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL TEMPUSRBP;
db2 CREATE SYSTEM TEMPORARY TABLESPACE TEMP_SYSTEM PAGESIZE 16K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL TEMPSYSBP;
db2 CREATE USER TEMPORARY TABLESPACE TEMP_USER32 PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL TEMPUSRBP32;
db2 CREATE SYSTEM TEMPORARY TABLESPACE TEMP_SYSTEM32 PAGESIZE 32K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL TEMPSYSBP32;
db2 CREATE SCHEMA PIM AUTHORIZATION db2inst1;

db2 update db cfg for <database name> using LOGFILSIZ 60000;
db2 update db cfg for <database name> using LOGPRIMARY 40;
db2 update db cfg for <database name> using LOGSECOND 2;
  4. Run the tablespaces_creation.sh script file by using the following commands.
    chmod 755 tablespaces_creation.sh
./tablespaces_creation.sh

What to do next

Proceed with the Product Master service installation. For more information, see Installing Product Master service.