This table is provided to allow monitoring of information relating to the running of the MUF in SMP mode. It contains one row. Two types of fields exist.
The first type of field supplies information to tune the number of SMP tasks and the count to start more. These fields currently include the POSTED_0 through POSTED_24_999. Periodically, CA Datacom/DB samples the list of posted tasks (units of work) that are ready to run. At each sample, one is added to one of the POSTED counters. The counter selected is based on the total entries in the list. The proportion of values in the POSTED counters reflects the depth of the backlog of work outstanding.
All other fields belong to the second type of field. They are informational and no tuning changes them. They provide the number of lock contentions for each of the SMP-type internal locks. All locks are held for a minimum number of instructions. Contention exists between one TCB which owns the lock and another TCB which wants the lock when one of them needs an exclusive lock. In this case, the second TCB must wait. Since no user action is possible, each is briefly described.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
ACCESS_AREA
|
INTEGER |
No |
Contains number of times wait occurred for the area level access. |
|
ACCOUNTING_SMP |
INTEGER |
No |
Accounting SMP locks. |
|
ACCOUNTING_STATUS
|
INTEGER |
No |
The status of an Accounting table is in the process of being changed. |
|
ACCOUNTING_TABLE
|
INTEGER |
No |
A specific Accounting tables buffer is being changed. |
|
ADD_DELETE_FLEX
|
INTEGER |
No |
The add or delete of a FLEXPOOL buffer. Also, the add or delete of a sequential buffer. |
|
CBS_BUFFER
|
INTEGER |
No |
Adding to or deleting from the CBS buffer. |
|
CHECK_INTERLOCK
|
INTEGER |
No |
Checking to see if a lock conflict (record, value, system) would cause an interlock. |
|
COVEREDVIRTUAL
|
INTEGER |
No |
A specific Covered or Virtual area while processing a block. |
|
CXX_BUFFER |
INTEGER |
No |
Count of times a task waited on a specific Directory (CXX) block to become available. |
|
DATA_BUFFER
|
INTEGER |
No |
A specific data buffer being updated. |
|
DATA_HASH
|
INTEGER |
No |
The hash-type lookup for a data buffer. |
|
DATA_LRU
|
INTEGER |
No |
The Least Recently Used chain of data buffers. |
|
DATA_SPACE_BUFFER
|
INTEGER |
No |
Record add looking for space in a specific buffer. |
|
DATA_SPACE_MGMT
|
INTEGER |
No |
Data space management adding a block to, or removing a block from, the space index for a specific area. |
|
DATA_WRITE_PEND
|
INTEGER |
No |
Changing the data buffer write-pending list. |
|
DSF_IN_MUF
|
INTEGER |
No |
CA Datacom Datadictionary requests in the MUF. |
|
DUMP_LIST |
INTEGER |
No |
Count of times a task waited while attempting to manage the CA Datacom/DB dump list because another task was concurrently managing the dump list. |
|
DXX_BUFFER
|
INTEGER |
No |
A specific DXX buffer is being updated. |
|
DXX_HASH
|
INTEGER |
No |
The hash type lookup for a DXX buffer. |
|
DXX_LRU
|
INTEGER |
No |
The Least Recently Used chain of DXX buffers. |
|
DXX_WRITE_PEND
|
INTEGER |
No |
Changing the DXX buffer write-pending list. |
|
EXPAND_BUFFER
|
INTEGER |
No |
This column is provided for prior version compatibility and contains 0 (zero). |
|
HISTORY_SPILL |
INTEGER |
No |
Count of times a task had to wait on the history database spill SMP lock. |
|
INDEX_QUEUE |
INTEGER |
No |
Changing the index queue. |
|
IXX_BUFFER
|
INTEGER |
No |
A specific IXX buffer being updated. |
|
IXX_HASH
|
INTEGER |
No |
The hash-type lookup for an IXX buffer. |
|
IXX_LRU
|
INTEGER |
No |
The Least Recently Used chain of IXX buffers. |
|
LOCK_LIST
|
INTEGER |
No |
Searching or changing the lock (exclusive control) list. |
|
LOG_BUFFER |
INTEGER |
No |
Changing a specific Log buffer. |
|
LOG_LRU
|
INTEGER |
No |
The Least Recently Used chain of LOGPOOL log buffers for transaction backout. |
|
LOGGING_CHAINS |
INTEGER |
No |
Log processing chains. |
|
LOGGING_FORCE |
INTEGER |
No |
Log force condition. |
|
MEMORY_MANAGER |
INTEGER |
No |
Change in memory allocation. |
|
MISCELLANEOUS |
INTEGER |
No |
Miscellaneous small structures. |
|
MUF_NAME |
CHAR(8) |
No |
Name of the MUF. |
|
OPEN_TABLE |
INTEGER |
No |
Changes in the list of open tables. |
|
OPEN_USER_EXIT
|
INTEGER |
No |
Contains number of times wait occurred to get to not reentrant user open exit. |
|
PLEX_CLOSE_STAT |
INTEGER |
No |
Waits to write-close stats. |
|
PLEX_LOCK_BUFFER |
INTEGER |
No |
Waits for index or data buffer coupling record. |
|
PLEX_LOCK_DBYU
|
INTEGER |
No |
Waits for lock/read of lock index assignment coupling record. |
|
PLEX_LOCK_LOG_C
|
INTEGER |
No |
Waits for lock/read for log control/current coupling record. |
|
PLEX_LOCK_LOG_U |
INTEGER |
No |
Waits for lock/read for log uncertainty coupling record. |
|
PLEX_LOCK_RUNUNIT |
INTEGER |
No |
Waits for lock/read for run unit grouping coupling record. |
|
PLEX_LOCK_TSN |
INTEGER |
No |
Waits for TSN assignment coupling record. |
|
PLEX_LOG_RCD |
INTEGER |
No |
Waits for the current log record from the coupler. |
|
PLEX_REBUILD |
INTEGER |
No |
MUFplex rebuild process. |
|
PLEX_TSN_READ |
INTEGER |
No |
Times a read was required to read the TSN record from the coupler. |
|
PLEX_TSN_RETRY
|
INTEGER |
No |
Times a retry occurred during the assignment of a TSN to start a new transaction. |
|
POSTED_0
|
DECIMAL (11,0) |
No |
Times the posted list entries were counted and the list was empty. |
|
POSTED_1_5
|
DECIMAL (11,0) |
No |
Times the posted list entries were counted and the list contained one through five entries. |
|
POSTED_6_10
|
INTEGER |
No |
Times the posted list entries were counted and the list contained six through ten entries. |
|
POSTED_11_23
|
INTEGER |
No |
Times the posted list entries were counted and the list contained 11 through 23 entries. |
|
POSTED_24_999
|
INTEGER |
No |
Times the posted list entries were counted and the list contained 24 or more entries. |
|
POSTED_LIST
|
INTEGER |
No |
Some changes to the list of posted (ready-to-run) units of work. |
|
PXX_CONSOLE
|
INTEGER |
No |
Writes to the PXX or writes to the console. |
|
SECURITY_CHECK
|
INTEGER |
No |
Changes to the security buffer or tables. |
|
SQL_ATTACH |
INTEGER |
No |
Changes to the SQL attach list. |
|
SQL_GLOBAL |
INTEGER |
No |
Changes to SQL global areas. |
|
SQL_MEM_MGR |
INTEGER |
No |
SQL memory manager. |
|
SQL_MISC |
INTEGER |
No |
Changes to minor SQL blocks. |
|
SQL_PLAN |
INTEGER |
No |
Changes to the SQL plan list. |
|
SQL_PROCEDURE |
INTEGER |
No |
Waits for a procedure TCB. |
|
SQL_STATUS |
INTEGER |
No |
Changes in SQL status conditions. |
|
SQL_TTM |
INTEGER |
No |
Getting/freeing SQL TTM blocks. |
|
SQL_URT |
INTEGER |
No |
Changes to the SQL User Requirement Lists. |
|
STAR |
INTEGER |
No |
General CA Datacom STAR control changes. |
|
STAR_TASK |
INTEGER |
No |
Changes in CA Datacom STAR task status. |
|
TASK_AREA |
INTEGER |
No |
Changes in a task area (RWTSA) status. |
|
TSN |
INTEGER |
No |
Changes to the active transaction list. |
|
USER_COMPRESSION |
INTEGER |
No |
Control information around a user compression exit. |
|
WAIT_COUPLER |
INTEGER |
No |
Waits for Coupling Facility actions. |
|
WAIT_LIST |
INTEGER |
No |
Changes in the list of waiting tasks. |
|
WAIT_MUF_MUFPLEX |
INTEGER |
No |
Waits for another MUF within the MUFplex. |
|
WAIT_PLEX_AREA |
INTEGER |
No |
Waits for lock/read of data area coupling record. |
|
WAIT_PLEX_BASE |
INTEGER |
No |
Waits for lock/read of database coupling record. |
|
WAIT_PLEX_TABLE |
INTEGER |
No |
Waits for lock/read of table coupling record. |
|
WAIT_XCF |
INTEGER |
No |
Waits for a message when using XCF for communication. |
|
XES_MSG_REPLY |
INTEGER |
No |
Waits for a message reply from another MUFplex MUF. |
|
Copyright © 2014 CA.
All rights reserved.
|
|