HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET SORTLOAD 

Defines how items are sorted on the Load Program and Load Session screens

Scope 

SQLMON Only

SQLMON Syntax 

SET SORTL[OAD] [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    BEGIN WORK
                        2    COMMIT WORK
                        3    ROLLBK WORK (default)
                        4    DEADLOCKS

                        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
                        Load Program screen and by CID on the Load
                        Session screen.

Description 

   *   This command affects only the Load Program and Load Session
       screens.

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

   *   For more information on the Load Program and Load Session screens,
       see the chapter "SQLMON Screen Reference."

Examples 

To sort the items on the Load Program and Load Session screens according
to the value in the COMMIT WORK column, you can enter

     SQLMONITOR  LOAD => SET SORTLOAD 2 

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

     SQLMONITOR  LOAD => SET SORTLOAD 

     <0=OFF,1=BEGIN WORK,2=COMMIT WORK,3=ROLLBK WORK,4=DEADLOCKS>: 2 

MPE/iX 5.0 Documentation