HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET SORTLOCK 

Defines how sessions are sorted on the Lock Memory screen

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 5 that represents a
                        column on the screen, as follows:

                        0    same as OFF
                        1    TABLE
                        2    PAGE
                        3    ROW
                        4    TOTAL
                        5    MAXTOTAL (default)

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

OFF                     Sorts the items by CID.

Description 

   *   This command affects only the Lock Memory screen.

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

   *   For more information on the Lock Memory screen, see the chapter
       "SQLMON Screen Reference."

Examples 

To sort the sessions on the Lock Memory screen according to the value in
the ROW column, you can enter

     SQLMONITOR  LOCK => SET SORTLOCK 3 

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

     SQLMONITOR  LOCK => SET SORTLOCK 

     <0=OFF,1=TABLE,2=PAGE,3=ROW,4=TOTAL,5=MAXTOTAL>: 3 

MPE/iX 5.0 Documentation