Candle-lite DB2 - Manual (Page 89)

Using OMEGAMON II for DB2 with !DB/EXPLAIN 89
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 ad-hoc, dynamic SQL—SQL that is not stored in a place
accessible to !DB/EXPLAIN users
■ 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 Copy-and-Paste Facility in OMEGAMON II . . . . . . . . . . . . . . . . . . . . . . . . 104
Accessing OMEGAMON II Trace Information from !DB/EXPLAIN . . . . . . . . . . . . . . 106
4