HP 3000 Manuals

ALLBASE/SQL Performance and Monitoring Guidelines

SET 

Displays the current settings of the SQLMON variables

Scope 

SQLMON Only

SQLMON Syntax 

SET

Description 

   *   Each setting corresponds to a SET command.  For example, the CYCLE
       setting is specified by the SET CYCLE command.

Example 

To view the current settings, issue the SET command, as in

     SQLMONITOR  OVERVIEW => SET 

SQLMON responds with a list of the current settings, like this one:

     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]              OFF
     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

MPE/iX 5.0 Documentation