PM86502: ABEND 04E AT DSNXRFC P106

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • predicate :WHERE GOL1 >='013021100000023001'
    COL1 is defined as double
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of predicates with *
    *                 a double floating point column being         *
    *                 compared to a decimal floating point         *
    *                 constant.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND04E RC00E70005 can occur at     *
    *                      location DSNXGRDS DSNXRFC P106 for an   *
    *                      SQL statement containing a predicate    *
    *                      that compares a double floating point   *
    *                      column to a decimal floating point      *
    *                      constant.                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND04E RC00E70005 can occur at location DSNXRFC offset P106
    for a query that contains a predicate which compares a double
    floating point column to a constant that is a decimal floating
    point number.  The problem can occur when precision is lost when
    converting the constant to a DOUBLE data type.
    
    The following example illustrates how this problem can occur.
    
    1. Create a table with a column defined as a DOUBLE data type.
    
      CREATE TABLE TEST (C1 DOUBLE);
      INSERT INTO TEST VALUES (1.11111111111111);
    
    2. Execute the following query.
    
      SELECT * FROM TEST
      WHERE C1 >= DECFLOAT('013021100000023001')
    
    
    DB2 should retrieve the inserted data when executing the query.
    However, the above ABEND occurs because DB2 did not handle
    converting the decfloat constant correctly.
    

Problem conclusion

  • DB2 has been modified to convert the decfloat constant correctly
    to a double floating point number which will allow the predicate
    comparison to work properly.
    
    Additional Keywords : SQLDECFLOAT SQLDOUBLE SQLDECIMAL SQLFLOAT
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM86502

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-08

  • Closed date

    2013-06-19

  • Last modified date

    2013-08-02

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

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

    UK95255

Modules/Macros

  •    DSNXRFC
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK95255

       UP13/07/09 P F307

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM86502

Modified date:

2013-08-02

Translate my page

Machine Translation

Content navigation