IBM Support

PI29638: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 4 NPS DRIVER REFRESH PART 1

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Netezza NPS Refresh 7.2.0.2 FOR IBM DB2 ANALYTICS ACCELERATOR
    FOR Z/OS VERSION 4
    IDAAV4R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the                             *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 4.1                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: This program temporary fix (PTF)        *
    *                      Netezza Performance Server (NPS) update *
    *                      Part 1 of 5 *                           *
    *                      Core Version NPS 7.2.0.2 (build 41493)  *
    *                      Build date 20141117-1808                *
    *                                                              *
    *                      IDAAV4R1/K                              *
    ****************************************************************
    * RECOMMENDATION: Before you install this PTF, make sure that  *
    *                 all prerequisites have been installed on     *
    *                 the target systems.                          *
    *                                                              *
    *                 For more information, see:                   *
    *                 http://www.ibm.com/support/                  *
    *                    docview.wss?uid=swg27039487               *
    *                                                              *
    *                 You might have to update the Netezza         *
    *                 firmware (FDT) or the Netezza host platform  *
    *                 (HPF) before updating the NPS. To determine  *
    *                 whether you have to update the FDT or HPS,   *
    *                 see:                                         *
    *                 http://www-01.ibm.com/support/               *
    *                    docview.wss?uid=swg21626217               *
    *                                                              *
    *                 For information on how to get support        *
    *                 for FDT and HPF updates, and how to transfer *
    *                 and install these components, see:           *
    *                                                              *
    *                 "Updating other Netezza software"            *
    *                 (https://www.ibm.com/support/                *
    *                 knowledgecenter/SS4LQ8_4.1.0/                *
    *                 com.ibm.datatools.aqt.doc/                   *
    *                 installmanual/topics/                        *
    *                 tp_idaa_inst_update_nz.html)                 *
    *                                                              *
    *                 in the IBM Knowledge Center or the           *
    *                 Installation Guide (SH12-7038-03)            *
    *                                                              *
    *                 Activating the NPS update:                   *
    *                 Transfer and activate the NPS (provided with *
    *                 this set of PTFs) if your current NPS        *
    *                 version is lower than NPS 7.2.0.2            *
    *                 (build 41493,build date 20141117-1808).      *
    *                 For information on how to do this, see:      *
    *                                                              *
    *                 - "Transferring update packages for the      *
    *                   accelerator"                               *
    *                   (https://www.ibm.com/support/              *
    *                   knowledgecenter/SS4LQ8_4.1.0/              *
    *                   com.ibm.datatools.aqt.doc/gui/tasks/       *
    *                   t_idaa_deploy_software.html)               *
    *                                                              *
    *                 - "Switching between available versions of   *
    *                   accelerator software components"           *
    *                   (https://www.ibm.com/support/              *
    *                   knowledgecenter/SS4LQ8_4.1.0/              *
    *                   com.ibm.datatools.aqt.doc/gui/             *
    *                   tasks/t_idaa_change_version.html)          *
    *                                                              *
    *                   in the IBM Knowledge Center or the         *
    *                   Installation Guide (SH12-7038-03)          *
    ****************************************************************
    This update 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=swg27043885
    
    ================================================================
    Solved Problems                                                v
    ================================================================
    1. SQL error -901 Password authentication failed for user      v
       'DWA_USER_*subsystem*                                       v
    ================================================================
    2. Different query results from DB2 and the accelerator for    v
       expressions that cast numeric values as characters when     v
       multiple encoding is enabled (AQT_ENABLE_MULTIPLE_ENCODING  v
       environment variable set)                                   v
    ================================================================
    3. Query fails with SQLSTATE: HY000 SQLCODE: 46 'ERROR:        v
       Invalid UTF-8 sequence - bad continuation byte (0xCD) at    v
       byte offset 1'.                                             v
    ================================================================
    4. Queries that contain a "first fetch n rows" expression      v
       run slower when compared with NPS 7.1.0.2                   v
    ================================================================
    5. Disabling call home fails for systems with serial number    v
       starting with 78.                                           v
    ================================================================
    
    This PTF contains the first part of the NPS update
    for the enablement of IBM DB2 Analytics Accelerator for z/OS
    Version 4.1 Refresh 4.
    

Problem conclusion

Temporary fix

Comments

  • --
    

APAR Information

  • APAR number

    PI29638

  • Reported component name

    SMRT ANL OPT DB

  • Reported component ID

    5697AQT00

  • Reported release

    410

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-14

  • Closed date

    2014-11-25

  • Last modified date

    2014-12-01

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

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

    UI23398

Modules/Macros

  •    AQTPKCFB AQTPKNP1
    

Fix information

  • Fixed component name

    SMRT ANL OPT DB

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R410 PSY UI23398

       UP14/11/29 P F411

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: 410

Operating system(s): z/OS

Reference #: PI29638

Modified date: 01 December 2014


Translate this page: