SQLCODE -927 in Gen TSO Test Facility (Application Test Facility)

Products

• Gen
• Gen - Host Encyclopedia

Issue/Introduction

SQLCODE -927 occurred when using Gen 8.6 TSO Test Facility (Application Test Facility)

Environment

Release : 8.6
Component : Gen Host Encyclopedia

Cause

A SQLCODE -927 occurs when a program bound with a DB2 call attach module calls another program bound with a different DB2 call attach module.  This can occur when using the TSO Test Facility.  Programs on the Host are generally bound using a TP Monitor of CICS or IMS.  The Test Facility is run under TSO and the DB2 calls must target the TSO DB2 call attach which occurs when the TP Monitor target is IEFAE.  Dynamically called modules may have a different DB2 call attach module.  It can also occur when using dynamic triggers.  Another cause is EABs may be installed outside of Gen and include a different DB2 call attach in the link.  When this happens, the SQL CODE -927 occurs.  

The DB2 call attach modules are:

DSNELI -- BATCH

DSNCLI – CICS

DFSLI000 – IMS

DSNALI – TSO

For more info on DB2 attach, see: Using the Toolset > DB2 Attach

Resolution

To resolve the SQL CODE -927 in the TSO Test Facility, reinstall the called program with the TSO DB2 call attach or statically link the load module.  There is no good work-around or resolution if the called program is a trigger module.  In this case, the triggers would have to be regenerated and installed which is not an ideal solution since they affect the entire model.  Reinstalling individual trigger modules can be tedious but possible.  If testing is desired when using dynamic triggers, use the Diagram Test Facility (DTF).