SET SORTIODATA [ ALLBASE/SQL Performance and Monitoring Guidelines ] MPE/iX 5.0 Documentation
ALLBASE/SQL Performance and Monitoring Guidelines
SET SORTIODATA
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 CID on the IO
Data Program screen and by CID 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
MPE/iX 5.0 Documentation