Managed data tables - MCMDT
The Monitor data for data tables (MCMDT) views display information about monitored files that have CICS - or user-maintained data tables, or coupling facility data tables, associated with them.
Supplied views
To access from the main menu, click:
| View | Notes |
|---|---|
| Monitor data for managed data tables EYUSTARTMCMDT.DETAIL1 |
Detailed table information about monitored files with associated data tables. |
| Monitor data for managed data tables EYUSTARTMCMDT.DETAIL2 |
Detailed data set information about monitored files with associated data tables. |
| Monitor data for managed data tables EYUSTARTMCMDT.DETAILED |
Detailed information about monitored files with associated data tables. |
| Monitor data for managed data tables EYUSTARTMCMDT.DISCARD |
Removes a data table file from CICSPlex SM monitoring for the current sample interval and discards its accumulated statistics. |
| Monitor data for managed data tables EYUSTARTMCMDT.RESET |
Resets the CICSPlex SM statistics counters associated with a data table file to 0. |
| Monitor data for managed data tables EYUSTARTMCMDT.TABULAR |
Tabular information about monitored files with associated data tables. |
Actions
| Action | Description |
|---|---|
| DISCARD | Removes a data table file from CICSPlex SM monitoring for the current sample interval and discards its accumulated statistics. |
| RESET | Resets the CICSPlex SM statistics counters associated with a data table file to 0. |
Fields
| Field | Attribute name | Description |
|---|---|---|
| Number of add requests | ADDCNT | The number of PUT requests issued against the data table file. |
| Add requests resulting from reads | ADDFRREAD | The number of records placed in the data table file by the loading process or as a result of READ requests issued while loading was in progress. |
| Add requests rejected by exit | ADDREJ | The number of records CICS attempted to add to the data table file that were rejected by the global user exit. |
| Total add requests | ADDREQ | The number of attempts to add records to the data table file as a result of WRITE requests. |
| Total add requests when table full | ADDTFULL | The number of records CICS attempted to add to the data table file that were rejected because the table already contained the maximum allowable number of records. |
| Number of browse requests | BROWSECNT | The number of GET NEXT and GET PREV requests issued against the data table file. |
| CFDT contention count | CONTENTION | The number of times a read from a data table resulted in a contention arising on the CFDT Server. |
| Current record count | CURCOUNT | The current number of records in the data table file. |
| VSAM data EXCP rate current sample | CURDEXCPRATE | The rate of I/O operations for data records during the last sample period. |
| VSAM index EXCP rate current sample | CURIEXCPRATE | The rate of I/O operations for index records during the last sample period. |
| MDT request rate for current sample | CURMRQRATE | The rate at which modification requests were issued against the data table file during the last sample period. |
| Successful read rate current sample | CURREADRATE | The rate at which records were retrieved from the data table file during the last sample period. |
| Request rate for current sample | CURREQRATE | The rate at which API requests (READ, READ UPDATE, READNEXT, READPREV, WRITE, REWRITE and DELETE) were issued against the data table file during the last sample period. |
| Total delete requests | DELETEREQ | The number of attempts to delete records from the data table file as a result of DELETE requests. |
| VSAM EXCP count data component | DEXCPCNT | For VSAM files, the number of I/O operations for data records. |
| Data set name | DSNAME | The 44-character name of the data set associated with the data table file, as defined to the access method and to the operating system. |
| Enabled status | ENABLESTATUS | Indicates whether the data table file is available for access by application programs. The status will be one of the
following:
|
| File identifier | FILE | The ID of the file. |
| Number of get requests | GETCNT | The number of GET requests issued against the data table file. |
| Number of get update requests | GETUPDCNT | The number of GET UPDATE requests issued against the data table file. |
| VSAM EXCP count INDX component | IEXCPCNT | For VSAM files, the number of I/O operations for index records. |
| VSAM data EXCP rate for interval | INTDEXCPRATE | The average rate of I/O operations for data records over the monitor interval. |
| Interval identifier | INTERVALID | The ID of the monitor interval. |
| VSAM index EXCP rate for interval | INTIEXCPRATE | The average rate of I/O operations for index records over the monitor interval. |
| MDT request rate for interval | INTMRQRATE | The average rate at which modification requests were issued against the data table file over the monitor interval. |
| Successful read rate for interval | INTREADRATE | The average rate at which records were retrieved from the data table file over the monitor interval. |
| Request rate for interval | INTREQRATE | The average rate at which API requests (READ, READ UPDATE, READNEXT, READPREV, WRITE, REWRITE and DELETE) were issued against the data table file over the monitor interval. |
| Number of local delete requests | LOCDELCNT | The number of DELETE requests issued against the data table file. |
| LSR Pool number | LSRPOOLID | The number of the local shared resources pool. |
| Maximum records table can hold | MAXNUMRECS | The maximum number of records that the data table file can hold. A value of 'NOLIMIT' means no maximum value has been set. |
| Highest table size | MAXTSIZE | The highest number of records in the data table file at any one time. |
| Number of active strings | NUMACTSTRING | The number of currently active VSAM strings. |
| Number of data buffers | NUMDATBUFF | The number of storage buffers allocated for data. |
| Number of index buffers | NUMINDEXBUFF | The number of storage buffers allocated for the index. |
| Number of active string waits | NUMSTRINGWT | The number of VSAM active string waits. |
| Open status | OPENSTATUS | Indicates whether the data table file is open, closed, or in transition. |
| CFDT pool name | POOLNAME | For MVS Coupling Facility Data Tables, this is the name of CFDT Pool which the table is constructed in. |
| Read retries | READRETRY | The number of times reads in an AOR had to be retried because the FOR changed the table during the read. |
| Successful reads | READS | The number of attempts to retrieve records from the data table file that were successful. |
| Total records not found in table | RECNOTFND | The number of times READ requests were directed to the source data set because the record was not found in the data table file. |
| Record size | RECORDSIZE | For fixed-length records, the actual size of a record. For variable-length records, the maximum size of a record. |
| Total rewrite requests | REWRITE | The number of attempts to update records in the data table file as a result of REWRITE requests. |
| Total storage in use | STGALCINU | The amount of storage in use for the data table file in kilobytes. |
| Total storage allocated | STGALCTOT | The total amount of storage allocated to the data table file in kilobytes. |
| Data storage in use | STGDTAINU | The amount of storage in use for the data table file's record data in kilobytes. |
| Data storage allocated | STGDTATOT | The total amount of storage allocated for the data table file's record data in kilobytes. |
| Entries storage in use | STGENTINU | The amount of storage in use for the data table file's record entry blocks in kilobytes. |
| Entries storage allocated | STGENTTOT | The total amount of storage allocated for the data table file's record entry blocks in kilobytes. |
| Index storage in use | STGIDXINU | The amount of storage in use for the data table file index in kilobytes. |
| Index storage allocated | STGIDXTOT | The total amount of storage allocated for the data table file index in kilobytes. |
| Strings | STRINGS | The number of concurrent operations that can be performed on the data table file. |
| Data table indicator | TABLE | Indicates whether the data table associated with the file is a Coupling Facility (CFTABLE), CICS-maintained (CICSTABLE), User-maintained (USERTABLE) table, or is not currently defined as a data table (NOTTABLE). |
| CFDT table name | TABLENAME | For MVS Coupling Facility Data Tables, this is the name of CFDT Table which the file is loaded into. |
| Time closed | TIMECLOSE | The local time at which the data table file was closed. |
| Time opened | TIMEOPEN | The local time at which the data table file was opened. |
| Sum of all requests | TOTLREQCNT | The total number of API requests (READ, READ UPDATE, READNEXT, READPREV, WRITE, REWRITE and DELETE) issued against the data table file. |
| Sum of all MDT requests | TOTMREQCNT | The total number of modification requests issued against the data table file. |
| Number of update requests | UPDATECNT | The number of PUT UPDATE requests issued against the data table file. |
| VSAM file type | VSAMTYPE | The VSAM file type of the data table file. |
| Wait on string maximum concurrent count | WSTRCCURCNT | The maximum number of requests that were queued at any one time because all the strings available to the data table file were in use. |
| Wait on string total count | WSTRCNT | The total number of requests that were queued because all the strings available to the data table file were in use. |