IBM Support

PM99041: SQLCODE -901 ATTRIBUTE NOT FOUND FOR OFFLOAD OF A COMMON TABLE EXPRESSION WITH SET OPERATION

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQLCODE -901 Attribute not found for offload of a common table
    expression with set operation when using IBM DB2 Analytics
    Accelerator
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS who use         *
    *                 IBM DB2 Analytics Accelerator.               *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR fixes the following issues    *
    *                      for IBM DB2 Analytics Accelerator.      *
    *                                                              *
    *                      (1) Incorrect output may be returned    *
    *                          from the accelerator for a query    *
    *                          that involves DBCS datatypes.       *
    *                                                              *
    *                      (2) A query with a GROUP BY may have    *
    *                          repeating columns when executed     *
    *                          on an accelerator.                  *
    *                                                              *
    *                      (3) An SQLCODE -901 is returned for     *
    *                          a query that contains a common      *
    *                          table expression inside a set       *
    *                          operation.                          *
    *                                                              *
    *                      (4) Incorrect output may be returned    *
    *                          from the acclerator for a query     *
    *                          that contains a HAVING clause and   *
    *                          no GROUP BY clause.                 *
    *                                                              *
    *                      (5) A query is incorrectly executed on  *
    *                          an accelerator when there is mixed  *
    *                          data column that has a CAST as      *
    *                          VARCHAR and QUERY_ACCEL_OPTIONS     *
    *                          contains the  values 1 or 2 and     *
    *                          DSNHDECP has MIXED set to YES.      *
    *                                                              *
    *                      (6) A query with CASE WHEN (NOT EXISTS) *
    *                          correlated subquery is not blocked  *
    *                          from executing on an accelerator.   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR fixes the following issues for IBM DB2 Analytics
    Accelerator.
    
    (1) Incorrect output may be returned from the accelerator for a
        query that involves DBCS datatypes.
    
    (2) A query with a GROUP BY may have repeating columns when
        executed on an accelerator.
    
    (3) An SQLCODE -901 is returned for a query that contains a
        common table expression inside a set operation.
    
    (4) Incorrect output may be returned from the acclerator for a
        query that contains a HAVING clause and no GROUP BY clause.
    
    (5) A query is incorrectly executed on an accelerator when it
        should be executed on DB2 when there is a mixed data column
        that has a CAST as VARCHAR, QUERY_ACCEL_OPTIONS does not
        contain the value 3, and DSNHDECP has MIXED set to YES.
        This results in incorrect output.
    
    (6) A query with CASE WHEN (NOT EXISTS) correlated subquery is
        not blocked from executing on an accelerator. This type of
        correlated subquery cannot execute on an accelerator.
    
    For static SQL queries that have been bound for acceleration
    and encounter any of the issues above, after applying this
    PTF, REBIND the package for the failing query.
    
    Additional Keywords:
    IDAAV3R1/K SQLCODE901 SQLINCORR SQLINCORROUT INCORROUT
    DB2INCORR/K SQLCTE SQLGROUPBY SQLHAVING IDAAV4R1/K
    

Problem conclusion

  • (1) DB2 code is fixed to return the correct output from the
        accelerator.
    (2) DB2 code is fixed.
    (3) DB2 code is fixed so that the query executes successfully
        on the accelerator.
    (4) DB2 code is fixed to return the correct output from the
        accelerator.
    (5) DB2 code is fixed.
    (6) DB2 code is fixed to block this type of correlated
        subquery from executing on an accelerator.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM99041

  • 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-10-14

  • Closed date

    2013-12-17

  • Last modified date

    2014-01-02

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

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

    UI13637

Modules/Macros

  • DSNXOEX1 DSNXONZC DSNXONZO DSNXONZQ DSNXONZS DSNXOOS1 DSNXOP1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI13637

       UP14/01/01 P F312 ½

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

Modified date: 02 January 2014


Translate this page: