HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET SORTSAMPLEIO 

Defines how items are sorted on the SampleIO subsystem screens

Scope 

SQLMON Only

SQLMON Syntax 

SET SORTS[AMPLIO] [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    SWAPIN
                        2    SWAPOUT
                        3    TOTALIO (default)

                        The items are sorted in descending order
                        according to the values in the column.

OFF                     Sorts the items by object name.

Description 

   *   This command affects the SampleIO, SampleIO Indexes, SampleIO
       TabIndex, and SampleIOTables screens.

   *   On the screens, an asterisk appears beside the sort column number.

   *   For more information on the SampleIO screens, see the descriptions
       of each screen in the chapter "SQLMON Screen Reference."

Examples 

To sort the items on the SampleIO subsystem screens according to the
value in the SWAPOUT column, enter

     SQLMONITOR  SAMPLEIO => SET SORTSAMPLEIO 2 

If you omit the last parameter, SQLMON prompts for it, as in

     SQLMONITOR  SAMPLEIO => SET SORTSAMPLEIO 

     <0=OFF,1=SWAPIN,2=SWAPOUT,3=TOTALIO>: 2 

MPE/iX 5.0 Documentation