Affinity base tables

This section describes the Affinity base tables defined in the database. You can write your own SQL applications to query the tables; these applications must use native SQL queries to do this.

CIU_AFF_GRP_DATA
This table stores information about every affinity transaction group; that is, every group of CICS® transactions that have been grouped together because they have the potential to create an affinity.
Table 1. The CIU_AFF_GRP_DATA table
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
Intertransaction
TS
Transaction-system.
GROUPTYPE CHAR(30) The group of CICS® commands used by this transaction group; 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 from which 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
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.
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 INTEGER Length of 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.
CIU_AFF_CMD_DATA
This table records every unique combination of:
  • EXEC CICS command with the potential to create an affinity
  • Program
  • Transaction ID
Table 2. The CIU_AFF_CMD_DATA table
Column Type Description
APPLID CHAR(8) CICS® region APPLID
TRANSID CHAR(4) CICS® transaction ID
PROGRAM CHAR(8) Currently active CICS® program
OFFSET CHAR(8) 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
AFFGROUP CHAR(10) Name of the affinity transaction group to which this transaction belongs
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
USAGE SMALLINT Number of times this CICS® command is called from this program