IBM Support

PM96122: MULTIPLE FIXES FOR IBM DB2 ANALYTICS ACCELERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • 1.When running with IBM DB2 Analytics Accelerator, SQL CODE -901
    can occur for an offload of a statement containing a DATE, TIME,
    and TIMESTAMP constant.  Allow timestamp precision constants
    greater than 6 with zeroes.
    2.A recursive common table expression does not fail with
    SQLCODE -4742 reason 10 when CURRENT QUERY ACCELERATION=ALL or
    GET_ACCEL_ARCHIVE=YES.
    
    IDAAV3R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS who             *
    *                 are also using IBM DB2 Analytics             *
    *                 Accelerator.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR contains the following fixes  *
    *                      for IBM DB2 Analytics Accelerator       *
    *                      support:                                *
    *                                                              *
    *                      (1) A recursive common table expression *
    *                          does not fail with SQLCODE -4742    *
    *                          reason 10 when CURRENT QUERY        *
    *                          ACCELERATION=ALL or                 *
    *                          GET_ACCEL_ARCHIVE=YES. EXPLAIN may  *
    *                          not show REASON_CODE=10.            *
    *                                                              *
    *                      (2) SQLCODE -901 is issued when a query *
    *                          has a date, time or timestamp       *
    *                          constant.                           *
    *                                                              *
    *                      (3) SQLCODE -904 might be issued when   *
    *                          a query has a common table          *
    *                          expression with an ORDER BY.        *
    *                                                              *
    *                      (4) A storage leak may occur for an     *
    *                          INSERT with a common table          *
    *                          expression with row permissions.    *
    *                                                              *
    *                      (5) An INSERT statement with            *
    *                          implicit cast on the target table   *
    *                          is not offloaded.                   *
    *                                                              *
    *                      (6) An SQL statement with a             *
    *                          timestamp literal with precision    *
    *                          9+ with all 0s starting at digit 7  *
    *                          is not offloaded.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR contains the following fixes for IBM DB2 Analytics
    Accelerator support:
    
    (1) A recursive common table expression does not
        fail with SQLCODE -4742 reason 10 when
        CURRENT QUERY ACCELERATION=ALL or
        GET_ACCEL_ARCHIVE=YES. When CURRENT QUERY
        ACCELERATION is not NONE, EXPLAIN may
        not show REASON_CODE=10 in DSN_QUERYINFO_TABLE.
    
    (2) SQLCODE -901 is issued when a query has a date,
        time or timestamp constant. For example:
        SELECT TIMESTAMP '2013-05-08 11:22:33.123456'
        FROM T1 FOR FETCH ONLY;
    
    (3) SQLCODE -904 might be issued when a query has a common
        table expression with an ORDER BY.
    
    (4) A storage leak may occur for an INSERT with a common
        table expression with row permissions.
    
    (5) An INSERT statement with implicit cast on the target
        table is not offloaded.
    
    (6) An SQL statement with a timestamp literal with precision
        9+ with all 0s starting at digit 7 is not offloaded.
    
    Additional Search Keywords:
    IDAAV3R1/K IDAAV4R1/K SQLCTE SQLEXPLAIN SQLCODE4742 SQLCODE904
    SQLCODE901 SQLDATE SQLTIME SQLTIMESTAMP SQLORDERBY SQLCTE
    DB2STGLK/K SQLINSERT SQLACCESSCONTROL
    

Problem conclusion

  • (1) Code is fixed to block offload and fix EXPLAIN results.
    
    (2) Code is fixed to offload the query.
    
    (3) Code is fixed to offload the query.
    
    (4) Code is fixed to resolve the storage leak.
    
    (5) Code is fixed to offload the subselect of the INSERT
        statement.
    
    (6) Code is fixed to offload the query.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM96122

  • 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-08-30

  • Closed date

    2013-09-20

  • Last modified date

    2013-11-04

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

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

    UK97757

Modules/Macros

  • DSNXOEX1 DSNXONZC DSNXONZO DSNXOOS1
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK97757

       UP13/10/09 P F310

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

Modified date: 04 November 2013


Translate this page: