DB2 autoconfigure command
These are the arguments for the DB2® autoconfigure command used to optimize database performance.
These arguments are specified on the DB2 autoconfigure command displayed in Tuning the populated database.
- mem_percent 80
- Allocates 80% of the memory as a buffer pool.
- num_stmts 60
- Indicates that there are approximately 60 unique SQL statements with this workload.
- workload_type simple
- Indicates that the workload uses simple SQL statements, those most commonly used by WebSphere®.
- tpm 2000
- Indicates the maximum expected number of transactions per minute, which is estimated at 2000.
- num_remote_apps 100
- Specifies the number of connections to the database from WebSphere, which is set in this WebSphere configuration.
- rs
- Indicates an isolation level of read stability, which is required by most of the Java™ beans. Isolation level rs means that database rows that are read by one activation bean are only read when they are not being updated by another bean. However, subsequent reads can reflect intervening updates by different beans.
- bp_resizeable yes
- Tells DB2 to use its autoconfiguration capabilities to adjust the size of the buffer pool from its original size during future database operations, in a dynamic manner.
The reorgchk update statistics on table all command updates the statistics information from the catalog table to find the best plan to access table data. It is important that this information is current for the optimizer to be able to make the right decisions here. The reorgchk command runs a RUNSTATs operation on every table, which improves the query performance for each DB2 table.