Database installation and configuration

Set up a Db2® database to use with your Red Hat® OpenShift® cluster.

The database can be deployed differently based on the environment that you want to use it in.
Development, test, or a proof of concept environment
In these environments, a Db2 Universal Container (Db2U) that is deployed as a container in the Red Hat OpenShift cluster is usually used. The database is created and data for your FTM offering is loaded when the artifacts container instance for the offering is created.
You can also set up your own Db2 database that is external to the cluster to use in these environments if you want to.
Production environment
You can use either Db2 Universal Container (Db2U) that is deployed as a container in the Red Hat OpenShift cluster or Db2 that is external to the Red Hat OpenShift cluster.
Important: This topic describes how to install and configure a Db2 database that is external to the cluster. For more information about installing, configuring, and deploying a database that is internal to the cluster, see Install, configure, and deploy Db2 on Red Hat OpenShift.

For an external database, the Db2 database needs to be installed and then configured with the required schemas, tables, partitions, and offering configuration data. The following sections provide more information about creating and then configuring an external FTM database to use with your Red Hat OpenShift cluster.

Get the database files from the artifacts

The files that you need to use to create an external database depends on the FTM offering that you want to deploy.
  • The FTM base database files must be downloaded.
  • If you are using an FTM offering that depends on Common Services, download the database files for Common Services.
  • Download the database files that are specific for your FTM offering.

When you are installing a database to use with Red Hat OpenShift, the database files are provided in the FTM artifacts pod and must be downloaded from the 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.

Create the FTM database

After you get the database files from the artifacts container, you can use them to create the database. For more information about how to create the database, see Creating the FTM database.

Configure the database for Check

If you are deploying Check, its configuration must be added to the FTM database that you created. You need to use the Check database configuration files from the artifacts container. For more information about configuring the database for Check, see Install, configure, or migrate the database for the offerings that are based on Common Services.

If you are using Duplicate Detect, you also need the Duplicate Detect database. For more information about installing and configuring the Duplicate Detect database, see Install, configure, or migrate the database for the offerings that are based on Common Services.

After the database configuration is done, you need to run the data setup utility to put the Check data into the database. For more information, see Run the data setup utility for the database for Red Hat OpenShift.