Affinity views
The following affinity views are defined.
- V_CIU_AFFINITY
- This
view is a simple DB2® equi-join
of CIU_AFF_GRP_DATA and CIU_AFF_CMD_DATA, using TRANGROUP and APPLID
in CIU_AFF_GRP_DATA and AFFGROUP and APPLID in CIU_AFF_CMD_DATA.
Table 1. View V_CIU_AFFINITY Column Type Description APPLID CHAR(8) CICS® region APPLID. TRANGROUP CHAR(10) Name of the transaction group, for example, TS00000002. AFFTYPE CHAR(2) The type of affinity: - IT
- Inter transaction
- TS
- Transaction system.
GROUPTYPE CHAR(30) The group of CICS commands used by this transaction, one of the following: - ADDRESS CWA
- CANCEL, DELAY, POST, START group
- ENQ and DEQ pair
- GETMAIN and FREEMAIN pair
- GETMAIN UNMATCHED and FREEMAIN UNMATCHED pair
- LOAD and RELEASE pair
- LOAD and FREEMAIN pair
- LOAD UNMATCHED and FREEMAIN UNMATCHED pair
- RETRIEVE
- TEMPORARY STORAGE
- COLLECT
- DISCARD
- ENABLE and DISABLE pair.
AFFINITY CHAR(10) The affinity relation type, one of the following: - GLOBAL
- BACKGROUND
- BAPPL
- LINK3270
- LUNAME
- USERID.
AFFWORSENED CHAR(10) The relation type of the affinity has worsened from one of the following: - BACKGROUND
- BAPPL
- LINK3270
- LUNAME
- USERID
LIFETIME CHAR(10) The lifetime of the affinity, one of the following: - ACTIVITY = BTS activity
- FACILITY = Link3270 bridge facility
- LOGON = Logon
- PCONV = Pseudoconversation
- PERMANENT = Permanent
- PROCESS = BTS process
- SIGNON = Signon
- SYSTEM = System
LIFEWORSENED CHAR(10) The affinity lifetime has worsened from, one of the following: - ACTIVITY
- FACILITY
- LOGON
- PCONV
- PROCESS
- SIGNON
- SYSTEM
RECOVERY CHAR(1) Whether the CICS resource is recoverable: - Y
- Recoverable
- N
- Not recoverable.
RESOURCE CHAR(50) The name of the CICS resource, for example, a program name. RESLENGTH SMALLINT The length of the name of the CICS resource. TYPE CHAR(8) The type of the CICS resource, such as TS queue, program. TRANCOUNT SMALLINT The total number of CICS transactions in this affinity group. PROGCOUNT SMALLINT The total number of CICS programs in this affinity group. BUILD CHAR(1) Whether this affinity transaction-group is to be included in a "combined" affinity-transaction-group definition, created by the CICS IA Builder. - Y
- This affinity transaction-group is to be included in a "combined" affinity-transaction-group definition.
- N
- This affinity transaction-group is not to be included in a "combined" affinity-transaction-group definition.
TRANSID CHAR(4) CICS transaction ID. PROGRAM CHAR(8) Currently active CICS program. OFFSET INTEGER Offset, from the start of the program, at which this command occurs. COMMAND CHAR(24) EXEC CICS command. RESTYPE CHAR(16) Resource type, for example, program. TERMINAL CHAR(1) Whether there is a terminal associated with the transaction: - Y
- Terminal transaction
- N
- Nonterminal transaction.
BTS CHAR(1) Whether this is a BTS task: - Y
- BTS task
- N
- Non-BTS task.
LINK3270 CHAR(1) Whether this is a LINK3270 transaction: - Y
- LINK3270 transaction
- N
- Non-LINK3270 transaction.