This screen provides information about process effectiveness and
performance.
The following information is examined:
o Process n ENQLM <x.y> ratio below <x.y>% threshold
This message indicates that the process ENQCNT to ENQLM ratio
is below the corresponding threshold.
o Process n BIOLM <x.y> ratio below <x.y>R% threshold
This message indicates that the process BIOCNT to BIOLM ratio
is below the corresponding threshold.
o Process n DIOLM <x.y> ratio below <x.y>% threshold
This message indicates that the process DIOCNT to DIOLM ratio
is below the corresponding threshold.
o Process n PGFLQUOTA <x.y> ratio below <x.y>% threshold
This message indicates that the process PAGFILCNT to PGFLQUOTA
ratio is below the corresponding threshold.
The Process Analysis screen has a configuration submenu that
allows you to set thresholds for the following:
o BIOLM
The default BIOLM threshold is 25%. You can override the
default value with the RDM$BIND_STATS_PROC_BIOLM_RATIO logical
name.
o DIOLM
The default DIOLM threshold is 25%. You can override the
default value with the RDM$BIND_STATS_PROC_DIOLM_RATIO logical
name.
o ENQLM
The default ENQLM threshold is 25%. You can override the
default value with the RDM$BIND_STATS_PROC_ENQLM_RATIO logical
name.
o PGFLQUOTA
The default PGFLQUOTA threshold is 25%. You can override
the default value with the RDM$BIND_STATS_PROC_PGFLLM_RATIO
logical name.
o ASTLM
The default ASTLM threshold is 25%. You can override the
default value with the RDM$BIND_STATS_PROC_ASTLM_RATIO logical
name.
Note that the Online Analysis facility uses the actual database
parameters and attributes specified using interactive SQL. The
Online Analysis facility does not use the Dashboard facility
because the Database Dashboard attributes are temporary settings.
Therefore, online changes made using the Dashboard facility are
not reflected in the analysis output. Yet, using the Dashboard
facility is the recommended method for testing potential database
attribute settings. You must use interactive SQL in order to make
the attribute settings persistent.
Also note that the Online Analysis facility is invoked at the
designated screen refresh interval. As the Online Analysis
facility is fairly CPU intensive, and the analysis results seldom
vary greatly over a miniscule period of time, it is recommended
that the screen refresh interval be set to 3 seconds or more.
The Process Analysis screen is not recorded in the binary output
file produced using the Output qualifier. Consequently, this
screen is not available when you replay a binary file using the
Input qualifier.