Program resource table

Use the information in the CIU_PROGRAM_DETAIL table to write your own SQL applications to query the tables; these applications must use native SQL queries.

CIU_PROGRAM_DETAIL

This table stores information about every CICS® program referenced in a transaction recorded by the Collector. Program information is stored in this table only if the Programs field on the CICS® Resources Options panel, CIU240, is set to D.

Table 1. The CIU_PROGRAM_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
PROGRAM_NAME	CHAR(8)	Name of the program resource.
LINKEDIT_DATE	TIMESTAMP	Reserved for future use.
LIB_NAME	CHAR(8)	Name of the library resource from which this program was loaded.
LIB_DATASET-NAME	CHAR(44	Name of the data set from which the program was loaded.
ACCESS	CHAR(8)	The type of storage into which the program is loaded. Values are: CICS®, USER, READONLY, and NONE.
APIST	CHAR(8)	Indicates the API attribute of the installed program definition. Values are: CICSAPI and OPENAPI.
CONCURRENCY	CHAR(12)	Indicates the concurrency attribute of the installed program definition. Values are: QUASIRENT and THREADSAFE.
DATA_LOCATION	CHAR(10)	Indicates whether this program can accept data address higher than 16 MB. Values are: ANY, BELOW, and NOTAPPLIC.
DYNAMIC_STATUS	CHAR(10)	Indicates if the program is the subject of a program-link request; that is, the request can be dynamically routed. Values are: DYNAMIC and NOTDYNAMIC.
EXECUTION_KEY	CHAR(10)	Indicates the storage key of the program. Values are: CICS®, USER, and NOTAPPLIC.
EXECUTION_SET	CHAR(10)	Indicates whether the program is restricted to the distributed program link subset of the CICS® API. Values are: DPLSUBSET, FULLAPI, and NOTAPPLIC.
HOLD_STATUS	CHAR(10)	Indicates how long the program is to remain loaded. Values are: CICSLIFE, TASKLIKE, and NOTAPPLIC.
INSTALL_TYPE	CHAR(10)	Indicates the method used to install the program resource definition. Values are: AUTO, CATALOG, GROUPLIST, MANUAL, RDO, and SYSAUTO.
LANGUAGE_DEDUCED	CHAR(12)	Indicates the language deduced by CICS® for the program. Values are: ASSEMBLE, C370, COBOL, COBOL2, LE370, PLI, Java, NOTDEDUCED, and NOTAPPLIC.
LANGUAGE_DEFINED	CHAR(12)	Indicates the programming language specified on the resource definition. Values are: ASSEMBLE, C370, COBOL, LE370, PLI, NOTDEFINED, and NOTAPPLIC.
LOAD_STATUS	CHAR(12)	Indicates whether the program can be loaded. Values are: LOADABLE, NOTLOADABLE, NOTLOADED, and NOTAPPLIC.
LOCATION	CHAR(8)	Indicates where the most recently loaded copy of the program resides. Values are: CDSA, ECDSA, ELPA, ERDSA, ESDSA, LPA, RDSA, SDSA, and NONE
MODULE_TYPE	CHAR(12)	Indicates the type of this program resource. Values are: MAPSET, PARTITIONSET, and PROGRAM.
PROGRAM_ATTRIBUTE	CHAR(10)	Indicates the residency status of the program. Values are: RELOAD, RESIDENT, REUSABLE, TRANSIENT, and TEST.
PROGRAM_LENGTH	INTEGER	The length of the program in bytes.
PROGRAM_TYPE	CHAR(10)	Indicates where the next new copy of the program is to be loaded from. Values are: PRIVATE, SHARED, TYPEANY, and NOTAPPLIC.
PROGRAM_USAGE	CHAR(12)	Indicates whether the program is used as a CICS® nucleus program or as a user application program. Values are: APPLICATION or NUCLEUS.
REMOTE_DEFINITION	CHAR(8)	Indicates whether this program is a local or a remote resource. Values are: LOCAL or REMOTE.
REMOTE_PROGID	CHAR(8)	The name by which this program is known in the remote CICS® region.
REMOTE_SYSID	CHAR(4)	The name of the remote CICS® region that owns the program.
REMOTE_TRANID	CHAR(4)	The name of the transaction under which the program runs on the remote CICS® region.
SPECIFIED_AMODE	CHAR(12)	The addressing mode specified for the resource. Values are: AMODE24, AMODE31, AMODEANY, and NOTSPECIFIED.
SPECIFIED_RMODE	CHAR(12)	The residency mode specified for the resource. Values are: RMODE24, RMODE31, RMODEANY, and NOTSPECIFIED.
FIRST_RUN	TIMESTAMP	Time of first occurrence, in the local time format.
LAST_RUN	TIMESTAMP	Time of latest observation, in the local time format.