DB2 Workload Performance Advisor tool is finished.

Launching the Index Advisor in a GUI environment

The

 Index Advisor

 can also be invoked as a GUI tool. From the 

Control Center

, 

expand the object tree to find the 

Database

 folder. Right click the desired 

database and select

 Design Advisor

. The wizard guides you through all the 

necessary steps, and also helps to construct a workload by looking for recently 

executed SQL queries, or looking through the recently used packages. In order 

to get accurate recommendations, it is important to have the current catalog 

statistics. With the 

Design Advisor

 there is an option to collect the required 

basic statistics, however, this increases the total calculation time. Figure 9 15 

presents a sample 

Design Advisor

 window.

Figure 9 15   The Design Advisor

The detailed usage of Design Advisor can be found in the following redbooks:

DB2 UDB Evaluation Guide for Linux and Windows,

 SG24 6934

DB2 UDB Exploitation of the Windows Environment,

 SG24 6893

Up and Running with DB2 for Linux,

 SG24 6899

316 

MySQL to DB2 UDB Conversion Guide