DB2 CALL ATTACH in CA Gen

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

DB2 Call Attach and error SQL CODE -927

Background:

The error SQL CODE -927 indicates a mixture of DB2 Call Attach Modules.  These modules are owned by IBM and used in selected environments.  They cannot be mixed.  When the CA Gen TP Monitor is set or changed, the following DB2 Call Attach modules are linked in the Gen load module as follows:

DSNALI = TSO

DSNELI = BATCH

DSNCLI = CICS

DFSLI000 = IMS

 

 

Environment:
z/OS
Instructions:

A.  Most of the time the SQL Code -927 is received when a module is generated to be used in the TSO Test Facility.  Gen will link the module where the TP Monitor is IEFAE with the DB2 Call Attach as DSNALI.  If the load module is dynamic and calls another dynamic module that was installed with a different DB2 Call Attach, the error occurs.  If the load module calls an EAB which is installed outside of Gen with a different DB2 Call Attach, the error occurs.

To resolve, all modules that are called in a run-unit must be reinstalled with the TSO DB2 Call Attach module or statically linked the load module.

 

B.  When using dynamic RI Triggers, the TSO Test Facility will not function properly.  A SQL Code -927 will occur with applications generated for trace when a DB access is requested and the RI Triggers are installed with the target TP Monitor (IMS or CICS).  The DB2 Call Attach module is different and will cause the SQL Code -927. 

To resolve, use DTF (Debug Trace Facility).