Candle-lite DB2 manual Values for SQL Description Process Level, Manual, Auto, Save, Explain

Specifying Terminal Options

Field		Description
Idle Status Word	Word you want to appear when OMEGAMON II is not monitoring an object
	(turquoise). For example: Idle.
Display Threads	To display plan names on thread summary displays, enter PLAN in this
by:	field. To display package names on thread summary displays, enter PACK.
SQL Process	Options available for copying, pasting, and saving SQL text. You can copy
Level	or save text by pressing the SQL Process PF Key.
Values for the	You can process SQL from the following screens:
SQL Process	■	SQL Call being Executed (Thread Detail). See “EXPLAINing SQL
Level are
		Code” on page 61.
described in the
	■	SQL Text (ATF). You can access the SQL Text screen through the
following table.
		application trace facility. Select the SQL TEXT pushbutton from the
		Application Trace SQL Detail screen.
	■	Thread History Dynamic SQL Detail
SQL Process PF	If you have set up !DB/EXPLAIN for direct access, pressing this PF key will
Key	directly invoke !DB/EXPLAIN. Otherwise, it will invoke the SQL copy and
	paste facility to perform the EXPLAIN.
CUA/TSO Toggle	Use to toggle between CUA and TSO sessions.
Key

The following table provides a list of fields and valid values for completing the SQL Process Level field on the Terminal Options panel.

Values for SQL	Description
Process Level
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.

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