Filter
Top Products
Using OMEGAMON II for DB2 with !DB/EXPLAIN 97
Using the OMEGAMON II for DB2 Callable Interface
Values for the SQL Process Level are described in the following table.
The following table provides a list of fields and valid values for completing the SQL
Process Level field on the Terminal Options panel.
Fields for Terminal
Options
Description
SQL Process Level Type of processing to use for SQL text when pressing the SQL Process
function key.
You can process SQL from the following panels:
■
SQL Call being Executed (Thread Detail). See “EXPLAINing SQL
Code” on page 61
.
■
SQL Text (ATF). You can access the SQL Text panel through the
Application Trace Facility. Select the SQL TEXT pushbutton from the
Application Trace SQL Detail screen.
■
Thread History Dynamic SQL Detail
SQL Process PF Key If you have set up !DB/EXPLAIN for direct access, pressing this function
key directly invokes !DB/EXPLAIN. Otherwise, it invokes the SQL copy
and paste facility to perform the EXPLAIN.
CUA/TSO Toggle key Use to toggle between CUA and TSO sessions.
Values for SQL
Process Level
Description
MANUAL After you have selected the SQL text to be EXPLAINed, you must use the
function key defined (SQL Process key) to copy the SQL. Then, switch to
TSO/ISPF (CUA/TSO toggle), and paste the SQL, again using the
function key you defined.
Note: To use MANUAL or AUTO, a TSO/ISPF edit session must be
active in the background.
AUTO After selecting SQL text, use the SQL Process key to copy and
automatically insert the text into the member currently in use in the
TSO/ISPF edit session. The placement of SQL text depends on the cursor
position within the TSO/ISPF session.
Note: To use MANUAL or AUTO, a TSO/ISPF edit session must be
active in the background.
SAVE After selecting the SQL text, use the SQL Process key to copy and
automatically save the SQL text to the partitioned dataset member
defined on the Save SQL Text Parameters panel. Text will either overwrite
the existing contents of the member or be appended to it, depending on
the type of save defined on this panel. This option does not require a
TSO/ISPF edit session.
EXPLAIN This option invokes !DB/EXPLAIN, which produces a variety of
!DB/EXPLAIN reports. Use the pushbuttons to view the various report
sections. Complete the required options for the EXPLAIN option on the
!DB/EXPLAIN panel.