Create and configure a DB2 database for TRIRIGA
To configure TRIRIGA® with DB2®, you must create a database before you start the TRIRIGA Application Platform installation program. You can either create the database manually, or, you can use scripts that are provided with TRIRIGA.
Configuring an existing DB2 server for use with TRIRIGA involves several steps. You must create a TRIRIGA user, create a database, and configure instance and database level settings before you start the IBM® TRIRIGA Application Platform installation program. You can create these database objects by using scripts that are provided with TRIRIGA. Scripts for Windows, Linux, and UNIX are provided in the IBM TRIRIGA Application Upgrade V10.x Multiplatform Multilingual package. The script files are located in the Scripts directory of the TRI_APPLICATION_UPGRADE_10.x.zip archive file.
If you create the database objects manually, refer to the scripts for configuration values. You can specify your own values when you create the users, name the database and instance, and define the port that is used by the TRIRIGA database instance. You must accurately provide the DB2 installation directory.
- The DB2 database instance and database must be set to Oracle mode.
- DB2 database parameters must be configured to optimize TRIRIGA performance.
- STMT_CONC=OFF
- PAGESIZE=32 K
- DB2_DEFERRED_PREPARE_SEMANTICS=YES
- The user ID created for TRIRIGA to access the database must have DBADM, SECADM, ACCESSCTRL and DATAACCESS privileges for the database.
- The database must be configured with the UTF-8 code set and CODEUNITS32 string unit if you need to support multibyte characters.
The DB2 port used to communicate with TRIRIGA needs to be available through any firewall software that is active on the system. You can disable firewall software on the DB2 server before you run the TRIRIGA database creation scripts. Firewall software can prevent the TRIRIGA scripts from completing successfully. You can reactivate the firewall after the database is created.