DB2 database performance tuning tasks

Performance issues can occur after you initially configure DB2®. Performance tuning tasks can ensure that DB2 runs correctly.

Configuring TCP KeepAlive settings
The failover design of the messaging engine relies upon the database connections that are broken when a messaging engine instance fails. In order for failover to occur in high availability environments, ensure that the system notices the broken connection in a timely manner and releases database locks. This task is done by configuring the TCP KeepAlive settings.
Change of the DB2 application heap size
Loading many users can encounter performance issues.

Parent topic: Installation and configuration of the IBM Db2 database

Previous topic: IBM DB2 database configuration