Calculates and displays initial values for the buffer pool size, database configuration and database manager configuration parameters, with the option of applying these reported values.
SYSADM
Database
>>-AUTOCONFIGURE--+---------------------------------------+-----> | .----------------------------. | | V | | '-USING----input-keyword--param-value-+-' >--APPLY--+-DB ONLY--+-------------------+----+---------------->< | '-ON CURRENT MEMBER-' | +-DB AND DBM--+-------------------+-+ | '-ON CURRENT MEMBER-' | '-NONE------------------------------'
Keyword | Valid values | Default value | Explanation |
---|---|---|---|
mem_percent | 1-100 | 25 | Percentage of instance memory that is assigned to the database. However, if the CREATE DATABASE command invokes the configuration advisor and you do not specify a value for mem_percent, the percentage is calculated based on memory usage in the instance and the system up to a maximum of 25% of the instance memory. |
workload_type | simple, mixed, complex | mixed | 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 | Number of statements per unit of work |
tpm | 1-200 000 | 60 | Transactions per minute |
admin_priority | performance, recovery, both | both | Optimize for better performance (more transactions per minute) or better recovery time |
is_populated | yes, no | yes | Is the database populated with data? |
num_local_apps | 0-5 000 | 0 | Number of connected local applications |
num_remote_apps | 0-5 000 | 10 | Number of connected remote applications |
isolation | RR, RS, CS, UR | RR | Maximum isolation level of applications connecting to this database (Repeatable Read, Read Stability, Cursor Stability, Uncommitted Read). It is only used to determine values of other configuration parameters. Nothing is set to restrict the applications to a particular isolation level and it is safe to use the default value. |
bp_resizeable | yes, no | yes | Are buffer pools resizeable? |
The buffer pool changes are always applied to the system catalogs. Thus, all members are affected. The ON CURRENT MEMBER option is ignored for buffer pool recommendations.
CALL SYSPROC.ADMIN_CMD( 'AUTOCONFIGURE APPLY NONE' )
LEVEL NAME VALUE RECOMMENDED_VALUE DATATYPE
-----...- ----------------...- -------...- ------------------ --------...-
DBM ASLHEAPSZ 15 15 BIGINT
DBM FCM_NUM_BUFFERS 512 512 BIGINT
...
DB APP_CTL_HEAP_SZ 128 144 INTEGER
DB APPGROUP_MEM_SZ 20000 14559 BIGINT
...
BP IBMDEFAULTBP 1000 164182 BIGINT
Column name | Data type | Description |
---|---|---|
LEVEL | VARCHAR(3) | Level of parameter and is one of:
|
NAME | VARCHAR(128) |
|
VALUE | VARCHAR(256) |
|
RECOMMENDED_VALUE | VARCHAR(256) |
|
DATATYPE | VARCHAR(128) | Parameter data type. |