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