IBM Support

PI49829: ABEND0C4 DSNXONZC +8CB8 WHEN USING DB2 ZPARM ACCELMODEL = YES W/QUERY ACCELERATION = ENABLE | ELIGIBLE 15/10/01 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When DB2 subsystem parameter ACCELMODEL = YES and
    special register QUERY ACCELERATION = ENABLE | ENABLE WITH
    FAILBACK | ELIGIBLE  to request DB2 query acceleration,
    the following DB2 application abend is possible:
      ABEND0C4 RC00000004 at DSNXGRDS . DSNXONZC +8CB8
    .
    ACCELMODEL = YES requests that DB2 do acceleration modeling,
    so when special register QUERY ACCELERATION is also set,
    the user is requesting that DB2 perform both accelerator
    modeling and actual query acceleration to accelerator server
    for the same query.
    .
    Additional search keywords: IDAAV3R1/K IDAAV4R1/K
    

Local fix

  • If possible, reset DB2 subsystem parm ACCELMODEL=NO .
    ACCELMODEL is an online changeable subsystem parm without
    requiring a DB2 restart.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of                 *
    *                 QUERY ACCELERATION who have                  *
    *                   - applied PI39061 / UI28799 and have       *
    *                     subsystem parameter ACCELMODEL = YES, or *
    *                   - applied PI30859 / UI26382 and have       *
    *                     subsystem parameter OPTHINTS = YES       *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR/PTF addresses the following:  *
    *                      (1) After PI39061/UI28799 is applied,   *
    *                      ABEND0C4 RC00000004 in DSNXONZC +80B8   *
    *                      can occur when subsystem parameter      *
    *                      ACCELMODEL is YES and QUERY             *
    *                      ACCELERATION is requested.              *
    *                                                              *
    *                      (2) After PI30859/UI26382 is applied,   *
    *                      ABEND0C4 RC00000038 in DSNXONZO +2BEE   *
    *                      can occur when all of the following     *
    *                      apply:                                  *
    *                      - Subsystem parameter OPTHINTS = YES    *
    *                      - QUERY ACCELERATION is requested       *
    *                      - The SQL statement references a        *
    *                       table that has an index on             *
    *                       expression and the index contains      *
    *                       at least one column and one            *
    *                       expression.                            *
    *                      - The SQL statement references a view   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR/PTF addresses the following two problems:
     - After PI39061/UI28799 is applied, an ABEND0C4 RC00000004 in
       DSNXONZC+80B8 can occur when all of the following apply:
       (1) DB2 subsystem parameter ACCELMODEL = YES.
       (2) QUERY ACCELERATION is ENABLE, ENABLE WITH FAILBACK , or
           ELIGIBLE .
       (3) At least one table in the SQL statement has an entry
           in SYSACCEL.SYSACCELERATEDTABLES with column ENABLE = 'N'
                                                                   .
     - After PI30859/UI26382 is applied, an ABEND0C4 RC00000038 in
       DSNXONZO+2BEE can occur when all of the following apply:
       (1) Subsystem parameter OPTHINTS = YES.
       (2) QUERY ACCELERATION is ENABLE, ENABLE WITH FAILBACK,
           ELIGIBLE, or ALL.
       (3) The SQL statement references a table that has an index on
           expression and the index contains at least one column and
           one expression.
       (4) The SQL statement references a view.
           If the view is on a table as described in #3, then
           only #4 needs to be referenced in the query, else both
           #3 and #4 are required as separate references in
           the same query.
                                                                   .
    
    Additional search keywords:
    IDAAV4R1/K ACCELMODEL OPTHINTS SQLVIEW SQLINDEXONEXP
    ABEND0C4 AB0C4 RC04 DSNXONZC OFFSET80B8
    

Problem conclusion

  • DB2 code is fixed so that the previously described abends in
    the scenarios above do not occur.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI49829

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-10-01

  • Closed date

    2015-10-20

  • Last modified date

    2015-12-02

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

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

    UI32255

Modules/Macros

  •    DSNXONZO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI32255

       UP15/11/05 P F511

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

Modified date: 02 December 2015


Translate this page: