Defining the CICS Db2 connection

The structure and performance of your CICS® Db2® connection is determined when you define the DB2CONN, DB2ENTRY, and DB2TRAN objects.

Before you begin

For CICS to connect to Db2, you must add one or both Db2 load libraries to the CICS startup job, as needed:
  • The db2hlq.SDSNLOAD Db2 library, so that the CICS Db2 attachment facility is able to load the Db2 program request handler, DSNAPRH.
  • The db2hlq.SDSNLOD2 Db2 library, required if you want to use JDBC or SQLJ with a Db2 type 2 connection. This is in addition to the SDSNLOAD library required for non-Java™ programs.

    The Liberty Db2 data source with type 4 connectivity does not use the CICS Db2 connection resource, so there is no requirement for any additional CICS configuration.

Place the Db2 load libraries in the MVS™ link list, or add it to the STEPLIB concatenation of the CICS job. db2hlq is the high-level qualifier for Db2 libraries. If you use STEPLIB, add the Db2 library after the CICS libraries in the STEPLIB DD statement; see A sample CICS startup job for an example.

Note:

Generally, you do not have to include any Db2 libraries in the DFHRPL DD statement. If you do require Db2 libraries in the DFHRPL concatenation for an application, they must be placed after the CICS libraries.

About this task

The DB2CONN, DB2ENTRY, and DB2TRAN objects describe the global attributes of the CICS Db2 connection, the relationship between CICS transactions and Db2 resources (including application plans and command processors), the attributes of each type of thread, and the type of thread that each transaction can use.