IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PI06338

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-15

  • Closed date

    2014-04-16

  • Last modified date

    2014-06-03

  • 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.



Document information

More support for: DB2 for z/OS

Software version: A10

Reference #: PI06338

Modified date: 03 June 2014


Translate this page: