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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved