Lotus Domino Administrator 8 Help - Using the autoconfigure command to automatically set database configuration parameters

DOMINO AND DB2

Using the autoconfigure command to automatically set database configuration parameters
The autoconfigure command recommends optimal database settings based on the available resources, internal statistics gathered by IBM® DB2 Universal Database™ Enterprise Server Edition, and input parameters which provide information about the IBM® Lotus® Domino™ server requirements. Running autoconfigure can improve system performance.

Run autoconfigure with the parameters shown in the table.

Keyword Valid values Default
value Recommended
Setting Explanation

mem_percent 1-100 80.00 60.00 Percentage of memory to dedicate. If other applications (other than the operating system) are running on this server, set this to less than 100.

workload_type simple, mixed, complex mixed simple Simple workloads tend to be I/O intensive and mostly transactions, whereas complex workloads tend to be CPU intensive and mostly queries.

num_stmts 1-1 000 000 10.00 40000.00 Number of statements per unit of work.

tpm 1-200 000 60.00 150000.00 Transactions per minute.

admin_priority performance, recovery, both both performance Optimize for better performance (more transactions per minute) or better recovery time.

is_populated yes, no yes yes Is the database populated with data?

num_local_apps 0-5 000 0.00 500.00 Number of connected local applications.

num_remote_apps 0-5 000 10.00 500.00 Number of connected remote applications.

isolation RR, RS, CS, UR RR CS Isolation level of applications connecting to this database.
RR -- Repeatable Read
RS -- Read Stability
CS -- Cursor Stability
UR -- Uncommitted Read

bp_resizeable yes, no yes yes Are buffer pools resizeable?

Run autoconfigure after the Domino databases have been created and data has been added (is_populated yes).

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:

Scope Explanation

NONE None of the values are applied

DB ONLY Only database configuration and buffer pool values are applied

DB AND DBM All parameters and their values are applied

Note The first time you run the autoconfigure command, include the Apply parameter as well as the parameters shown in the table, and set the parameter Apply to None. This allows you to see what type of recommendation autoconfigure produces. An example is shown here:

db2 connect to your_database

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

After that initial test of the autoconfigure command with Apply set to None, rerun the command with Apply set to db and dbm. An example is shown here:

db2 connect to your_database

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 db and dbm

If you choose to have autoconfigure apply the recommended changes to your database and database server, explicitly reset the following parameters. Autoconfigure's choices for these parameters are inadequate for Domino's requirements. From the DB2 CLP, use the following commands to update the configuration parameters to the indicated values.

db2 update db cfg for

YourDB2database

using LOGFILSIZ 8192

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

For more information about using the autoconfigure command, see the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/db2idxA.htm.

See also

Improving Domino and DB2 Performance

Glossary

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Glossary

Keyword	Valid values	Default value	Recommended Setting	Explanation
mem_percent	1-100	80.00	60.00	Percentage of memory to dedicate. If other applications (other than the operating system) are running on this server, set this to less than 100.
workload_type	simple, mixed, complex	mixed	simple	Simple workloads tend to be I/O intensive and mostly transactions, whereas complex workloads tend to be CPU intensive and mostly queries.
num_stmts	1-1 000 000	10.00	40000.00	Number of statements per unit of work.
tpm	1-200 000	60.00	150000.00	Transactions per minute.
admin_priority	performance, recovery, both	both	performance	Optimize for better performance (more transactions per minute) or better recovery time.
is_populated	yes, no	yes	yes	Is the database populated with data?
num_local_apps	0-5 000	0.00	500.00	Number of connected local applications.
num_remote_apps	0-5 000	10.00	500.00	Number of connected remote applications.
isolation	RR, RS, CS, UR	RR	CS	Isolation level of applications connecting to this database. RR -- Repeatable Read RS -- Read Stability CS -- Cursor Stability UR -- Uncommitted Read
bp_resizeable	yes, no	yes	yes	Are buffer pools resizeable?

Scope	Explanation
NONE	None of the values are applied
DB ONLY	Only database configuration and buffer pool values are applied
DB AND DBM	All parameters and their values are applied