Managed data tables - CMDT

The Managed data tables (CMDT) views display information about files that have CICS or user-maintained data tables, or coupling facility data tables, associated with them. The data presented is from the perspective of the file associated with the data table.

Supplied views

To access from the main menu, click:

CICS operations views > File operations views > Managed data tables

Table 1. Views in the supplied Managed data tables (CMDT) view set
View Notes
Managed data tables

EYUSTARTCMDT.CLOSE

 Close the data table file with one of the following options:
  • Wait
    • Wait to perform the close action until the data table file is no longer in use.
  • Nowait
    • Do not perform the close action if the data table file is in use.
  • Force
    • Close the data table file immediately, even if it is in use.
When a data table file has been enabled by the Open action, Close disables the file.
Managed data tables

EYUSTARTCMDT.DETAIL1

 Detailed information about a selected data table file's table details.
Managed data tables

EYUSTARTCMDT.DETAIL2

 Detailed information about a selected data table file's data set details.
Managed data tables

EYUSTARTCMDT.DETAIL3

 Detailed information about the resource signature.
Managed data tables

EYUSTARTCMDT.DETAILED

 Detailed information about a selected data table file.
Managed data tables

EYUSTARTCMDT.DISABLE

 Disable the data table file with one of the following options:
  • Wait
    • Wait to perform the disable action until the data table file is no longer in use.
  • Nowait
    • Do not perform the disable action if the data table file is in use.
  • Force
    • Disable the data table file immediately, even if it is in use.
Managed data tables

EYUSTARTCMDT.DISCARD

 Discard a data table file from the CICS system where it is installed.
Managed data tables

EYUSTARTCMDT.ENABLE

 Enable a data table file.
Managed data tables

EYUSTARTCMDT.OPEN

 Open a data table file. When the data table file has been disabled by the Close action, Open enables the file.
Managed data tables

EYUSTARTCMDT.SET

 Set data table file attributes according to new values specified in input fields
Managed data tables

EYUSTARTCMDT.TABULAR

 Tabular information about files with data tables associated with them.

Actions

Table 2. Actions available for CMDT views
Action Description
CLOSE Close the data table file with one of the following options:
  • Wait
    • Wait to perform the close action until the data table file is no longer in use.
  • Nowait
    • Do not perform the close action if the data table file is in use.
  • Force
    • Close the data table file immediately, even if it is in use.
When a data table file has been enabled by the Open action, Close disables the file.
DISABLE Disable the data table file with one of the following options:
  • Wait
    • Wait to perform the disable action until the data table file is no longer in use.
  • Nowait
    • Do not perform the disable action if the data table file is in use.
  • Force
    • Disable the data table file immediately, even if it is in use.
DISCARD Discard a data table file from the CICS system where it is installed.
ENABLE Enable a data table file.
OPEN Open a data table file. When the data table file has been disabled by the Close action, Open enables the file.
SET Set data table file attributes according to new values specified in input fields

Fields

Table 3. Fields in CMDT views
Field Attribute name Description
Add option ADD Indicates whether new records can be added to the data table file.

Input Values: ADDABLE, NOTADDABLE

Number of WRITE requests ADDCNT The number of PUT requests issued against this data table file
Number of records added to table by READ requests ADDFRREAD The number of records placed in the data table file by the loading process or as a result of API READ requests issued while loading was in progress
Number of add requests rejected by user exit ADDREJ The number of records CICS attempted to add to the data table file that were rejected by the global user exit
Number of records added from WRITE requests ADDREQ The number of attempts to add records to the data table file as a result of API WRITE requests
Number of add requests rejected 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
BAS resource definition version BASDEFINEVER The BAS version number of this definition.
Browse option BROWSE Indicates whether records in the data table file can be browsed.

Input Values: BROWSABLE, NOTBROWSABLE

Number of READNEXT and READPREV requests BROWSECNT The number of GET NEXT and GET PREV requests issued against this data table file
Last modification agent CHANGEAGENT The change agent identifier that made the last modification.
  • CSDAPI - The resource was last changed by a CEDA transaction, by the programmable interface to DFHEDAP or by an EXEC CICS CSD command.
  • CSDBATCH - The resource was last changed by a DFHCSDUP job.
  • DREPAPI - The resource was last changed by a CICSPlex SM BAS API command.
  • DREPBATCH - The resource was last changed by a CICSPlex SM utility.
  • TABLE - The resource was last changed by a CICSPlex table definition.
  • SYSTEM - The resource was last changed by the CICS or CICSPlex SM system.
  • CREATESPI - The resource was last changed by an EXEC CICS CREATE command.
  • NOTAPPLIC - This is not applicable for this resource.
Last modification agent release CHANGEAGREL The CICS release level of the agent that made the last modification to the resource definition.
Last modification time CHANGETIME The local date and time when the definition was last changed.
Last modification user ID CHANGEUSRID The user ID that made the last modification to the resource definition.
Number of CFDT contentions CONTENTION The number of times a read from a Data Table resulted in a contention arising on the CFDT Server
Current number of records in data table file CURCOUNT The current number of records in the data table file
Data set type DATASETTYPE The type of data set associated with this data table file as one of the following:
  • B - BDAM data set
  • E - VSAM entry-sequenced data set (ESDS)
  • K - VSAM key-sequenced data set (KSDS)
  • P - VSAM path accessed by an alternate index
  • R - VSAM relative record data set (RRDS)
Source of the resource definition DEFINESOURCE The source of the definition, depending on which agent made the last change.
Creation time DEFINETIME The local date and time when the resource definition record was created on DFHCSD or EYUDREP.
Delete option DELETE Indicates whether records can be deleted from the data table file.

Input Values: DELETABLE, NOTDELETABLE

Number of DELETE requests DELETEREQ The number of attempts to delete records from the data table file as a result of DELETE requests
Number of I/O operations on data component DEXCPCNT The number of I/O operations on the data table file for data records
Disposition of associated data set DISPOSITION The disposition of the data table file.

Input Values: OLD, SHARE

Data set name DSNAME The 44-character name of the data set associated with this data table file, as defined to the access method and to the operating system.

Input Values: Any valid data set name

Enablement 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 or close 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 ID FILE The name of the data table file
Forward recovery option FWDRECSTATUS Indicates whether the data table file is forward-recoverable. Values are FWDRECOVABLE or NOTFWDRCVBLE
Number of READ requests GETCNT The number of GET requests issued against this data table file
Number of READ UPDATE requests GETUPDCNT The number of GET UPDATE requests issued against this data table file
GMT file close time GMTFILECLS The GMT store clock time at which the data table file was closed.
GMT file open time GMTFILEOPN The GMT store clock time at which the data table file was opened
Number of I/O operations on index component IEXCPCNT The number of I/O operations on the data table file for index records.
Installation agent INSTALLAGENT The install agent identifier that made the installation.
  • CSDAPI - The resource was installed by a CEDA transaction, by the programmable interface to DFHEDAP or by an EXEC CICS CSD command.
  • CREATESPI - The resource was installed by an EXEC CICS CREATE command.
  • TABLE - The resource was last installed by a CICSPlex table definition.
  • SYSTEM - The resource was last installed by the CICS system.
  • GRPLIST - The resource was installed by GRPLIST INSTALL.
Installation time INSTALLTIME The local date and time when the definition was installed.
Installation user ID INSTALLUSRID The user ID that installed the resource definition.
Journal number JOURNALNUM The identifier of the journal associated with this data table file. An ID of 1 identifies the CICS system log. A value of 0 means there is no journal associated with this data table file
Key length KEYLENGTH The length of the key
Key position KEYPOSITION The starting position of the key field in each record relative to the beginning of the record
CFDT load type LOADTYPE The Load specification for the data set associated with this Table (actioned by CFTABLE only):
  • NOLOAD - No data set load is required.
  • LOAD - The associated data set is to be loaded into the table when it is first opened
  • NOTAPPLIC - Not applicable.
Number of DELETE requests LOCDELCNT The number of DELETE requests issued against this data table file
LSR Pool number LSRPOOLID The identifier of the local shared resources (LSR) pool associated with this data table file.

Input Values: 1 - 255

Maximum number of records table can hold MAXNUMRECS This is maximum number of records that the data table file can hold in the range from 0 to 99,999,999. A value of 0 implies that the table has no logical limit to its size, although in practical terms there is an architectural system limit of 2,147,483,647. Care should be taken when specifying 'NOLIMIT', because a transaction in a runaway task state will not be prevented from filling up storage in the Coupling Facility Dataspace.

Input Values: 0 - 99,999,999

Maximum 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 wait
Open status OPENSTATUS Indicates whether the data table file is open, closed, or in transition.

Input Values: OPEN, CLOSED

CFDT pool name POOLNAME For MVS Coupling Facility Data Tables, this is the name of CFDT Pool which the table is constructed in
Read option READ Indicates whether records can be read from the data table file

Input Values: READABLE, NOTREADABLE

Number of READ retries READRETRY The number of times READs in an AOR had to be retried because the FOR changed the table during the read
Number of successful READs READS The number of attempts to retrieve records from the data table file that were successful
Total number of records not found in table RECNOTFND The number of times API READ requests were directed to the source data set because the record was not found in the data table file.
Record format RECORDFORMAT The format of the records in the data table file: Values are: FIXED, VARIABLE, or UNDEFINED
Record size RECORDSIZE For fixed-length records, the actual size of a record. For variable-length records, the maximum size of a record
Recovery type RECOVSTATUS Indicates whether the data table file is recoverable. Values are: RECOVERABLE or NOTRECOVABLE
Number of 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 (kilobytes) STGALCINU The amount of storage in use for the data table file in kilobytes
Total storage allocated (kilobytes) STGALCTOT The total amount of storage allocated to the data table file in kilobytes
Storage in use for record data (kilobytes) STGDTAINU The amount of storage in use for the data table file's record data in kilobytes
Storage allocated for record data (kilobytes) STGDTATOT The total amount of storage allocated for the data table file's record data in kilobytes
Storage in use for record entry blocks (KB) STGENTINU The amount of storage in use for the data table file's record entry blocks in kilobytes
Storage allocated for record entry blocks (KB) STGENTTOT The total amount of storage allocated for the data table file's record entry blocks in kilobytes
Storage in use for index (kilobytes) STGIDXINU The amount of storage in use for the data table file index in kilobytes
Storage allocated for index (kilobytes) STGIDXTOT The total amount of storage allocated for the data table file index in kilobytes
Number of strings STRINGS The total number of operations that can be performed on the data table file at one time.

Input Values: 1 - 255

Type of data table TABLE Indicates whether the data table associated with the file is a CICS-maintained, user-maintained, or CF-maintained table. Valid values are:
  • CICSTABLE
  • USERTABLE
  • CFTABLE
  • NOTTABLE

To change the Table Type attribute requires that the file be in a CLOSED state, with an ENABLESTATUS of either DISABLED or UNENABLED, and they do not take effect until the file is next opened

CFDT table name TABLENAME For MVS Coupling Facility Data Tables, this is the name of CFDT Table which the file is loaded into
Local time file was closed TIMECLOSE The local time at which the data table file was closed
Local time file was opened TIMEOPEN The local time at which the data table file was opened
Update option UPDATE Indicates whether records in the data table file can be updated.

Input Values: UPDATABLE, NOTUPDATABLE

Number of REWRITE requests UPDATECNT The number of PUT UPDATE requests issued against this data table file
CFDT update model UPDATEMODEL The type of update model that is associated with the file:
  • LOCKING - The coupling facility data table is updated using the locking model.
  • CONTENTION - The coupling facility data table is updated using the contention model.
  • NOTAPPLIC - The file does not refer to a coupling facility data table and UPDATEMODEL on the file resource definition does not specify a value. The Load specification for the dataset associated with this Table (actioned by CFTABLE only):
  • NOLOAD - No dataset load is required.
  • LOAD - The associated dataset is to be loaded into the table when it is first opened.
Type of VSAM data set VSAMTYPE The type of data set associated with this data table file as one of the following:
  • ESDS - VSAM entry-sequenced data set
  • KSDS - VSAM key-sequenced data set
  • RRDS - VSAM relative record data set
  • VRRDS - Variable relative record data set

A value of NOTAPPLIC is returned if the data table file is not open.

Peak concurrent requests queued - strings in use WSTRCCURCNT The peak number of concurrent requests queued - strings in use
Total requests queued because strings in use WSTRCNT The total number of requests queued because strings are in use
Parent topic: File operations views

eyua3t0.html | Timestamp icon Last updated: Thursday, 27 June 2019