IBM Support

PI35930: MULTIPLE FIXES FOR ACCELERATOR ONLY TABLES

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Multiple fixes for accelerator only tables.
    IDAAV4R1/K                                   (d176075,d173084)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use query      *
    *                 acceleration.                                *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides the following:       *
    *                      (1) V10: Fix INSERT and UPDATE of an    *
    *                      accelerator-only table of a mixed       *
    *                      character or mixed graphic column.      *
    *                      (2) V10 and V11: Enable acceleration    *
    *                      for the scalar function TIMESTAMP_ISO   *
    *                      (3) V10: INACTIVE support for a         *
    *                      primary connection.                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR provides the following:
    (1) V10: Fix INSERT and UPDATE of an accelerator-only table
    of a mixed character or mixed graphic column.
    (2) V10 and V11: Enable acceleration for the scalar function
    TIMESTAMP_ISO
    (3) V10: INACTIVE support for a primary connection.
    
    Keywords:
    IDAAV4R1/K SQLTIMESTAMP_ISO SQLINSERT SQLUPDATE
    

Problem conclusion

  • (1) Code is fixed to insert and update the value with the
    correct padding.
    (2) TIMESTAMP_ISO can now be executed on an accelerator.
    (3) INACTIVE support for a primary connection is supported now.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI35930

  • 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

    2015-02-26

  • Closed date

    2015-06-24

  • Last modified date

    2015-08-03

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

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

    UI28796 UI28797

Modules/Macros

  •    DSNDQ8ST DSNFMDIR DSNFUDRB DSNLXCM2 DSNLXRAX
    DSNLXRCN DSNLXREL DSNUGMAP DSNUGMSB DSNUMSGB DSNWMSGS DSNWZDG2
    DSNXOEX1 DSNXONZC DSNXOOS1 DSNX8SMF
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI28796

       UP15/07/09 P F507

  • RB10 PSY UI28797

       UP15/07/09 P F507

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

Modified date: 03 August 2015


Translate this page: