PM94696: ABEND0C4 RC3B DSNGEPLC +9014 OFFSET9014 WHEN INSERTING A LARGE STATEMENT INTO THE DYNAMIC STMT CACHE POOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC3B DSNGEPLC +9014 OFFSET9014 after inserting a
  large statement into the Dynamic Stmt Cache pool .
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 dynamic statement cache users with   *
  *                 SQL statement section size greater than 65K  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users may receive the following         *
  *                      ABND0C4 RC0000003B at DSNGEPLC+9014.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When running a dynamic statement SQL with the dynamic statement
  cache enabled, DB2 stores the SQL section in the dynamic
  statement cache pool. An incorrect size is used to acquire the
  storage. If the SQL statement has a section size over 65K, an
  overlay could occur.
  

Problem conclusion

• DB2 has been changed to acquire the correct storage to prevent
  the overlay.
  
  Additional keywords: DB2OVRLAY/K SQLDYNSTMTCACHE SMCOVERLAY
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

• ž**** PE14/04/25 FIX IN ERROR. SEE APAR PI16377  FOR DESCRIPTION
  

APAR Information

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

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

  UK98135 UK98136 UK98137

Modules/Macros

• DSNGECMP DSNGEDLC DSNGEELC DSNGEFBK DSNGEFLC DSNGEFSP DSNGEGBK
  DSNGEGFB DSNGEGSK DSNGEINT DSNGEPIS DSNGEPLC DSNGERBK DSNGESLC
  DSNGEZPM DSNTFDMP DSNWDFSM
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK98135

     UP13/10/17 P F310 ½

• RB10 PSY UK98136

     UP13/10/17 P F310 ½

• R910 PSY UK98137

     UP13/10/17 P F310 ½

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.