Run the data setup utility for the database for Red Hat OpenShift

The data setup utility is used to import and export the data in the database for the FTM offerings that are supported by Common Services.

After the database is installed and configured, install and run the Data Setup Utility (DSU). You need to import the data for the Common Services components for your FTM offering. For more information, see Installation.

The files that are needed to run the DSU are included in the artifacts container for the FTM offerings that have Common Services components.

Run the DSU inside the FTM artifacts pod

The DSU utility can be run inside the FTM artifacts pod. The artifacts pod contains a Db2® container that can be used to run the DSU utility.

The following list shows the steps to run the DSU utility inside the FTM artifacts pod.
  1. Transfer your DSU files to FTM by using the SFTP service. Place the files in the /opt/ibm/application/dsu directory. Files in this directory appear in the Db2 container of the artifacts pod in the /opt/ibm/ftm/dsu directory.
  2. Create the DSU properties file such that all references to the DSU spreadsheet files use the absolute path to those files. Set the log file location to /tmp, as shown in the following example.
    logFileLocation = /tmp
XREFFileName    = /opt/ibm/ftm/dsu/FeatureXREF.xlsx
mapFileName     = /opt/ibm/ftm/dsu/FeatureMap.xlsx
inRulesFileName = /opt/ibm/ftm/dsu/SampleCommonConfiguration.xlsx
  3. You can omit all properties that start with db, such as dbUrl and dbConnectId, when you are running the DSU utility inside the Db2 container of the artifacts pod, except for dbDriverName, which is the name of the used Db2 driver.
  4. After you finish updating the properties files, run the following command to access the Db2 container of the artifacts pod.
    oc rsh -c db2 <ftm-instance>-artifacts
    where <ftm-instance>-artifacts is the name of the artifacts pod.
  5. Run the DSU utility by running the following commands.
    cd /share/build/dsu/cmd64
    ./dsu_client.sh <parameters>
    where <parameters> are the DSU utility parameters. For example, run the following command to import the CommonImport.properties.
    ./dsu_client.sh import "/opt/ibm/ftm/dsu/CommonImport.properties"