IBM Support

PI59522: ACCELERATOR OFFLOADING ERROR FOR QUERIES REFERENCING A VIEW WHICH SPECIFIES DATE CONSTANTS FORMAT (E.G. ISO, JIS, ETC.)

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Accelerator offloading error for queries referencing a View
    which specifies date constants format (e.g. ISO, JIS, etc.)
    

Local fix

  • NO WORK AROUND
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 and DB2 11 for z/OS who  *
    *                 use query acceleration and reference a view  *
    *                 with a DATE/TIME CONSTANT FORMAT (ISO, JIS,  *
    *                 etc.) in the view definition.                *
    ****************************************************************
    * PROBLEM DESCRIPTION: When a DATE/TIME CONSTANT FORMAT        *
    *                      (ISO, JIS, etc.) is exploited in a view *
    *                      and the view is referenced in a query   *
    *                      to be offloaded to an accelerator,      *
    *                      incorrect output or other accelerator   *
    *                      errors might occur due to an improperly *
    *                      converted query sent to the             *
    *                      accelerator.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When a view is defined with a DATE/TIME CONSTANT FORMAT (ISO,
    JIS etc.) and the view is referenced by a query to be offloaded,
    incorrect output or other accelerator errors might occur due to
    an improperly converted query sent to the accelerator.
    For example: CREATE VIEW V1(C1) AS
                 SELECT CHAR(T1.DateCol, ISO)
                 FROM T1;
    
                 SET CURRENT QUERY ACCELERATION = ALL;
                 SELECT * FROM V1 FOR FETCH ONLY;
    
    Keywords:
    IDAAV4R1/K IDAAV5R1/K SQLVIEW SQLDATE SQLTIME
    

Problem conclusion

  • This APAR fixes a query conversion problem when the query is
    offloaded to an accelerator. The failing offloaded query
    references a view with a DATA/TIME CONSTANT FORMAT
    (ISO,JIS,etc.).
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PI59522

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-03-22

  • Closed date

    2016-05-02

  • Last modified date

    2016-06-02

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

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

    UI37465 UI37507

Modules/Macros

  •    DSNXONZQ DSNXONZS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI37465

       UP16/05/18 P F605 Ž

  • RB10 PSY UI37507

       UP16/05/18 P F605 Ž

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

Modified date: 02 June 2016


Translate this page: