 |
» |
|
|
|
Defines how items are sorted on the IO Data Program and IO Data Session screens Scope | |
SQLMON Only SQLMON Syntax | |
SET SORTIOD [ATA] [ 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
BUFF ACCESS - 2
DATA DISK RD - 3
DATA DISK WR (default) - 4
MISS RATE
The items are sorted in descending order according to the values in the column. - OFF
Sorts the items by program name and PID on the IO Data Program screen and by PID on the IO Data Session screen.
Description | |
This command affects only the IO Data Program and IO Data Session screens. On each of these screens, an asterisk appears beside the sort column number. For more information on the IO Data Program and IO Data Session screens, see the chapter "SQLMON Screen Reference."
Examples | |
To sort the items on the IO Data Program and IO Data Session screens according to the values in the DATA DISK RD column, enter
SQLMONITOR IO => SET SORTIODATA 2
|
If you omit the last parameter, SQLMON prompts for it, as follows:
SQLMONITOR IO => SET SORTIODATA
<0=OFF,1=BUFF ACCESS,2=DATA DISK RD,3=DATA DISK WR,4=MISS RATE>: 2
|
|
