PH40087: ABEND0C4 IN DSNX9CAC WHEN RUNNING 64 BIT JAVA STORED PROCEDURES AND NUMBER OF RESULSETS IS GREATER THAN 10

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Abend0C4 in DSNX9CAC running 64 bit java stored procedures when
  the number of resultsets is greater than 10
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Db2 12 for z/OS users of 64 bit Java                         *
  * Stored Procedures that return result sets.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When running 64 bit Java stored                              *
  * procedures and the number of                                 *
  * result sets returned is greater than                         *
  * 10, the following abend may happen.                          *
  * ABND=0C4-00000004,                                           *
  * LOC=DSNXGRDS.DSNX9CAC+024C4                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  When the number of result sets returned from a 64 bit Java
  stored procedure is great than 10, Db2 allocates a storage
  to save the information. However, in the later result set
  processing, code is missing to save the pointer that points
  to the storage in a Db2 control block. This results in the
  OC4 abend when Db2 references the pointer in the control
  block.
  

Problem conclusion

• Code has been added to save the pointer that points to the
  storage for the result set information to a Db2 control block.
  Additional Keywords:
  ABEND0C4 SQLSTOREDPROC
  

Temporary fix

Comments

APAR Information

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

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

  UI77255

Modules/Macros

• DSNX9WL6 DSNX9JV6
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI77255

     UP21/09/30 P F109

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.