HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

Setting SQLMON Variables 

You can modify SQLMON environment variables using the SET commands.  For
example, the following command sorts rows on a screen according to the
value in the screen's second column:

     SQLMONITOR  IO => SET SORTIODATA 2 

If you omit the last parameter (the number after SORTIODATA), SQLMON
issues a prompt:

     SQLMONITOR  IO => SET SORTIODATA 

     <0=OFF,1=BUFF ACCESS,2=DATA DISK RD,3=DATA DISK WR,4=MISS RATE>: 2 

You can execute a SET command only from a subsystem prompt.  If you issue
a SET command at the help prompt, SQLMON displays help text for the
command but does not execute the command.

To view the current variable settings, issue SET with no parameters:

     SQLMONITOR  OVERVIEW => SET 

     C[YCLE]                   OFF
     DBEF[ILESET]              OFF
     DBEN[VIRONMENT]           PartsDBE
     DBEC[ONNECT]              ON
     DBEI[NITPROG]             ON
     E[CHO]                    OFF
     LOCKF[ILTER]              SU/TPR/GWC/SXRsxr6v/1
     LOCKO[BJECT]              ALL
     LOCKT[ABFILTER]           OFF
     M[ENU]                    ON
     OUTP[UT]                  OFF
     R[EFRESH]                 10
     SA[MPLING]                ON
     DI[SPLAYSAMPLES]          OFF
     SORTIOD[ATA]              3
     SORTIOL[OG]               OFF
     SORTLOA[D]                3
     SORTLOC[K]                5
     SORTS[AMPLEIO]            3
     T[OP]                     OFF
     U[SERTIMEOUT]             5

Each variable displayed in the previous example has a corresponding SET
command.  For more information on the SET commands, see the chapter
"SQLMON Command Reference."

MPE/iX 5.0 Documentation