HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET SORTIOLOG 

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 

MPE/iX 5.0 Documentation