Deploy the SCT Inst configuration data to the FTM database

You can update the FTM database with the SCT Inst configuration data.

Before you install an FTM database to use with Red Hat® OpenShift®, download the database files that are provided in the FTM artifacts pod. For more information about getting files from the artifacts container for your offering, see Getting the files from the artifacts container for your FTM offering.

The database configuration scripts for SCT Inst are located in the ftm-artifacts pod at the following paths.
  • /share/artifacts/config/sct-inst/db/unix/ in UNIX.
  • /share/artifacts/config/sct-inst/db/win/ in the Windows operating system.

The steps to deploy the SCT Inst configuration data are shown in the following list.

  1. Open a Db2® command window and go to the directory where the database configuration scripts are downloaded.
  2. Set the name of the queue name prefix and the application name prefix in the ftmip_config.properties file.
  3. Run the following script to update the database and redirect the output to a log file to verify the installation.
    ftmip_config.sh db-name db-schema-name | tee -a log-file
    The parameters in the script are described in the following list.
    db-name
    The name of the FTM database.
    db-schema-name
    The database schema name to use.
    log-file
    The name of the file that contains the redirected output.