HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET TOP 

Determines the number of items displayed on a screen

Scope 

SQLMON Only

SQLMON Syntax 

SET T[OP] [NumItems]
          [OFF     ]
Parameters 

NumItems                The number of items to display.  An integer
                        value.

OFF                     All items.  The default value.

Description 

This command affects the following screens:

   *   IO Data Program
   *   IO Data Session
   *   IO Log Program
   *   IO Log Session
   *   Load Program
   *   Load Session
   *   SampleIO
   *   SampleIO Indexes
   *   SampleIO TabIndex
   *   SampleIO Tables

Examples 

To display the top ten items (sorted according to a defined value), you
can enter

     SQLMONITOR  IO => SET TOP 10 

The items on the screens are sorted according to the value of a sort
command, as listed below:

   *   For the IO Data Program and IO Data Session screens, SET
       SORTIODATA
   *   For the IO Log Program and IO Log Session screens, SET SORTIOLOG
   *   For the Load Program and Load Session screens, SET SORTLOAD
   *   For the screens in the SampleIO subsystem, SET SORTSAMPLEIO
   *   For the Lock Memory screen, SET SORTLOCK

For more information on the commands listed above, see their command
pages in this chapter.

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

     SQLMONITOR  IO => SET TOP 

     NUMBER OF ITEMS TO DISPLAY <OFF=ALL>: 5 

MPE/iX 5.0 Documentation