IBM Support

PI85560: CURRENT TIMESTAMP DISCREPANCY BETWEEN DB2 AND ACCELERATOR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • If a query which uses the special register "current timestamp"
    is being offloaded to the accelerator, the timestamp returned
    might be different from Db2 when the Db2 local timezone has an
    offset to the UTC timezone (e.g. UTC-7). The offset is being
    calculated into the opposite direction.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the                             *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 5.1                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: This PTF contains stored procedure      *
    *                      and accelerator server updates that are *
    *                      part of IBM DB2 Analytics Accelerator   *
    *                      for z/OS version 5 refresh 5.           *
    *                                                              *
    *                      IDAAV5R1/K                              *
    ****************************************************************
    * RECOMMENDATION: Before installing this PTF,                  *
    *                 make sure that all prerequisites are         *
    *                 installed on your target system.             *
    *                 This includes the appropriate version        *
    *                 of the IBM DB2 Analytics Accelerator         *
    *                 Studio.                                      *
    *                 For information, see:                        *
    *                 http://www.ibm.com/support/                  *
    *                   docview.wss?uid=swg27046305                *
    *                                                              *
    *                 This PTF contains:                           *
    *                 Server version: 5.1.5                        *
    *                   (build: 20170808-1945)                     *
    *                 Stored procedure build: 5.1.5                *
    *                   (build: 20170622-1947)                     *
    *                                                              *
    *                 If you have not yet configured               *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 5.1, read the following manuals      *
    *                 that are all available on                    *
    *                 http://www.ibm.com/support/                  *
    *                    docview.wss?uid=swg27047135               *
    *                 - The "Getting Started" manual               *
    *                 - and the Installation Guide                 *
    *                 - and the Release Notes                      *
    *                                                              *
    *                 ATTENTION:                                   *
    *                 Prerequisite for activating this PTF:        *
    *                 1. The base package (RELFILES) for FMID      *
    *                    HAQT510 must have been applied.           *
    *                 2. FMID HCHCA21 must have been applied.      *
    *                 3. For the prerequisites of the following    *
    *                    components see                            *
    *                    http://www.ibm.com/support/               *
    *                          docview.wss?uid=swg27046305         *
    *                    a. IBM DB2 Analytics Accelerator Studio   *
    *                    b. Netezza Firmware (FDT)                 *
    *                    c. Netezza Host Platform (HPF)            *
    *                    d. Netezza Platform Software (NPS)        *
    *                    e. DB2 PTFs                               *
    *                    f. Infosphere Change Data Capture Agent   *
    *                       PTFs                                   *
    *                                                              *
    *                 Activating the PTF is a multi-step process:  *
    *                                                              *
    *                 1. Transfer and activate Access Server       *
    *                    (provided with a separate PTF)            *
    *                    For instructions, see the                 *
    *                    Installation Guide, Chapter 11:           *
    *                      "Installing Updates"                    *
    *                    For the correct versions, see             *
    *                    the prerequisites site:                   *
    *                    http://www-01.ibm.com/support/            *
    *                      docview.wss?uid=swg27046305             *
    *                                                              *
    *                 2. Transfer and activate the software on     *
    *                    the IDAA system with the update included  *
    *                    in this PTF (unless this or a later       *
    *                    version is already installed).            *
    *                    For instructions, see the                 *
    *                    Installation Guide, Chapter 11:           *
    *                           "Installing Updates"               *
    *                                                              *
    *                 3. The next two steps may be performed in    *
    *                    an arbitrary order.                       *
    *                                                              *
    *                  - Activate the stored procedures included   *
    *                    in this PTF by following                  *
    *                    the steps in the                          *
    *                    Installation Guide, Chapter 6:            *
    *                           "Setting up IBM DB2 Analytics      *
    *                            Accelerator for z/OS".            *
    *                    Having completed the activation,          *
    *                    verify the configuration by following     *
    *                    the steps in the Installation Guide       *
    *                    under "Verifying the installation of      *
    *                      IBM DB2 Analytics Accelerator for z/OS  *
    *                      stored procedures".                     *
    *                                                              *
    *                  - Transfer and activate NPS (provided with  *
    *                    separate PTFs). For the correct version   *
    *                    see the prerequisites site:               *
    *                    http://www-01.ibm.com/support/            *
    *                      docview.wss?uid=swg27046305             *
    *                                                              *
    *                    The process to determine the Netezza FDT  *
    *                    and HPF versions is described in the      *
    *                    Release Notes on                          *
    *                    http://www.ibm.com/support/               *
    *                       docview.wss?uid=swg27047135            *
    *                                                              *
    *                    If the Netezza FDT and HPF version        *
    *                    prerequisites listed above are not met,   *
    *                    plan for an outage to upgrade.            *
    *                    For details, see:                         *
    *                    http://www-01.ibm.com/support/            *
    *                       docview.wss?uid=swg21626217            *
    ****************************************************************
    This PTF contains fixes for the issues described below.
    
    A detailed description for each fix can be found in the
    following support document:
    http://www.ibm.com/support/docview.wss?uid=swg27050024
    ================================================================
    1. What's new?                                                 v
    ================================================================
    1.1 Add column support                                         v
    ================================================================
    1.2 Multi row insert                                           v
    ================================================================
    1.3 Federation                                                 v
    ================================================================
    ****************************************************************
    ================================================================
    2. Solved problems                                             v
    ================================================================
    2.1 Stored procedure SYSPROC.ACCEL_GET_TABLES_DETAILS returns  v
        error message AQT10301E                                    v
    ================================================================
    2.2 DSNR035I message in console log while running a load job   v
    ================================================================
    2.3 Discrepancy between 'DISK STORAGE IN USE' values           v
    ================================================================
    2.4 Load jobs fail with out-of-memory error condition          v
    ================================================================
    2.5 Load jobs fail with message 'Missing management            v
        subscription for subscription XXX.'                        v
    ================================================================
    2.6 Slow load performance on growth-on-demand systems with     v
        limited resources                                          v
    ================================================================
    2.7 Current timestamp discrepancy between Db2 and accelerator  v
    ================================================================
    2.8 Multi-row inserts into accelerator-only tables fails with  v
        error SQL0904N                                             v
    ================================================================
    ****************************************************************
    ================================================================
    3. Known issues                                                v
    ================================================================
    Please see here:
    
    A detailed description for the solved problems and the known
    issues can be found in the following support document:
    http://www.ibm.com/support/docview.wss?uid=swg27050024
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI85560

  • Reported component name

    IDAA FOR ZOS

  • Reported component ID

    5697AQT00

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-08-09

  • Closed date

    2017-08-17

  • Last modified date

    2017-09-02

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

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

    UI49630

Modules/Macros

  •    AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10
    AQTDBDBI AQTDBDYN AQTDBQIT AQTDBTRC AQTDBTRN AQTDBUNL AQTDBZPR
    AQTDEFTR AQTENV   AQTHFSCL AQTNILIC AQTNOTE  AQTPKAP1 AQTPKAP2
    AQTPKCFG AQTSCALL AQTSCI01 AQTSCI02 AQTSJI00 AQTSJI01 AQTSJI02
    AQTSJI03 AQTSJI04 AQTSJI05 AQTSSCHK AQTSSCPY AQTSXADD AQTSXALT
    AQTSXCN0 AQTSXCN1 AQTSXCN2 AQTSXCN3 AQTSXCN4 AQTSXIM0 AQTSXQHI
    AQTSXSD1 AQTSXTCO AQTSXTSL AQTSXTSU AQTSXTS0 AQTTIJSP AQTTRIN
    AQT02AAC AQT02ALT AQT02ART AQT02ATB AQT02CAC AQT02CDC AQT02CRT
    AQT02ENQ AQT02FGV AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI
    AQT02GTR AQT02ISP AQT02LTB AQT02MIG AQT02PSD AQT02RAC AQT02RAT
    AQT02RRT AQT02RTB AQT02RTR AQT02STA AQT02SYN AQT02TCO AQT02UCR
    AQT02USW
    

Fix information

  • Fixed component name

    IDAA FOR ZOS

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R510 PSY UI49630

       UP17/08/22 P F708

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: z/OS family

Software version: 510

Operating system(s): z/OS

Reference #: PI85560

Modified date: 02 September 2017


Translate this page: