 |
» |
|
|
|
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
|
|
