IBM Support

PI56036: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 5 GA UPDATE #1

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • FIRST 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 1.           *
    *                                                              *
    *                      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.1                        *
    *                   (build: 20151217-2301)                     *
    *                 Stored procedure build: 5.1.1                *
    *                   (build: 20160112-1532)                     *
    *                                                              *
    *                 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.
    
    A detailed description for each fix can be found in the
    following support document:
    http://www.ibm.com/support/docview.wss?uid=swg27047477
    
    
    ================================================================
    1. Solved Problems
    ================================================================
    ================================================================
    1.1 Query history shows truncated statements
    ================================================================
    ================================================================
    1.2 Transfer software update packages from IBM Analytics
        Accelerator Data Studio not possible
    ================================================================
    ================================================================
    1.3 Tables not displayed anymore after changing to an
        unsupported table type
    ================================================================
    ================================================================
    1.4 Accelerator stops working
    ================================================================
    ================================================================
    1.5 Stored procedures that create trace file entries fail with
        error AQT10200E
    ================================================================
    1.6 TIMESTAMP arithmetics results of IBM DB2 Analytics
        Accelerator for z/OS V5.1.0 might differ from results in
        DB2 for z/OS
    ================================================================
    1.7 Unsupported type of HAVING clause not documented in
        "Incompatibilities between DB2 for z/OS and IBM DB2
        Analytics Accelerator for z/OS"
    ================================================================
    1.8 Query does not return anything (query hangs)
    ================================================================
    1.9 Special characters not allowed in accelerator-only tables
    ================================================================
    1.10 Timestamp columns with a precision other than 6 or 12 are
         incorrectly created as precision 6 columns in accelerator-
         only tables. This should not block SELECT, INSERT, UPDATE,
         or DELETE operations on these columns, but DB2 for z/OS
         blocks such operations for no apparent reason.
    ================================================================
    1.11 Timestamp operations do not return fractional seconds
    ================================================================
    1.12 Rare occurrences of SQL errors if the system utilization
         is high
    ================================================================
    1.13 After a reload, query acceleration is disabled for a table
         that is enabled for incremental updates
    ================================================================
    1.14 Load operation aborts with SIGABEND if the system
         utilization is very high
    ================================================================
    ****************************************************************
    ================================================================
    2. Migration considerations
    ================================================================
    If you want to upgrade to the newest version of the incremental
    update function from a version older than 4.1 PTF-5, you
    must update the replication engine two times. The first time,
    apply the base package (RE Base) of V5.1 GA, and then the update
    package of V5.1 GA (RE Update). Wait until RE Base has been
    applied successfully before you continue with RE Update.
    
    Attention: Make sure that a replication status other than
    'Error' is displayed in the header of the Accelerator view in
    IBM DB2 Analytics Accelerator Studio before you apply an update
    of the replication engine. Otherwise, the accelerator might
    stop working and enter a state that requires the help of IBM
    support.
    
    To avoid this issue, use
    IBM DB2 Analytics Accelerator Studio Version 5.1.0.1
    or a higher version for the update because this version checks
    the replication status before an update can be applied.
    
    ================================================================
    ****************************************************************
    ================================================================
    3. Known issues                                                v
    ================================================================
    Please see here:
    
    A detailed description for the solved problems and the known
    issues can be found in the following support document:
    http://www.ibm.com/support/docview.wss?uid=swg27047477
    ================================================================
    

Problem conclusion

Temporary fix

Comments

  • --
    ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI56036  FOR DESCRIPTION
    ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI56036  FOR DESCRIPTION
    ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI56036  FOR DESCRIPTION
    ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI60730  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI56036

  • 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-01-26

  • Closed date

    2016-02-03

  • Last modified date

    2016-04-22

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

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

    UI35012

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 UI35012

       UP16/02/09 P F602

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.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"510","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
22 April 2016