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.

Reference Reference

Feedback


Timestamp icon Last updated: Friday, 8 February 2013


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