IBM Support

PI48745: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 4 GA UPDATE #6

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • SIXTH SMP/E INSTALLABLE FOR IDAA VERSION 4.1.0
    
    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 PTF contains stored procedure      *
    *                      and accelerator server updates that are *
    *                      part of IBM DB2 Analytics Accelerator   *
    *                      for z/OS version 4 refresh 6.           *
    *                                                              *
    *                      IDAAV4R1/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=swg27039487                *
    *                                                              *
    *                 This PTF contains:                           *
    *                 Server version: 4.1.6                        *
    *                   (build: 20150930-1535)                     *
    *                 Stored procedure build: 4.1.6                *
    *                   (build: 20150729-1544)                     *
    *                                                              *
    *                 If you have not yet configured               *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 4.1, read the following manuals      *
    *                 that are all available on                    *
    *                 http://www.ibm.com/support/                  *
    *                    docview.wss?uid=swg27040146               *
    *                 - 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      *
    *                    HAQT410 must have been applied. Do not    *
    *                    transfer or apply any software from these *
    *                    RELFILES to any accelerator.              *
    *                 2. FMID HCHCA21 must have been applied.      *
    *                 3. The IBM DB2 Analytics Accelerator Studio  *
    *                    version 4.1.0.5 or higher was installed.  *
    *                 4. a. Netezza Firmware (FDT) version:        *
    *                       For Netezza models 100/1000/C1000/     *
    *                       N1001, a minimum of FDT version 2.3.1. *
    *                       For model N2001, and later             *
    *                       a minimum of FDT version 3.0.          *
    *                    b. Netezza Host Platform (HPF) version:   *
    *                       a minimum of HPF version v5.3.1.       *
    *                 5. Netezza Performance Server (NPS) version  *
    *                    higher or equal to 6.0.8.P2               *
    *                 6. DB2 PTFs and Infosphere Change Data       *
    *                    Capture Agent PTFs or ++APARs must be     *
    *                    installed for the APARs listed on         *
    *                    following prerequisites site:             *
    *                    http://www-01.ibm.com/support/            *
    *                      docview.wss?uid=swg27039487             *
    *                                                              *
    *                 Activating the PTF is a multi-step process:  *
    *                                                              *
    *                 1. Transfer and activate Incremental Update  *
    *                    parts (provided with separate PTFs)       *
    *                    in the following order (unless these or   *
    *                    later versions are already installed):    *
    *                    For instructions, see the                 *
    *                    Installation Guide, Chapter 11:           *
    *                      "Installing Updates"                    *
    *                    1. Access Server update                   *
    *                    2. Replication Engine update              *
    *                    For the correct versions, see             *
    *                    the prerequisites site:                   *
    *                    http://www-01.ibm.com/support/            *
    *                      docview.wss?uid=swg27039487             *
    *                                                              *
    *                                                              *
    *                 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. 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".                     *
    *                                                              *
    *                 4. 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=swg27039487             *
    *                                                              *
    *                    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=swg27040146            *
    *                                                              *
    *                    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=swg27046294
    
    ================================================================
    1. What's New                                                  v
    ================================================================
    1.1 Improved throughput of incremental update related          v
        management and monitoring operations                       v
    ================================================================
    ****************************************************************
    ================================================================
    1.2 Regularly consistency checks and enforcement of            v
        incremental update meta data                               v
    ================================================================
    ****************************************************************
    ================================================================
    1.3 Save Trace - nzlogcollector                                v
    ================================================================
    ****************************************************************
    ================================================================
    1.4 TIMESTAMP_ISO query support                                v
    ================================================================
    ****************************************************************
    ================================================================
    1.5 Incremental update - continuous replication                v
    ================================================================
    ****************************************************************
    ================================================================
    2. Solved Problems                                             v
    ================================================================
    2.1 SYSPROC.ACCEL_RESTORE_ARCHIVE_TABLES fails with AQT10301I  v
    ================================================================
    ****************************************************************
    ================================================================
    2.2 Stored procedure SYSPROC.ACCEL_GET_QUERY_EXPLAIN fails     v
        with message AQT10050I                                     v
    ================================================================
    ****************************************************************
    ================================================================
    2.3 Important information missing from log file in Linux       v
        high-availabiliy environments                              v
    ================================================================
    ****************************************************************
    ================================================================
    2.4 SYSPROC.ACCEL_LOAD_TABLES fails with AQT10205I, which      v
        indicates timeout for the start of an internal thread      v
    ================================================================
    ****************************************************************
    ================================================================
    2.5 ACCEL_ADD_ACCELERATOR2 returns warning AQT10074I when      v
        accelerator is newer than stored procedures (and therefore v
        compatible)                                                v
    ================================================================
    ****************************************************************
    ================================================================
    2.6 Stored procedures and user-defined functions (UDFs) abend  v
        with U4036 RC2                                             v
    ================================================================
    ****************************************************************
    ================================================================
    2.7 Query fails with SQLCODE:-904, SQLSTATE:57011              v
    ================================================================
    ****************************************************************
    ================================================================
    2.8 SYSPROC.ACCEL_GET_QUERIES returns error AQT10205I          v
    ================================================================
    ****************************************************************
    ================================================================
    2.9 Incremental updates stop after running the                 v
        SYSPROC.ACCEL_MIGRATE_TABLES stored procedure              v
    ================================================================
    ****************************************************************
    ================================================================
    2.10 SYSPROC.ACCEL_GET_TABLES_DETAILS always recommends a      v
         table reload if the underlying table space changes from   v
         nonpartitioned to partitioned-by-range                    v
    ================================================================
    ****************************************************************
    ================================================================
    2.11 No error message if nzhealthcheck did not run             v
         successfully                                              v
    ================================================================
    ****************************************************************
    ================================================================
    2.12 Incorrect data on accelerator when reloading a table with v
         incorrect parameters                                      v
    ================================================================
    ****************************************************************
    ================================================================
    2.13 Two entries for the same creator in the accelerator       v
    ================================================================
    ****************************************************************
    ================================================================
    2.14 A table with an error marker in the accelerator view can  v
         be selected for loading                                   v
    ================================================================
    ****************************************************************
    ================================================================
    2.15 Incorrect load recommendation for partitioned-by-growth   v
         tables                                                    v
    ================================================================
    ****************************************************************
    ================================================================
    2.16 Tables with altered or added columns are not reported as  v
         ViolatedInDatabaseManagementSystem by                     v
         SYSPROC.ACCEL_GET_TABLES_INFO                             v
    ================================================================
    ****************************************************************
    ================================================================
    2.17 SYSPROC.ACCEL_MIGRATE_TABLES stored procedure fails       v
    ================================================================
    ****************************************************************
    ================================================================
    2.18 Error message when trying to configure the call-home      v
         feature with a RACF user ID with a length of 8 characters v
    ================================================================
    ****************************************************************
    ================================================================
    3. Migration considerations                                    v
    ================================================================
    Accelerator might stop working during apply of the replication v
    engine update package                                          v
    ================================================================
    ****************************************************************
    ================================================================
    4. Known issues                                                v
    ================================================================
    4.1 Potential lost updates in incremental update function with v
    parallel apply enabled but with continuous replication         v
    disabled                                                       v
    ================================================================
    4.2 Problem with selection of software packages for transfer   v
    in IBM DB2 Analytics Accelerator Studio with a locale other    v
    than en_US.                                                    v
    ================================================================
    

Problem conclusion

Temporary fix

Comments

  • --
    

APAR Information

  • APAR number

    PI48745

  • 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

    2015-09-15

  • Closed date

    2015-10-12

  • Last modified date

    2015-11-03

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

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

    UI31924

Modules/Macros

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

Fix information

  • Fixed component name

    SMRT ANL OPT DB

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R410 PSY UI31924

       UP15/10/14 P F510

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

Modified date: 03 November 2015


Translate this page: