Database Guidelines

TIBCO MFT Command Center provides a utility that can create and populate the required database tables. However, before starting the installation, you must create an TIBCO MFT Command Center database in whichever database application you use. We suggest creating DB tables using a UTF-8 character set and a case-insensitive collation. For Oracle, you may need to create a logon trigger to make searches case insensitive. When running under PostgreSQL, the CITEXT extension must be installed. MFT uses the POSTGRES CITEXT data type to provide case insensitive searches. In addition, for case insensitive searches to work, you should use the PostgreSQL JDBC driver at level 42-2.12 or higher.

A PostgreSQL superuser must run the following command to add the extension to the database that MFT uses:

CREATE EXTENSION IF NOT EXISTS citext;

Note: For more information about the supported databases, see Installation Requirements.

Have your database administrator create a database as well as a user name and password on the server that will host the TIBCO MFT Command Center database tables. It is good practice to name the database and user name as cfcc, but this is not required. This user must have the ability to read, write, and create tables in the TIBCO MFT Command Center database. The exact steps to create a database vary significantly depending on the database application you use. See the documentation provided by your database vendor for information of how to create a database.

Pay attention to the following points when creating a database:

  • Database password must not contain an equal sign (=).
  • If you use an MSSQL server database, you can configure the MSSQL server properties under the Security tab to perform authentication via SQL Server or Windows. The default option is Windows.
  • If you use an IBM DB2 database, see Creating an IBM DB2 Database for information of how to create an IBM DB2 database.
  • If you use an Oracle 10i or later, using Cost Based Optimization (CBO), it is good practice to tune the optimization for first_rows of the TIBCO MFT Command Center database. To enable this, you have to issue the following command from SQL*Plus as SYSDBA after creating the database:

    alter system set optimizer_mode=first_rows_100;

Note: The DB2 user account used for the TIBCO MFT Command Center installation must not have the DBA role assigned; otherwise, the installation will fail. The DB2 user needs only the following right granted:

GRANT CONNECT, RESOURCE TO <schema>

Warning: TIBCO strongly suggests not to create database triggers on tables in the MFT Database. Creating database triggers can cause unintended consequences and can impede the support process. If you need to create a trigger, you must notify TIBCO Support.