Table 9 4 lists all 

AUTOCONFIGURE 

command parameters. 

Table 9 4   Parameters for the autoconfigure command

Keyword Values 

Explanation 

mem_percent

1 100

Percentage of memory to 

default: 80

dedicate to DB2

workload_type 

simple, mixed, complex

Type of workload: simple for 

default: mixed 

transaction processing, 

complex for warehousing

num_stmts

 1 1 000 000 

Number of statements per unit 

default: 10

of work

tpm 1 200 

000 

Transactions per minute 

default: 60

admin_priority performance, 

recovery, 

both 

Optimize for better performance 

default: both

or better recovery time 

is_populated yes, 

no 

Is the database populated with 

default: yes

data? 

num_local_apps 0 5 

000

Number of connected local 

default: 0

applications 

num_remote_apps 0 5 

000 

Number of connected remote 

default: 10

applications 

isolation 

RR, RS, CS, UR 

Isolation levels: Repeatable 

default: RR

Read, Read Stability, Cursor 

Stability, Uncommitted Read

bp_resizeable yes, 

no 

Are buffer pools re sizeable? 

default: yes

9.5.7  Index Advisor

Well designed indexes are essential to database performance. DB2 UDB comes 

with a utility called the Index Advisor, which can recommend indexes for specific 

SQL queries.

Index Advisor can be invoked either using the 

db2advis

 command 

or using the Design Advisor wizard from the Command Center or Control Center. 

This utility accepts one or more SQL statements and their relative frequency, 

known as a workload. 

The Index Advisor is good for:

Finding the best indexes for a problem query

314 

MySQL to DB2 UDB Conversion Guide