At CICS region startup CA InterTest for CICS users may receive several DFHAM4837 messages stating that an install of an Intertest resource failed because a DB2CONN is missing.

Document ID : KB000031333
Last Modified Date : 14/02/2018
Show Technical Document Details

At CICS region startup CA InterTest for CICS users may receive several DFHAM4837 messages stating that an install of an Intertest resource failed because a DB2CONN is missing.

CA InterTest for CICS provides a set of CSD DBENTRY and DB2TRAN resource definitions needed for use with DB2 in member CSDDB2 from CAI.CABAJCL.  If these resources are defined, a CICS DB2CONN must be installed before any DB2ENTRY and/or DB2TRAN can be successfully installed.

CICS requires 3 RDO definitions to establish the connection between CICS and DB2.  These RDO definitions are DB2CONN which defines the global parameters of the attachment and pool and command thread definitions, DB2ENTRY which defines the thread definitions for use by specific CICS transactions and DB2TRAN which defines an additional transaction or group of transactions to be associated with a particular DB2ENTRY.

The DB2CONN resource is not to be confused with the SIT parameter DB2CONN=NO/YES which will start the DB2 connection automatically during CICS region initialization.

For regions that require CA InterTest for CICS to interface with DB2, member CAICABAJCL(CSDDB2) provides several RDO definitions to establish this interface.  When the member is edited and run, these definitions will be added to the appropriate INT910xx RDO group (INT91068 for CICS 5.1, for example) and will be installed with the group. 

However, in order for these RDO entries to be successfully installed, the DB2CONN connection must be active.  If this is not done first, then at region startup, CICS will issue several DFHAM4837 messages indicating these resources could not be installed.  Messges such as the following will be issued:

+DFHAM4837 E applid Install of DB2ENTRY IN91DB2E failed because a DB2CONN is not installed.                               

+DFHAM4837 E applid Install of DB2TRAN IN91CNTL failed because a DB2CONN is not installed.

There are two possible reasons why the DFHAM4837 messages might be issued.

First, as above, for CICS regions that require the DB2 interface, the DB2CONN was not installed before the InterTest RDO definitions. Secondly, the region itself does not require the DB2 interface but the CSDDB2 definitions were added to the group.  This can occur if some regions use DB2 and others do not but the same IN910xx RDO group is utilized across all regions.

Although this will not have any effect upon the successful startup of the region, for those that require them, users may not use CA InterTest for CICS with DB2 until this is corrected.  In order to resolve this, ensure that the install of the DB2CONN is successfully completed before any of the DB2ENTRY and/or DB2TRAN resources are installed.

To avoid the second problem, it may be advisable to create a second RDO group for these DB2 resources. Rather than editing CSDDB2 to place these resources into the same group IN910xx with the other CA InterTest for CICS definitions, create a second group such as IN91DB2.  Then include the new group in the same startup list as IN910xx only for the DB2 regions that require it.