IBM Support

PI75504: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 5 GA UPDATE #4

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • FOURTH 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 4.           *
    *                                                              *
    *                      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.4                        *
    *                   (build: 20170217-1406)                     *
    *                 Stored procedure build: 5.1.4                *
    *                   (build: 20170130-1046)                     *
    *                                                              *
    *                 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 Restoring archived partitions from different accelerators  v
    ================================================================
    ****************************************************************
    ================================================================
    1.2 Multi-row insert (beta)                                    v
    ================================================================
    ****************************************************************
    ================================================================
    1.3 Changing the IP address or the TCP/IP port of the Capture  v
        Agent                                                      v
    ================================================================
    ****************************************************************
    ================================================================
    2. Solved problems                                             v
    ================================================================
    2.1 Stored procedure SYSPROC.ACCEL_ARCHIVE_TABLES fails with   v
        AQT10060W                                                  v
    ================================================================
    ****************************************************************
    ================================================================
    2.2 Loading an incrementally updated table fails with error    v
        AQT20017E.                                                 v
    ================================================================
    ****************************************************************
    ================================================================
    2.3 WLM started task returns code U4036 (abnormal ending)      v
    ================================================================
    ****************************************************************
    ================================================================
    2.4 Refreshing the SQL history results in SQL error            v
        'XMLParseException... 'Unterminated entity reference''     v
    ================================================================
    ****************************************************************
    ================================================================
    2.5 SYSPROC.ACCEL_GET_TABLES_INFO returns warning AQT10115W    v
        if versions do not match                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.6 DSNX881I message 5  RunAwayQuery  is written to system     v
        logs of unaffected DB2 subsystems                          v
    ================================================================
    ****************************************************************
    ================================================================
    2.7 Mako Ultralite (N3001-001) ceases to work after upgrade of v
        Netezza Host Platform (HPF) software                       v
    ================================================================
    ****************************************************************
    ================================================================
    2.8 dwamonitor IP address can no longer be identified          v
    ================================================================
    ****************************************************************
    ================================================================
    2.9 Generated JCL of AQTTRIN fails with BIND error and does    v
        not contain OWNER clause                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.10 Different number of rows although query is run against    v
         the same data                                             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=swg27049398
    

Problem conclusion

Temporary fix

Comments

  • --
    

APAR Information

  • APAR number

    PI75504

  • 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

    2017-01-27

  • Closed date

    2017-02-23

  • Last modified date

    2017-03-02

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

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

    UI44937

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 UI44937

       UP17/03/01 P F702

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

Modified date: 02 March 2017


Translate this page: