DB2 database performance tuning tasks

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

• Configure 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: Install the IBM DB2 database Previous topic: IBM DB2 database configuration