HP 3000 Manuals

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