Tuning the populated database

Edit online

After the initial setup, the database is populated using a DB2® restore operation.

Before the database is used, it is tuned with these commands:
db2 connect to <dbname>
db2 autoconfigure using mem_percent 80 workload_type simple num_stmts 60 tpm 2000 
is_populated yes num_local_apps 0 num_remote_apps 100 isolation rs bp_resizeable yes 
apply db and dbm
db2 terminate
db2 connect to <dbname>
db2 reorgchk update statistics on table all
db2 terminate

See DB2 autoconfigure command for a detailed explanation of each argument.