Tuning DB2 application database

To avoid performance issues in medium and large environments, configure the location of the transaction log and adjust the log size. If you are using DB2 as database, you might want also to change the swappiness parameter in Linux or configure the DB2_COMPATIBILITY_VECTOR.

Make sure that the statement concentrator is set to OFF on the DB2 instance where the is installed. For more information, see: stmt_conc - Statement concentrator configuration parameter.