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.
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
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.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


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