 |
» |
|
|
|
Defines how items are sorted on the IO Log Program
and IO Log Session screens
Scope |  |
SQLMON Only
SQLMON Syntax |  |
SET SORTIOL [OG] [ SortColumn OFF ] Parameters |  |
- SortColumn
The column by which items are sorted.
SortColumn is an integer from 0 to 3 that represents
a column on the screen, as follows:
- 0
same as OFF
- 1
LOG BUFF WR
- 2
LOG DISK RD
- 3
LOG DISK WR (default)
The items are sorted in descending order according
to the values in the column.
Description |  |
This command affects only the IO Log Program and IO Log Session screens.
On each of these screens, an asterisk appears
beside the sort column number.
For more information on the IO Log Program and IO Log Session
screens, see the chapter "SQLMON Screen Reference."
Examples |  |
To sort the items on the IO Log Program and
IO Log Session screens according to
the value in the LOG DISK RD column, enter
SQLMONITOR IO => SET SORTIOLOG 2
|
If you omit the last parameter, SQLMON prompts for
it, as in
SQLMONITOR IO => SET SORTIOLOG
<0=OFF,1=LOG BUFF WR,2=LOG DISK RD,3=LOG DISK WR>: 2
|
|