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