Candle-lite DB2 manual Prerequisites for real time access

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.

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).

4When 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.

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.

Using OMEGAMON II for DB2 with !DB/EXPLAIN 103