Moving Interactively between !DB/EXPLAIN and OMEGAMON II
Moving Interactively between !DB/EXPLAIN and OMEGAMON II
This unit tells you how to move interactively between OMEGAMON II for DB2 and !DB/EXPLAIN using the
What functions can you use?
When using OMEGAMON II and !DB/EXPLAIN together, you can use the following OMEGAMON II for DB2 functions:
■ATF or thread detail displays to isolate poorly performing SQL statements
■
The cut SQL text is pasted in a correctly formatted form so that it can be EXPLAINed without further editing.
■ATF to view actual access paths chosen by the DB2 optimizer and compare these with the access path information predicted by !DB/EXPLAIN
■CUA/TSO toggle function key to access the full range of !DB/EXPLAIN functions
■Historical reports to review accounting performance information about application plans and packages that are most frequently used, consume the greatest amount of resources, or have the biggest negative impact on performance
Modes of operation
When using !DB/EXPLAIN and OMEGAMON II for DB2 together, you can operate in the following modes:
1.You can move back and forth between OMEGAMON II and !DB/EXPLAIN in real time.
–Access OMEGAMON II by means of its CUA interface.
–Use the
2.You can access the full range of !DB/EXPLAIN functions from within OMEGAMON II for DB2.
–Use the CUA/TSO toggle to jump to a TSO session in which you have started or can start !DB/EXPLAIN.
–Use !DB/EXPLAIN as you would normally.
3.You can access OMEGAMON II Historical Reporter from !DB/EXPLAIN to compare actual access path information with the predicted access path information.
–The direction of the access is only
–You access OMEGAMON II Historical Reporter from the !DB/EXPLAIN Plans panel using the A or P Select.
