 |
» |
|
|
|
Determines whether a SampleIO screen or a sampling scale
is displayed when samples are collected from the data
buffer pool Scope | |
SQLMON Only
SQLMON Syntax | |
SET DI [SPLAYSAMPLES] [ ON OFF ] Parameters | |
- ON
When SAMPLING is ON and you access a SampleIO screen, SQLMON displays the screen for the number of refresh cycles that you have set with SET CYCLE. - OFF
When SAMPLING is ON and you access a SampleIO screen, SQLMON displays a scale instead of the screen. Each time SQLMON completes a refresh cycle,
it displays a period beneath the scale. The default value.
Description | |
If SAMPLING is OFF and you access a Sample IO screen, SQLMON displays the screen showing activity since the last SET DBENVIRONMENT command. The following is an example scale:
SQLMONITOR SAMPLEIO => /sa
SAMPLING = ON
REFRESH = 10 (One set of samples will be taken every 10 seconds).
CYCLE = 5 (A total of 5 sets of samples will be taken, then you
will automatically return to the SQLMONITOR prompt).
--------10--------20--------30--------40--------50
12345678901234567890123456789012345678901234567890
.....
|
The scale is only printed when SAMPLING is ON, DISPLAYSAMPLES
is OFF, and you access a SampleIO subsystem screen.
The scale helps you to identify the number of samples that
have been taken.
The REFRESH variable determines the number of seconds that
SQLMON pauses for each refresh cycle.
The data buffer pool is sampled 25 times during each
refresh cycle.
The CYCLE variable determines the number of refresh cycles
that will be executed before returning to the SQLMON prompt.
If CYCLE is OFF, you must press return to break out of the
sampling loop:
SQLMONITOR SAMPLEIO => /sa
SAMPLING = ON
REFRESH = 10 (One set of samples will be taken every 10 seconds).
CYCLE = OFF No limit has been set for the number of samples to
be taken. You must press RETURN when you wish to
return to the SQLMONITOR prompt.)
--------10--------20--------30--------40--------50
12345678901234567890123456789012345678901234567890
...........RETURN
|
Examples | |
To view screens in the SampleIO subsystem, first
issue the following command:
SQLMONITOR SAMPLEIO => SET DISPLAYSAMPLES ON
|
You can then invoke the screen you wish to display.
If you omit the last parameter,
SQLMON prompts you for it, as follows:
SQLMONITOR SAMPLEIO => SET DISPLAYSAMPLES
ON/OFF: ON
|
|
