 |
» |
|
|
|
Defines how items are sorted on the Load Program and
Load Session screens Scope |  |
SQLMON Only
SQLMON Syntax |  |
SET SORTL [OAD] [ SortColumn OFF ] Parameters |  |
- SortColumn
The column by which items are sorted.
SortColumn is an integer from 0 to 4 that represents
a column on the screen, as follows:
- 0
same as OFF
- 1
BEGIN WORK - 2
COMMIT WORK - 3
ROLLBK WORK (default) - 4
DEADLOCKS
The items are sorted in descending order
according to the values in the column.
- OFF
Sorts the items by program name and CID on the Load Program screen and by
CID on the Load Session screen.
Description |  |
This command affects only the Load Program and Load Session screens.
On each of these screens, an asterisk appears
beside the sort column number.
For more information on the Load Program and Load Session
screens, see the chapter "SQLMON Screen Reference."
Examples |  |
To sort the items on the Load Program and
Load Session screens according to
the value in the COMMIT WORK column, you can enter
SQLMONITOR LOAD => SET SORTLOAD 2
|
If you omit the last parameter,
SQLMON prompts for it, as in:
SQLMONITOR LOAD => SET SORTLOAD
<0=OFF,1=BEGIN WORK,2=COMMIT WORK,3=ROLLBK WORK,4=DEADLOCKS>: 2
|
|