Filter
Top Products
Using the Copy-and-Paste Facility in OMEGAMON II
104 OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
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.