IBM Support

PI60229: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 5 GA UPDATE #2

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • SECOND 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 2.           *
    *                                                              *
    *                      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.2                        *
    *                   (build: 20160422-0100)                     *
    *                 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  Alerts to incremental update outages                      v
    ================================================================
    ****************************************************************
    ================================================================
    1.2 Support DB2 local dates in the format YYYYMMDD (padded     v
        with two blanks)                                           v
    ================================================================
    ****************************************************************
    ================================================================
    2. Solved Problems                                             v
    ================================================================
    2.1 Error message CHC0535E in CDC Jeslog                       v
    ================================================================
    ****************************************************************
    ================================================================
    2.2 Stored Procedures fail with error AQT10003I                v
    ================================================================
    ****************************************************************
    ================================================================
    2.3 DB2 right() function returns wrong results on CHAR columns v
    ================================================================
    ****************************************************************
    ================================================================
    2.4 Stored procedure INZA.PMML_MODEL fails with error          v
        AQT10200E when run on a model in a Netezza EBCDIC database v
    ================================================================
    ****************************************************************
    ================================================================
    2.5 Accelerator goes offline unexpectedly                      v
    ================================================================
    ****************************************************************
    ================================================================
    2.6 Error message AQT20021I when loading a table               v
    ================================================================
    ****************************************************************
    ================================================================
    2.7 Call-home requests with attachments greater than 38MB will v
        not be opened                                              v
    ================================================================
    ****************************************************************
    ================================================================
    2.8 Package AQTDBC10 is not bound by the product installer for v
        DB2 11 in Conversion Mode                                  v
    ================================================================
    ****************************************************************
    ================================================================
    2.9 Install program AQTTRIN in job AQTTIJSP terminates with    v
        condition code 2000                                        v
    ================================================================
    ****************************************************************
    ================================================================
    2.10 Values of AQTENV environment variables missing if SCCSID  v
         1026 is used                                              v
    ================================================================
    ****************************************************************
    ================================================================
    2.11 An accelerator-only table disappears from accelerator     v
    ================================================================
    ****************************************************************
    ================================================================
    2.12 DEFAULT trace profile does not include installation       v
         problems                                                  v
    ================================================================
    ****************************************************************
    ================================================================
    2.13 Query results may differ between DB2 and Accelerator V5.1
    
    With V5.1.0 and V5.1.1 a new way of data organization was
    introduced which has the potential to improve data insert
    performance of small chunks of data, which is typical for
    incremental update.
    In rare situations with huge table sizes and a high number of
    columns it is possible that queries will not return all results.
    By switching back to the former data organization this problem
    can be avoided.
    Automatic switch to former data organization will be done during
    the server restart after the completion of the installation
    process.
    If the switch back to the former data organization does not
    complete successfully, the following message is written to the
    z/OS system log (SYSLOG) of the LPAR in which the subsystem or
    group is located:
    DSNX881I Not all zone map records are consistent with the
    expected layout.
    For further information regarding the structure of DSNX881I
    messages see
    http://www-01.ibm.com/support/docview.wss?uid=swg27037905.
    Contact IBM Support in case this message is displayed.
    As a preventive maintenance action and to avoid potential loss
    of results, we strongly recommend to install this fixpack.
    This is a temporary fix. The problem will be finally fixed with
    an upcoming release of the Netezza Platform Software (NPS),
    which will be certified for the IBM DB2 Analytics Accelerator
    for z/OS.
    Please check the Prerequisites and Maintenance for IBM DB2
    Analytics Accelerator for z/OS, V5.1 website for further
    updates.
    ================================================================
    
    ================================================================
    ****************************************************************
    ================================================================
    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=swg27047893
    

Problem conclusion

Temporary fix

Comments

  • --
    

APAR Information

  • APAR number

    PI60229

  • Reported component name

    SMRT ANL OPT DB

  • Reported component ID

    5697AQT00

  • Reported release

    510

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-05

  • Closed date

    2016-05-12

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

    UI37796

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

    SMRT ANL OPT DB

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R510 PSY UI37796

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

Software version: 510

Operating system(s): z/OS

Reference #: PI60229

Modified date: 02 June 2016


Translate this page: