General Architecture

The ConnecX SQL Gateway consists of three subsystems:

  • The ConnecX Attachment Facility (CXGCICS) allows an application to participate on a CICS transaction and interface with the ConnecX Multiclient Subsystem.

  • The ConnecX Multiclient Subsystem (CXGSERV) provides connectivity to the Adabas SQL Gateway.

  • The ConnecX Connect Manager (CXGCONM) allows a batch application to connect to the Adabas SQL Gateway using CICS runtime options.

Applications that you want to use this functionality must be written in C or COBOL. The interaction of these three subsystems is depicted in the following diagram:


In this diagram, CDD stands for "CONNX Data Dictionary", DB stands for "database", and LUW stands for "Linux, UNIX, Windows".

This document covers the following topics:

ConnecX Attachment Facility (CXGCICS)

The relationship between the ConnecX Attachment Facility (CXGCICS) and the ConnecX Multiclient System (CXGSERV) is depicted below, showing the detailed CXGCICS subsystem components involved.


The ConnecX Attachment Facility (CXGCICS) subsystem includes the following components:

  • The user application is an application program that executes under CICS and issues one or more SQL requests or SYNCPOINT requests. These requests are passed by CICS to the CXGCICS subsystem for processing.

  • PLT programs are routines that handle the initialization and termination of the CXGCICS subsystem.

  • Runtime options are loaded and processed by the initialization routine. They are used to configure the CXGCICS subsystem, locate the CXGSERV subsystem, and to define the connection information used when connecting to the CXGSERV subsystem. This connection information includes any necessary transaction and server definitions, DSN assignments, and user identification schema that should be used in making the connection attempt.

  • The Access Control Table is loaded and processed by the initialization routine. The table entries are encrypted security tokens that are referenced by the user identification schema of the transaction definitions and are used in the connection information passed to the CXGSERV subsystem.

  • The service task is started during initialization and establishes and monitors the connection to the CXGSERV subsystem and handles any loss of connectivity.

  • The recovery routine is started by the service task to retrieve in-doubt units of work from the ConnecX SQL Gateway and schedule them for recovery processing.

  • The STUB routine (the application program interface) is bound to the application and enables communication with the CXGCICS subsystem. It resolves the call interface generated by the precompiler and handles errors produced when the CXGCICS subsystem is not enabled.

  • The TRUE (task-related user exit) handles CICS events and passes application calls to the resource adapter for processing.

  • The resource adapter passes SQL requests to the CXGSERV subsystem.

  • Coordinator services manage the connections with the CXGSERV subsystem.

ConnecX Multiclient Subsystem (CXGSERV)

The ConnecX Multiclient Subsystem (CXGSERV) subsystem provides multiclient support for the SQL client interface. The server provides the following services:

  • A session manager manages the user sessions and recovery processing.

  • An RCI client that is an implementation of the SQL client interface and is used in 3GL programs.

  • An HTTP monitor service administers and monitors the CXGSERV subsystem.

ConnecX Connect Manager (CXGCONM)

The ConnecX Connect Manager (CXGCONM) subsystem architecture is shown below. It uses the connection information defined in the CXGCICS subsystem’s runtime options to enable batch applications to connect to the Adabas SQL Gateway.