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."