PH36327: AFTER APAR PH17958,OVERFLOW DURING SQL EVALUATION IN SQL MODE LEADS TO ABENDS0CA INSTEAD OF 227 * EXPRESSION EVALUATION ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the fix for APAR PH17958/PB59069 has been applied, Db2 HPU
  terminates in ABENDS0CA when a logical unload (SELECT
  statement), run in native mode, specifies an SQL expression
  which evaluation leads to an overflow.
  In such a situation, Db2 HPU should handle the overflow
  situation by reporting an error at record level by a message
  such as the following one :
  227 * EXPRESSION EVALUATION ERROR * ddname * column
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for APAR PH17958/PB59069  *
  *                      has been applied, Db2 HPU terminates in *
  *                      ABENDS0CA when a logical unload         *
  *                      (SELECT statement), run in native mode, *
  *                      specifies an SQL expression which       *
  *                      evaluation leads to an overflow.        *
  *                                                              *
  *                      In such a situation, Db2 HPU should     *
  *                      handle the overflow situation by        *
  *                      reporting an error at record level by a *
  *                      message such as the following one :     *
  *                      227 * EXPRESSION EVALUATION             *
  *                      ERROR * ddname * column                 *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After APAR PH17958, overflow during SQL evaluation in native
  mode leads to ABENDS0CA instead of 227 * EXPRESSION EVALUATION
  ERROR,
  

Problem conclusion

• Code has been changed to fix this problem
  

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:

Modules/Macros

• INZ$$PRM INZBIND  INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI75100

     UP21/05/07 P F105 {

• R510 PSY UI75101

     UP21/05/07 P F105 {

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.