Connections table

Use the information in the CIU_CONNECTIONS table to write your own SQL applications to query the tables; these applications must use native SQL queries.

CIU_CONNECTIONS
This table stores the information about IPCONN-based and CONNECTION-based connections that are defined in the CICS® region.
Table 1. The CIU_CONNECTIONS table
Field Name Type Description
COLLECTION_ID CHAR(16) Collection ID.
ARCHIVE_DATE TIMESTAMP Time of archiving.
APPLID CHAR(8) CICS region Applid.
HOMESYSID CHAR(4) SYSID of local region.
RES_NAME CHAR(8) CONNECTION or IPCONN CICS TS resource name
TYPE_INDICATOR CHAR(4) Values are the following:
CONN
for a connection made using the CONNECTION CICS TS resource.
IPIC
for a connection made using the IPCONN CICS TS resource.
STATUS CHAR(12) Connection status. The field name applies to connections made using either the CONNECTION or IPCONN CICS TS resources.
IPCONN_APPLID CHAR(8) APPLID parameter of the IP connection.
IPCONN_HOST CHAR(116) Name of the remote system or its dotted decimal IP address.
IPCONN_PORT CHAR(8) Value is in the range 1 - 65535. This value contains the port number that is to be used for outbound requests on this IPCONN; that is, the number of the port on which the remote system is listening.

If the IPCONN is defined with PORT(NO), the value is 'NO'.

IPCONN_TCPIPSERVICE CHAR(8) TCPIPSERVICE definition that defines the attributes of the inbound processing for this IPCONN.
CONNECTION_NETNAME CHAR(8)

The name by which the remote system is known to the network, from the NETNAME value that is specified in the CONNECTION definition.

ISC connection
The NETNAME corresponds to the VTAM® APPLID of the remote system.
CICS to CICS MRO connection
The NETNAME is the name that the remote system uses to log on to DFHIRP, from the APPLID option in the system initialization table (SIT).
SPECIFIC EXCI connection
The NETNAME is the name of the client program that is passed on the EXCI INITIALIZE_USER command.
GENERIC EXCI connection
The NETNAME is blank.
Indirect connection
The NETNAME corresponds to the APPLID, as specified in the SIT APPLID option of the terminal-owning region.
FIRST_RUN TIMESTAMP Time of first occurrence, in the local time format.
LAST_RUN TIMESTAMP Time of latest observation, in the local time format.