Other servers

Adaptive Server® Enterprise/Component Integration Services (ASE/CIS) and Replication Server® are separate Sybase products that work with the DirectConnect for z/OS Option and can be optional parts of the DB2 UDB Options for CICS and IMS communication paths.


DB2 UDB Options communication path for three-tier environments

For client access to DB2 data, the DB2 UDB Options for CICS and IMS must be installed on the mainframe, and the DirectConnect for z/OS Option must be installed on a LAN server. The DB2 UDB Options for CICS and IMS work together with the DirectConnect for z/OS Option to provide DB2 data to clients as follows (see Figure 1-1):

  1. A client sends SQL requests to the DirectConnect server.

  2. The DirectConnect server forwards the requests to the CICS transaction (AMD2) or the IMS transaction (SYRT) on the mainframe (using SNA or TCP/IP connectivity on the LAN server).

  3. AMD2 or SYRT processes the client SQL requests using the dynamic SQL capabilities of DB2 UDB.

  4. AMD2 or SYRT returns the DB2 result sets and messages to the DirectConnect server (using SNA or TCP/IP connectivity on the LAN server).

  5. The DirectConnect server returns the results and messages to the client.

Figure 1-1: DB2 UDB Options communication path for three-tier


DB2 UDB Options for CICS and IMS communication path for two-tier environments

NoteBecause there is no two-tier support for IMS, this section applies to CICS only.

For gateway-less client access to DB2 data, the DB2 UDB Option for CICS must be installed on the mainframe. The DB2 UDB Option for CICS provides DB2 data to clients as follows (see Figure 1-2):

  1. A client sends SQL requests to the CICS transaction (AMD2) on the mainframe (using TCP/IP connectivity).

  2. AMD2 processes the client SQL requests using the dynamic SQL capabilities of DB2.

  3. AMD2 returns the DB2 result sets and messages to the client (using TCP/IP connectivity).

See Figure 1-2 for an illustration of this process.

Figure 1-2: DB2 UDB Option communication paths for two-tier gateway-less