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
For an explanation of these lifetime values, see Worsening of transaction affinities relations.
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
For an explanation of these lifetime values, see Affinity lifetimes.
LIFEWORSENED CHAR(10) The affinity lifetime has worsened from, one of the following:
  • ACTIVITY
  • FACILITY
  • LOGON
  • PCONV
  • PROCESS
  • SIGNON
  • SYSTEM
For an explanation of these lifeworsened values, see Worsening of transaction affinities lifetimes.
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.