Tuning your database

You must tune your database by increasing the heap size setting if the database server that is being used is IBM® DB2®,

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.