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.