MAINTAINING THE DOMINO AND DB2 ENVIRONMENT
Run autoconfigure with the parameters shown in the table.
RR -- Repeatable Read
RS -- Read Stability
CS -- Cursor Stability
UR -- Uncommitted Read
If the computer is only running DB2, increase the parameter mem_percent. If other applications are running on the same computer with DB2, decrease mem_percent.
Note The LOG* db cfg parameters only apply if you do not configure archive-style transaction logging that is, you must set LOGRETAIN=No.
Use the available options to allow autoconfigure to define values for multiple configuration parameters and to determine the scope of the application of those parameters. The scope can be set to one of these values:
db2 autoconfigure using num_local_apps 500
num_remote_apps 500
isolation CS
mem_percent 60
workload_type simple
num_stmts 40000
tpm 150000
is_populated yes
admin_priority performance
bp_resizeable yes
Apply None
Apply db and dbm
db2 update db cfg for YourDB2database using LOGPRIMARY 20
db2 update db cfg for YourDB2database using LOGSECOND 4
db2 update db cfg for YourDB2database using PCKCACHESZ 50000
Related topics