Payment Feature Services database installation overview

Payment Feature Services uses the following databases:
  • FTM database (required)
  • Reporting and analytics database (optional)
Before you create or configure these databases for Payment Feature Services, review the installation overview steps for the FTM features that are being installed. Ensure that the steps that precede the database creation step are completed before you use this database installation information. For more information about the installation overview steps, see the following topics for the features that are being installed:
  • For Corporate Payment Services, refer to Corporate Payment Services Installation Overview.
  • For Digital Payments, refer to Digital Payments Installation Overview.

The following sections describe the databases and provide the location of the installation instructions.

FTM database

The FTM database is needed by all of the components of Payment Feature Services. The component-specific database objects, such as tables and views, for the Payment Feature Services components are added to this database. The default database name is FTMDB.

The FTM database must be installed before the Payment Feature Services database objects are installed. If the database is not already installed, install it. For more information about installing the database, see Creating the FTM database.

The instructions for installing the Payment Feature Services database objects are in the following files. Use the installation instructions file for the operating system where the database is installed.
  • For the Windows operating system, use install_directory\shared\v3213\pfs\Database\db2\win\doc\DBInstallInstructionsDB2_LUW.txt.
  • For AIX®, Linux®, or UNIX, use install_directory/shared/v3213/pfs/Database/db2/unix/doc/DBInstallInstructionsDB2_LUW.txt.
  • For UNIX System Services on z/OS®, use install_directory/shared/v3213/pfs/Database/db2/zos/doc/DBInstallInstructionsDB2_ZOS.txt.
The instructions for migrating your existing database are in the following files. Use the installation instructions file for the operating system where the database is installed.
  • For the Windows operating system, use install_directory\shared\v3213\pfs\Database\db2\win\doc\DBMigrationInstructionsDB2_LUW.txt.
  • For AIX, Linux, or UNIX, use install_directory/shared/v3213/pfs/Database/db2/unix/doc/DBMigrationInstructionsDB2_LUW.txt.
  • For UNIX System Services on z/OS, use install_directory/shared/v3213/pfs/Database/db2/zos/doc/DBMigrationInstructionsDB2_ZOS.txt.

Reporting and analytics database

The reporting and analytics database is an optional database that is a replica of the FTM database and can be used for the reports and dashboards. All of the tables that are used in the FTM public views of the FTM database are replicated.

Change data capture (CDC) Replication is used to replicate the tables from the FTM database. A CDC Replication subscription is used to support the Db2® LUW unidirectional CDC replication of the tables from the FTM database. The prerequisites for CDC replication are shown in the following list.
  • Install the FTM database and Payment Feature Services database objects before the reporting and analytics database is installed. If these prerequisites are not done, see FTM database.
  • Install IBM® InfoSphere® Data Replication - CDC Replication for Db2 LUW.
  • Create a clone of the FTM database to serve as the reporting and analytics database. It must be created before you install and configure the CDC Replication subscription.
  • Configure the Db2 for LUW replication instances for the FTM database and the reporting and analytics database.
Installing and configuring CDC Replication requires an experienced database administrator (DBA) who knows about CDC Replication. To guide the database administrator, sample installation and configuration script files that use the CHCCLP command-line interface for CDC Replication are provided. These CDCRep*.chcclp script files contain the commands that are used to do the following actions.
  • Create the FTM_SUBSCRIPTION.
  • Map the tables for replication.
  • Exclude the replication of LOB data type columns to the reporting and analytics database.
  • Exclude the replication of delete and truncate operations to the reporting and analytics database.
  • Create the refresh order of all the mapped tables.
The script files are in the following directories. Use the script files for the operating system where the database is installed.
  • For the Windows operating system, the directory is install_directory\shared\v3213\pfs\Database\db2\win\build.
  • For AIX, Linux, or UNIX, the directory is install_directory/shared/v3213/pfs/Database/db2/unix/build.
The following files contain the installation instructions for the reporting and analytics database. Use the file for the operating system where the database is installed.
  • For the Windows operating system, see install_directory\shared\v3213\pfs\Database\db2\win\doc\CDC_InstallInstructionsDB2_LUW.txt.
  • For AIX, Linux, or UNIX, see install_directory/shared/v3213/pfs/Database/db2/unix/doc/CDC_InstallInstructionsDB2_LUW.txt.