HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 9 SQLMON Command Reference

SET

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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
Feedback to webmaster