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
- 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.
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.