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.