This table is a simple, low overhead way of watching Multi-User performance. It contains one row. Approximately every two minutes, Multi-User saves selected information about activity which has been done. If an SQL query is done against the MUF_RATES table, the saved information is reviewed and the fields that follow are calculated as required and provided for access. The data provided is the same during the approximate two-minute interval. The time is based upon operating system facilities and timings and can therefore vary, but the two-minute value cannot be changed by the user.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
CPU_USED
|
INTEGER |
No |
The number of seconds of CPU time used by the MUF address space during the last completed time interval. |
|
DATA_SEQUENCE
|
INTEGER |
No |
The number of data buffer references per second averaged over the last completed time interval. Note that data buffers include both normal and large size buffers. |
|
DB_REQUESTS
|
INTEGER |
No |
The number of CA Datacom/DB requests per second averaged over the last completed time interval. Note that this request count is the same as reported in the Statistics and Diagnostics Area (PXX) report summary statistics as DB REQUESTS. It is also reported as DB_REQUESTS in the MUF_SYSTEMS_STATS field. |
|
DXX_SEQUENCE
|
INTEGER |
No |
The number of low-level index (DXX) buffer references per second averaged over the last completed time interval. |
|
ELAPSED_SECONDS
|
INTEGER |
No |
The number of elapsed seconds which occurred in the last completed time interval. Expect the times to vary based upon operating system features and processor availability. |
|
IXX_SEQUENCE
|
INTEGER |
No |
The number of high-level index (IXX) buffer references per second averaged over the last completed time interval. |
|
MUF_NAME
|
CHAR(8) |
No |
Name of the MUF specified in the MUF Multi-User startup option or the name of the MUF job name. |
|
PHYSICAL_READS
|
INTEGER |
No |
The number of physical read I/O events per second averaged over the last completed time interval. This count includes the Directory (CXX), Log Area (LXX), all Index Areas (IXX...), and data areas (xxx...). |
|
PHYSICAL_WRITES
|
INTEGER |
No |
The number of physical write I/O events per second averaged over the last completed time interval. This count includes the Directory (CXX), Log Area (LXX), Dual Log Area (NXX), all Index Areas (IXX...), and data areas (xxx...). |
|
Copyright © 2014 CA.
All rights reserved.
|
|