PI06338: SUPPORT OFFLOAD OF NUMERIC TO CHAR CAST WHEN MULTIPLE ENCODING OFFLOADING ENABLED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Support offload of numeric to char cast when multiple encoding
  offloading enabled.                                   (d169708)
  IDAAV3R1/K IDAAV4R1/K
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of DB2 10 for z/OS or DB2 11 for   *
  *                 z/OS who use IBM DB2 Analytics Accelerator.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: This APAR provides a fix for possible   *
  *                      incorrect output when                   *
  *                      1. the statement is a Unicode           *
  *                         statement, and                       *
  *                      2. there exists a char/varchar cast     *
  *                         when the argument is numeric.        *
  *                                                              *
  *                      This APAR also fixes a storage abend    *
  *                      ABEND04E in DSNXGRDS.DSNXONZO M110      *
  *                      when system storage is extremely low.   *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When multiple encoding support is enabled for IBM DB2 Analytics
  Accelerator, possible incorrect output might occur if:
    1. the statement is a Unicode statement, and
    2. there exists a char/varchar cast when the argument is
       numeric.
  DB2 will fix this problem by detecting the above senario
  and correctly converting the specific query.
  
  This APAR also fixes a storage abend: ABEND04E RC00E70005
  in DSNXGRDS.DSNXONZO M110 when the system storage is
  extremely low.
  
  Additional Keywords:
  SQLINCORROUT INCORROUT SQLINCORR DB2INCORR/K
  SQLSTORAGE IDAAV4R1/K IDAAV3R1/K IDAAV2R1/K
  

Problem conclusion

• Possible incorrect output is fixed for a Unicode statement
  in which there exists a char/varchar cast with a numeric type
  argument.
  ABEND04E in DSNXGRDS.DSNXONZO M110 is avoided when the system
  storage level is extremely low.
  

Temporary fix

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

Comments

APAR Information

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

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

  UI17172 UI17173

Modules/Macros

• DSNXONZA DSNXONZC DSNXONZO DSNXONZQ DSNXONZS
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI17172

     UP14/05/06 P F405 ½

• RB10 PSY UI17173

     UP14/05/06 P F405 ½

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.