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:

Monitoring views > File monitoring views > Managed data tables

Table 1. Views in the supplied Monitor data for managed data tables (MCMDT) view set
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

Table 2. Actions available for MCMDT views
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

Table 3. Fields in MCMDT views
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:
  • ENABLED - Available for access.
  • DISABLED - Not available for access, as a result of a disable command.
  • DISABLING - Still being accessed after a disable command.
  • UNENABLED - Not available for access, as a result of a close command.
  • UNENABLING - A request to close the file has been received, but tasks are executing that had previously accessed the file. These tasks are allowed to complete their use of the file, but new tasks are not allowed access.
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.


eyua4f7.html | Timestamp icon Last updated: Sunday, 4 June 2017