Candle-lite DB2 manual Using the Copy-and-Paste Facility in Omegamon

Using the Copy-and-Paste Facility in OMEGAMON II

Using the Copy-and-Paste Facility in OMEGAMON II

This unit describes how to use the copy-and-paste facility in OMEGAMON II to capture static or dynamic SQL and move it to !DB/EXPLAIN for analysis. This feature is for use with OMEGAMON II for DB2 versions below 300. If you are using OMEGAMON II for DB2 Version 300 or higher, the callable interface feature is recommended.

Prerequisites to using the copy-and-paste facility

Within OMEGAMON II for DB2, be sure you know the location of the PF keys defined for the copy-and-paste and the CUA/TSO toggle functions. These default function keys are F21 and F24 respectively. You can choose to assign these functions to other function keys if you want.

If you are using OMEGAMON II V270 at the current maintenance level, a profile variable is provided that permits you to select either manual or automated copy-and-paste. If you are using this profile variable, you may need to modify the following instructions based on the value you specified.

Capturing SQL from a running thread

You can use the copy-and-paste facility to capture running SQL from DB2 control blocks by following the steps in the table.

Step	Action
1	From OMEGAMON II for DB2 System Status panel, select the connection (for
	example, IMS, CICS, TSO) you want to view. Also select Thread Activity under Alerts.
	Result: The Thread Detail panel displays.
2	On the Thread Detail panel, select G4 (SQL Text).
	Result: The SQL Text panel displays.
3	On the SQL Text panel, press the copy-and-paste function key to isolate and save the
	SQL text you want to EXPLAIN.
	Result: OMEGAMON II displays a pop-up indicating that the SQL text has been
	saved.
4	The CUA/TSO toggle permits you to switch back and forth between your
	OMEGAMON II session and a TSO session. Press the CUA/TSO toggle function key to
	switch to a TSO session.
5	Initiate an ISPF session and access the dataset member into which you will paste the
	saved SQL text.
6	Press the function key you have assigned as copy-and-paste to paste the saved SQL to
	the ISPF member.
7	Invoke the ISPF edit macro KTEXPL to EXPLAIN the SQL text. For information on
	using KTEXPL, see the !DB/EXPLAIN for DB2 User’s Guide.
8	When you have completed your work with !DB/EXPLAIN, return to OMEGAMON II by
	pressing the CUA/TSO function key.

104 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540