<aside> 💡 To download a PDF copy of this TRIRIGAFEEDIA Best Practices Chapter 5.3: IBM DB2 Database, click the attachment below.

</aside>

TRIRIGAFEEDIA_3.x.x_Best_Practices_05.3_IBM_DB2_Database_20210422.pdf

Contents

5.3 IBM DB2 Database

Notes: Co-Location

5.3.1 IBM DB2 Database Server Tuning

Starting with IBM TRIRIGA Application Platform 3.5.1, the use of a DB2 back-end database is supported using DB2 10.5. The DB2 configuration is done automatically if you use the TRIRIGA provided scripts to configure your instance and database. For more information, see the Installation and Implementation Guide (3.7.0). Specifically, the following settings are recommended.

Use the following DB2 registry settings:

db2set DB2_COMPATIBILITY_VECTOR=ORA
db2set DB2_DEFERRED_PREPARE_SEMANTICS=YES
db2set DB2_ATS_ENABLE=YES
db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON

Use the following DB2 database manager settings:

db2 update dbm cfg using RQRIOBLK 65535

The database must be created with PAGESIZE=32K.

The following DB2 database configuration settings are required:

db2 update db cfg for <dbname> using STMT_CONC OFF
db2 update db cfg for <dbname> using LOCKTIMEOUT 30