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.
Start of changeAPPL_NAMEEnd of change Start of changeCHAR(64)End of change Start of changeApplication nameEnd of change
Start of changeAPPL_VER1End of change Start of changeINTEGEREnd of change Start of changeMajor version numberEnd of change
Start of changeAPPL_VER2End of change Start of changeINTEGEREnd of change Start of changeMinor version numberEnd of change
Start of changeAPPL_VER3End of change Start of changeINTEGEREnd of change Start of changeMicro version numberEnd of change
Start of changeAPPL_OPEREnd of change Start of changeCHAR(64)End of change Start of changeThe operation associated with the taskEnd of change
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.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic//db2t1.html