Filter
Top Products
Using OMEGAMON II for DB2 with !DB/EXPLAIN 103
Moving Interactively between !DB/EXPLAIN and OMEGAMON II
– To use the A (Application Trace Facility) Select, you must have previously
run an ATF trace for the plans of interest and placed the results into a
dataset.
– To use the P (Plan Accounting) Select, you must have previously used the
OMEGAMON II for DB2 Historical Collector to collect accounting trace
data for analysis.
Prerequisites for real time access
The Application Trace Facility (ATF) of OMEGAMON II for DB2 provides detailed
runtime performance information at the thread, unit of work, program, and SQL
statement level. To move interactively between !DB/EXPLAIN and OMEGAMON II, you
must use the OMEGAMON II for DB2 CUA interface. You must also ensure that you have
completed the prerequisite activities for access described in the !DB
®
/EXPLAIN User’s
Guide.
Procedure to use the full function of !DB/EXPLAIN
If you are using OMEGAMON II for DB2, there are two procedures to access
!DB/EXPLAIN and use its full functionality. The first way is discussed in the
!DB
®
/EXPLAIN User’s Guide. The second procedure involves use of the function key
assigned as the CUA/TSO toggle. The next table documents this procedure.
The procedure in the next table assumes that you have not previously logged onto TSO
from within the current OMEGAMON II for DB2 session. If you have already logged onto
a TSO application from within OMEGAMON II, use the CUA/TSO toggle to switch
between OMEGAMON II and !DB/EXPLAIN.
What happens when you cancel the OMEGAMON II session?
If you cancel your OMEGAMON II for DB2 session, the !DB/EXPLAIN session is also
cancelled.
Step Action
1 From the OMEGAMON II for DB2 System Status panel, press the CUA/TSO program
function key.
Result: One of the following can occur depending on the way in which your
OMEGAMON II for DB2 system has been installed:
■
You may be prompted for a TSO applid. Ensure you know the applid for logging
onto your TSO system.
■
The TSO applid can be displayed for your confirmation.
2 Start !DB/EXPLAIN using a TSO CLIST. See !DB/EXPLAIN for DB2 User’s Guide for
information.
3 As you toggle between OMEGAMON II and !DB/EXPLAIN TSO sessions, you are
presented in each instance with the last-used display (that is, the panel you were on
when you pressed the toggle).
4 When you are ready to exit !DB/EXPLAIN running under TSO for the last time, you
must fully exit the product using the END key. If you merely toggle to OMEGAMON
II, your !DB/EXPLAIN session continues to run.