This screen provides continuously updated OpenVMS accounting
information about local processes in a VMScluster environment.
This screen is an alternative to the OpenVMS SHOW PROCESS
/CONTINUOUS utility. The screen provides equivalent information,
except that all active database processes on a specific node can
be monitored at the same time.
This screen displays operating system accounting information,
thereby enabling a database administrator to evaluate the
system resources used by database processes. The values in the
Process Accounting screen are for all process activity, not
just the activity that occurs while in the database. Therefore,
this screen is useful for monitoring the complete application
behavior.
This screen displays dynamically changing process information
only. That is, quotas and other information that are fixed for
each process are not displayed because that information can be
obtained in other ways.
The Process Accounting screen has brief and full modes that
control the amount of information displayed for each active
database process.
You select brief mode by typing B. In brief mode, one line
per process is displayed, providing the following information:
process ID, process name, CPU time, remaining lock quota count,
page fault count, number of direct I/O operations, working set
size and virtual memory size.
You select full mode by typing F. In full mode, a second line
per process is displayed that provides the following additional
information: user name, image name, process state, page file
quota count, direct I/O quota count, number of buffered I/O
operations and buffered I/O quota count.
Note that information on the Process Accounting screen cannot
be reset. Because the information is gathered in real time, it
cannot be written to the output file (the Output qualifier will
not work with this screen) and therefore cannot be displayed
during input file replay (the Input qualifier will not work with
this screen).
If the information on all the local processes does not fit on a
single Process Accounting page, use the >Next_page and <Prev_page
keys to scroll between the multiple pages of process information.
The Process Accounting screen provides the following information
in both brief and full modes:
o Process ID-The process ID for the current process, assigned
by the operating system, and the stream ID, assigned by the
database. If the process has more than one active database
session, only the first active stream ID will be displayed
because the process accounting information is the same for
all active database sessions. Stream ID values greater than 99
display as "**" to indicate an integer display overflow on the
screen; the [Z]oom function can be used to display the full
stream ID in this case.
Optionally, a single character following the stream ID field
indicates additional information about the process:
D - Database Recovery (DBR)
R - Server for a remote user
s - Database server (such as ABS, ALS, LCS, LRS, or RCS)
u - Attached for utility access
* - User process on another node in the cluster
A - Available for per-process monitoring
G - Actively being monitored
o Process name-The name of the process.
o CPU time-The total accumulated CPU time since the process was
logged in.
o ENQ quota count-The remaining number of locks the process
may request. This field should not approach zero. If it
does approach zero, the ENQLM value should be raised for the
process.
o Page fault count-The total accumulated number of page faults.
o Number of direct I/O operations-The total accumulated count of
the direct I/O operations.
o Working set size-The total accumulated number of active pages
(512-byte pages) in the working set for the process.
o Virtual memory size-The total accumulated number of pages
(512-byte pages) of virtual memory allocated by the process.
This value includes the size of the database global section.
The Process Accounting screen provides the following information
fields only in full mode:
o User name-The name of the user (used when logging in to the
system).
o Image name-The name of the image file currently being executed
by the process.
o Process state-The current process state, which will be one of
the following keywords:
Keyword Description
CEF Common event flag wait
COM Computable
COMO Computable, out of balance set
CUR Current process
COLPG Collided page wait
FPG Free page wait
HIB Hibernate wait
HIBO Hibernate wait, out of balance set
LEF Local event flag wait
LEFO Local event flag wait, out of balance set
MWAIT Mutex and miscellaneous resource wait
PFW Page fault wait
SUSP Suspended
SUSPO Suspended, out of balance set
o Page file quota count-The remaining number of pages in the
paging file the process may request. This field should not
approach zero. If it does approach zero, the PGFLQUOTA value
should be raised for the process.
o Direct I/O quota count-The remaining number of direct I/O
operations the process may request. This field should not
approach zero. If it does approach zero, the DIOLM value
should be raised for the process.
o Number of buffered I/O operations-The total accumulated count
of the buffered I/O operations.
o Buffered I/O quota count-The remaining number of buffered
I/O operations the process may request. This field should
not approach zero. If it does approach zero, the BIOLM value
should be raised for this process.