HP 3000 Manuals HP 3000 Manuals
SET DISPLAYSAMPLES
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