Candle-lite DB2 User Manual
Page 44
Specifying Terminal Options
44
OMEGAMON II for DB2 User’s Guide: CUA Interface, Version 540
The following table provides a list of fields and valid values for completing the SQL
Process Level field on the Terminal Options panel.
Idle Status Word
Word you want to appear when OMEGAMON II is not monitoring an object
(turquoise). For example: Idle.
Display Threads
by:
To display plan names on thread summary displays, enter PLAN in this
field. To display package names on thread summary displays, enter PACK.
SQL Process
Level
Values for the
SQL Process
Level are
described in the
following table
.
Options available for copying, pasting, and saving SQL text. You can copy
or save text by pressing the SQL Process PF Key.
You can process SQL from the following screens:
■
SQL Call being Executed (Thread Detail). See
.
■
SQL Text (ATF). You can access the SQL Text screen 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 PF key will
directly invoke !DB/EXPLAIN. Otherwise, it will invoke 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 PF
key defined (SQL Process Key) to copy the SQL. Then switch to TSO/ISPF
(CUA/TSO toggle), and paste the SQL, again using the PF 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 the same 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.
Field
Description