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. |
|
|
