The CICS® DB2® attachment facility has to load the DB2 program request handler, DSNAPRH. To do this, the DB2 library, db2hlq.SDSNLOAD, should be placed in the MVS™ linklist, or added to the STEPLIB concatenation of your CICS job (where db2hlq is your chosen high-level qualifier for DB2 libraries).
To use the DB2 JDBC driver shipped with DB2 Versions 7 or 8, the db2hlq.SDSNLOD2 library also needs to be added to the CICS STEPLIB concatenation. The DB2 JDBC drivers shipped with DB2 Versions 5 and 6 do not require this library.
To modify your CICS startup JCL you should concatenate the following libraries on the STEPLIB DD statement as follows:
There should be no DB2 libraries in the DFHRPL DD statement. If DB2 libraries are required in the DFHRPL concatenation by an application, or by another product, they should be placed after the CICS libraries.