File resource table
Use the information in the CIU_FILE_DETAIL table to write your own SQL applications to query the tables; these applications must use native SQL queries.
- CIU_FILE_DETAIL
- This
table stores detailed information about every CICS® file referenced in a transaction recorded
by the Collector. File information is stored in this table only if
the Files field on the CICS Resources Options panel, CIU240, is set
to D.
Table 1. The CIU_FILE_DETAIL table Field Name Type Description COLLECTION_ID CHAR(16) Collection ID. ARCHIVE_DATE TIMESTAMP Time of archiving. APPLID CHAR(8) CICS region applid. HOMESYSID CHAR(4) SYSID of local region. PLATFORM CHAR(64) Platform name APPL_NAME CHAR(64) Application name APPL_VER1 INTEGER Major version number APPL_VER2 INTEGER Minor version number APPL_VER3 INTEGER Micro version number APPL_OPER CHAR(64) The operation associated with the task FILE_NAME CHAR(8) Name of the file resource. ACCESSMETHOD CHAR(8) Access Method of the file. Values are: BDAM, REMOTE, and VSAM. BASEDSNAME CHAR(44) The base name of the file resource. BLOCKFORMAT CHAR(10) Whether records in the file are blocked or unblocked. Values are: BLOCKED, UNBLOCKED. BLOCKKEYLEN INTEGER Physical block key length for the file. BLOCKSIZE INTEGER The length in bytes for the block size of the file. CFDTPOOL CHAR(8) Name of the coupling facility data table pool. DISPOSITION CHAR(8) The disposition option for the file. Values are: OLD, SHARE. DSNAME CHAR(44) The data set name of the file resource. JOURNALNUM INTEGER The number of the journal to which CICS writes the information that is required for autojournaling. KEYLENGTH INTEGER The length of the record key for the file. KEYPOSITION INTEGER The starting position of the key field in each record relative to the beginning of the record. LOADTYPE CHAR(10) The load type for a coupling facility data table. Values are: LOAD, NOLOAD, and NOTAPPLIC. LSRPOOLID INTEGER The number of VSAM LSR pool associated with this file. MAXNUMRECS INTEGER The maximum number of records that the file can hold. OBJECT CHAR(8) Whether the file is associated with a data set or a VSAM path that links an alternate index to its base cluster. Value are as follow: - BASE
- The file is associated with a data set that is a VSAM base.
- PATH
- The file is associated with a path.
RBATYPE CHAR(12) Identifies whether the records can be read from the file. Values are: NOTREADABLE or READABLE. RECORDFORMAT CHAR(10) Identifies the format of the records on the file. Values are: FIXED, VARIABLE, or UNDEFINED. RECORDSIZE INTEGER The size of a fixed-length record or the maximum size of a variable-length record. RECOVSTATUS CHAR(14) Indicates whether the file is recoverable. Values are: NOTRECOVABLE or RECOVERABLE. RELTYPE CHAR(10) Indicates whether relative or absolute addressing is used to access the file and, if relative, the type of relative addressing. Value are as follows: - BLK
- Relative block addressing.
- DEC
- Zoned decimal format.
- HEX
- Hexadecimal relative track format.
- NOTAPPLIC
- Absolute addressing is being used or the file is a VSAM file.
REMOTENAME CHAR(8) The name by which the file is known to the CICS region named in the REMOTESYSTEM field. REMOTESYSTEM CHAR(4) The name of the CICS region in which the file is defined. REMOTETABLE CHAR(8) Indicates whether the file represents an open remote data table. Value is: REMTABLE (an open remote data table). RLSACCESS CHAR(10) Indicates whether the file is defined to be opened in RLS mode. Values are: NOTAPPLIC, NOTRLS, or RLS. STRINGS INTEGER Indicates the number of strings (concurrent operations) specified for the file. TABLE CHAR(10) Identifies the type of data set that corresponds to this file. Values are: CFTABLE, CICSTABLE, NOTTABLE, or USERTABLE. TABLENAME CHAR(8) The name specified for the coupling facility data table. TYPE CHAR(10) The type of data set that corresponds to this file. Values are: ESDS, KEYED, KSDS, NOTKEYED, RRDS, VRRDS, NOTAPPLIC. FIRST_RUN TIMESTAMP Time of first occurrence, in the local time format. LAST_RUN TIMESTAMP Time of latest observation, in the local time format.