IBM Support

PI71144: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 5 GA UPDATE #3

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • THIRD SMP/E INSTALLABLE FOR IDAA VERSION 5.1.0
    
    IDAAV5R1/K
    

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 3.           *
    *                                                              *
    *                      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.3                        *
    *                   (build: 20161019-0001)                     *
    *                 Stored procedure build: 5.1.2                *
    *                   (build: 20160310-1108)                     *
    *                                                              *
    *                 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.
    
    ================================================================
    1. What's new                                                  v
    ================================================================
    1.1 Load performance improvements when loading small tables in v
        parallel                                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2. Solved Problems                                             v
    ================================================================
    2.1 Snippet-Processing Units (SPUs) running out of resources   v
    ================================================================
    2.2 Accelerator-shadow tables become inconsistent with empty   v
        tables in DB2 for z/OS                                     v
    ================================================================
    ****************************************************************
    ================================================================
    3. Known issues                                                v
    ================================================================
    Please see here:
    
    A detailed description for the new features, solved problems
    and the known issues can be found in the following support
    document:
    http://www.ibm.com/support/docview.wss?uid=swg27048942
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI71144

  • Reported component name

    IDAA FOR ZOS

  • Reported component ID

    5697AQT00

  • Reported release

    510

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-10-25

  • Closed date

    2016-11-07

  • Last modified date

    2016-12-01

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

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

    UI42327

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 AQT02ENQ
    AQT02FGV AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI AQT02ISP
    AQT02LTB AQT02MIG AQT02PSD AQT02RAC AQT02RAT AQT02RTB AQT02STA
    AQT02SYN AQT02TCO AQT02UCR AQT02USW
    

Fix information

  • Fixed component name

    IDAA FOR ZOS

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R510 PSY UI42327

       UP16/11/11 P F611

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

Modified date: 01 December 2016


Translate this page: