Tuning your IBM Db2database

You must tune your database by increasing the heap size setting for IBM® DB2® database server.

Before you begin

Before you can tune your Db2 database, you must log in as the Db2 administrator.

Procedure

  1. Run the following commands to increase the heap size setting. 
    db2 update database configuration for database <dbname> using applheapsz 8192
db2 update database configuration for database
		<dbname> using app_ctl_heap_sz 8192
db2 update database configuration for database <dbname> using LOGFILSIZ 4000
    Where dbname is the actual name of the Db2 database instance. You can find the current values of these parameters with the following commands: 
    db2 get dbm cfg 
db2 get db cfg for <dbname>
  2. Run the following commands to maintain log conditions. 
    update db config for <dbname> using logprimary 10;
update db config for <dbname> using logsecond 20;
    Note: The previous numbers in Db2 commands are indicative only. You must get the correct parameter values for your environment from your DBA.