PI14368: MULTIPLE FIXES ON DB2 FOR Z/OS RUNNING WITH AN ACCELERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Multiple fixes on DB2 for z/OS running with an accelerator.
    (d172099)
    IDAAV4R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use            *
    *                 IBM DB2 Analytics Accelerator.               *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR fixes the following issues    *
    *                      for IBM DB2 Analytics Accelerator.      *
    *                                                              *
    *                      (1) For an EXPLAIN of an INSERT with    *
    *                          subSELECT statement,                *
    *                          DSN_QUERYINFO_TABLE may not         *
    *                          populate with any rows.             *
    *                      (2) A query with the function TRUNC     *
    *                          may return incorrect output when    *
    *                          executed on an accelerator.         *
    *                      (3) A query that contains an ORDER BY   *
    *                          in a set operation may fail on      *
    *                          an accelerator.                     *
    *                      (4) A query with the function CHAR      *
    *                          with a FOR BIT DATA column and      *
    *                          OCTETS may return incorrect         *
    *                          output.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR fixes the following issues for IBM DB2 Analytics
    Accelerator.
    
    (1) For an EXPLAIN of an INSERT with subSELECT statement,
    DSN_QUERYINFO_TABLE may not populate with any rows when
    zparm QUERY_ACCEL_OPTIONS does not include the value 2.
    
    (2) A query with the function TRUNC may return incorrect
    output when executed on an accelerator if the value of the
    1st argument is very large. For example TRUNC(C1,-1) where
    C1 is a BIGINT column with a value of 14683479057743532.
    
    (3) A query that contains an ORDER BY within a set operation
    UNION, UNION ALL, INTERSECT, INTERSECT ALL, EXCEPT, or
    EXCEPT ALL may fail with SQLCODE -901 Reason "42000: ERROR:
    found "NULLS" on an accelerator.
    
    (4) A query with the function CHAR with a FOR BIT DATA
    column and OCTETS may return incorrect output.
    
    For static SQL queries that have been bound for acceleration
    and will use any of the new functions above, after applying
    this PTF, REBIND the package for the failing query.
    
    Keywords:
    IDAAV3R1/K IDAAV4R1/K SQLINCORR SQLINCORROUT INCORROUT
    DB2INCORR/K SQLTRUNC SQLEXPLAIN SQLSETOP
    SQLCHAR FORBITDATA
    

Problem conclusion

  • DB2 code is fixed for expected results and behavior.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI14368

  • 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

    2014-03-24

  • Closed date

    2014-06-26

  • Last modified date

    2014-08-04

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

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

    UI19207 UI19208

Modules/Macros

  •    DSNXODML DSNXONZC DSNXONZS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI19207

       UP14/07/12 P F407

  • RB10 PSY UI19208

       UP14/07/12 P F407

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 #:

PI14368

Modified date:

2014-08-04

Translate my page

Machine Translation

Content navigation