
| 4 | Using OMEGAMON II for DB2 |
| with !DB/EXPLAIN | |
|
| |
|
|
|
|
|
|
|
|
|
Introduction
By integrating the two Candle products, OMEGAMON II for DB2 and !DB/EXPLAIN, you create the most complete view possible for understanding and optimizing SQL and DB2 applications.
The combination of the OMEGAMON II for DB2 and !DB/EXPLAIN interfaces permits you to
■capture and analyze
■analyze executing SQL
■access OMEGAMON II application trace and historical reporting information to validate access path analysis
This chapter tells how to make optimum use of the functionality these products offer when used together.
Chapter Contents
Background about !DB/EXPLAIN for DB2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Using OMEGAMON II and !DB/EXPLAIN Complementary Functions . . . . . . . . . . . . 91 Using the OMEGAMON II for DB2 Callable Interface . . . . . . . . . . . . . . . . . . . . . . . . . 93 Moving Interactively between !DB/EXPLAIN and OMEGAMON II . . . . . . . . . . . . . . 102 Using the
Using OMEGAMON II for DB2 with !DB/EXPLAIN | 89 |