 |
» |
|
|
|
Defines how sessions are sorted on the Lock Memory screen
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 5 that represents
a column on the screen, as follows:
- 0
same as OFF
- 1
TABLE - 2
PAGE - 3
ROW - 4
TOTAL - 5
MAXTOTAL (default)
The items are sorted in descending order according
to the values in the column.
- OFF
Sorts the items by CID.
Description |  |
This command affects only the Lock Memory screen.
On the screen, an asterisk appears beside the sort column number.
For more information on the Lock Memory screen, see the chapter
"SQLMON Screen Reference."
Examples |  |
To sort the sessions on the Lock Memory screen according to
the value in the ROW column, you can enter
SQLMONITOR LOCK => SET SORTLOCK 3
|
If you omit the last parameter, SQLMON prompts
for it, as in
SQLMONITOR LOCK => SET SORTLOCK
<0=OFF,1=TABLE,2=PAGE,3=ROW,4=TOTAL,5=MAXTOTAL>: 3
|
|