II02759: HINTS & TIPS FOR ATTACH - VARIOUS SYMPTOMS MAY OCCUR WHEN AN APPLICATION PGM INCLUDES INCORRECT LANGUAGE INTERFACE

APAR status

• Closed as canceled.

Error description

• 5740XYR00 HIM2202 HIX1202 HIY1202
  5740XYR00 HIM2302 HIX1302 HIZ1302 R220 R230 R310 R410
     INVALID OR INCORRECT SQLCODE OR AN ABEND0C4 DURING EXECUTION
  ARE  POSSIBLE SYMPTOMS OF INCLUDING AN  INCORRECT LANGUAGE
  INTERFACE MODULE WITH A DB2 APPLICATION PROGRAM.  THE EXACT
  SYMPTOMS VARY WITH THE INDIVIDUAL PROGRAM AND THE INTENDED
  EXECUTION ENVIRONMENT.  AN EXAMPLE IS AN IMS APPLICATION THAT
  PICKS UP CODE FROM DSNELI (INSTEAD OF DFSLI000) TO RESOLVE ENTRY
  POINT ALIAS DSNHLI DURING THE LINKEDIT STEP OF PROGRAM PREP. AN
  ABEND0C4 IS LIKELY DURING EXECUTION WHEN DB2 PRECOMPILER
  INSERTED CODE ATTEMPTS TO CALL THE LANGUAGE INTERFACE CODE.
  ANOTHER EXAMPLE IS A CICS APPLICATION THAT INCLUDES CODE FROM
  DSNELI (INSTEAD OF DSNCLI).  THE SQLCODE IN THE SQLCA ON RETURN
  FROM THE FIRST SQL CALL MAY BE A LARGE NEGATIVE INTEGER SUCH AS
  -16777216 X'FF000000' OR OTHER SUCH INVALID SQLCODE.
  MANY OTHER MISMATCHES BETWEEN LANGUAGE INTERFACE AND EXECUTION
  ENVIRONMENT ARE POSSIBLE.
     ( ADDITIONAL KEYWORDS SQLCODE216 -216 SQLCODE927 )
  
  THE DB2 ATTACHMENT FACILITIES AND THEIR RESPECTIVE INTERFACE
  MODULES ARE:
  TSO ATTACH  - DSNELI
  CALL ATTACH - DSNALI
  CICS ATTACH - DSNCLI
  IMS ATTACH  - DFSLI000
  ................................................................
     CICS  ATTACH  - NODYNAM must be specified for COBOL/II
     Problem could show up as ABEND0C4 in DSNELI
  ................................................................
  09/22/97 - For DB2 (r410 r510) using CAF
  Problem: DSNALI not being linked correctly, receiving
  SQLCODE-927 or SQLCODE927.
  The linkedit job had an incorrect specification, this
          //SYSLIN   DD  DSN=&&LOADSET,DISP=(OLD,DELETE)
          //SYSIN    DD  *
  should be specified as
          //SYSLIN   DD  DSN=&&LOADSET,DISP=(OLD,DELETE)
          //         DD  DDNAME=SYSIN
  (Note: See the DSNTIJMV job in SDSNSAMP library.)
  

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

• THIS IS AN INFORMATION APAR FOR DB2 5740XYR00
  RP89/03/22 REPINNED TO ADD ADDITIONAL KEYWORDS, ATEXT.
  
  Please refer to the Application Programming and SQL guide for
  information regarding the use of the COBOL DYNAM option.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels