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.
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. |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
![]() ![]() |
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:
|
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:
|
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. |