IBM Support

PM94290: IDAA V2 UPDATE 7

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • This PTF contains
    IBM DB2 Analytics Accelerator for
    z/OS Version 2 Refresh 7.
    IDAAV2R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the                             *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 2.1.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: This PTF contains IBM DB2 Analytics     *
    *                      Accelerator for z/OS                    *
    *                      Version 2 Refresh 7.                    *
    *                                                              *
    *                      Server 2.1.7                            *
    *                        (build 20130906-1502)                 *
    *                      Stored procedure 2.1.7                  *
    *                        (build 20130823-1344)                 *
    *                                                              *
    *                      IDAAV2R1/K                              *
    ****************************************************************
    * RECOMMENDATION: Before installing this PTF,                  *
    *                 make sure that all                           *
    *                 prerequisites are installed                  *
    *                 on your target system.                       *
    *                                                              *
    *                 For information, see:                        *
    *                 http://www-01.ibm.com/support/               *
    *                      docview.wss?uid=swg27022331             *
    *                                                              *
    *                                                              *
    *                 ATTENTION:                                   *
    *                 Prerequisite for activating this PTF:        *
    *                                                              *
    *                 1. The IBM DB2 Analytics Accelerator         *
    *                    studio version 3.1.2 was installed        *
    *                 2. Recommended Netezza: 6.0.8-0.F-1.P-9      *
    *                    was installed on the accelerator          *
    *                 3. DB2 PTFs must be installed:               *
    *                    See the prerequisites site:               *
    *                    http://www-01.ibm.com/support/            *
    *                      docview.wss?uid=swg27022331             *
    *                    or search for PTFs with the keyword       *
    *                    IDAAV2R1/K                                *
    *                                                              *
    ****************************************************************
    ================================================================
    #            IBM DB2  Analytics Accelerator for z/OS           #
    #          Closing Information for Version 2.1.0 PTF-7         #
    ================================================================
    
    
    ================================================================
    1.1 Incorrect system time                                      v
    ================================================================
    ****************************************************************
    * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS   *
    *                 V2.1 users.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The DB2 system time was not always      *
    * synchronized with the accelerator system time, so that       *
    * results differed for queries including the CURRENT TIMESTAMP,*
    * CURRENT DATE, or CURRENT TIME special registers, depending   *
    * on where the query was executed (DB2 for z/OS or IBM DB2     *
    * Anayltics Accelerator for z/OS). An previous update of IBM   *
    * DB2 Analytics Accelerator for z/OS did not fix this problem  *
    * in all situations.                                           *
    ****************************************************************
    Problem conclusion: The problem has been fixed.
    
    
    ================================================================
    1.2 AQTSCALL SYSPROC.SYSACCEL_ALTER_TABLES support.            v
    ================================================================
    ****************************************************************
    * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS   *
    *                 V2.1 users.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The SYSPROC.ACCEL_ALTER_TABLES stored   *
    * procedure could not be called from the AQTSCALL sample       *
    * program that was provided with IBM DB2 Analytics Accelerator *
    * for z/OS.                                                    *
    ****************************************************************
    Problem conclusion: Support for the SYSPROC.ACCEL_ALTER_TABLES
    stored procedure was added to the AQTSCALL sample program.
    The new function can be invoked by calling the AQTSCALL sample
    program with the following options:
        RUN PROGRAM(AQTSCALL) PLAN(AQTSCALL) -
            LIB('!SAMPLOAD!') PARMS('ALTERTABLES')
    
    ================================================================
    1.3 SYSPROC.ACCEL_LOAD_TABLES performance improvement.         v
    ================================================================
    ****************************************************************
    * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS   *
    *                 V2.1 users.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: The SYSPROC.ACCEL_LOAD_TABLES or        *
    * SYSPROC.ACCEL_ARCHIVE_TABLES, used for loading tables or     *
    * moving table partitions, never finished processing in less   *
    * than four seconds, even if empty tables were processed.      *
    ****************************************************************
    The processing overhead might have a significantly negative
    effect on the total processing time if many small tables are
    loaded.
    
    Problem conclusion: The processing overhead per table was
    reduced to a few milliseconds.
    
    
    ================================================================
    1.4 Event notifications missing for system diagnostics & early v
        problem detection                                          v
    ================================================================
    ****************************************************************
    * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS   *
    *                 V2.1 users                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Users were not notified of the          *
    * Netezza events (nzEvents) hwPathDown, hardwareNeedsAttention *
    * or topologyImbalance.                                        *
    ****************************************************************
    The nzEvents notifications monitor health, status and activity
    of the Netezza system.
    When a specific event occurs, information about this event is
    sent to DB2 so that administrators can take appropriate action.
    The following symptoms could be observed because notifications
    of certain events were not sent:
    
    - HwPathDown: Performance degradation of the system and slow
    query processing due to connectivity failures between an
    S-Blade/SPU and its disks.
    
    - HardwareNeedsAttention: Performance or availability problems
    because the hardware maintenance was neglected as a result of
    the missing notifications. That is, disks with invalid firmware
    were not replaced, the storage configuration was not updated,
    components remained unavailable or unreachable, disks exceeding
    the grown defects early warning threshold were not looked after,
    ethernet switch ports remained unavailable, and so on.
    
    - TopologyImbalance: Unequal workload distribution among the
    disks. A disk topology imbalance is detected after a disk
    regeneration or when the system goes back to the online state
    after a rebalancing.
    
    Problem conclusion: Notifications of these events are now sent.
    

Problem conclusion

Temporary fix

Comments

  • --
    

APAR Information

  • APAR number

    PM94290

  • Reported component name

    SMRT ANL OPT DB

  • Reported component ID

    5697AQT00

  • Reported release

    210

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-08-01

  • Closed date

    2013-09-24

  • Last modified date

    2013-10-03

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

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

    UK97786

Modules/Macros

  • AQTENV   AQTNOTE  AQTSCALL AQTSCI01 AQTSCI02 AQTSJI00 AQTSJI01
    AQTSJI02 AQTSJI03 AQTSSCHK AQTSSCPY AQTSXADD AQTSXALT AQTSXCN0
    AQTSXCN1 AQTSXCN2 AQTSXCN3 AQTSXCN4 AQTSXIM0 AQTSXQHI AQTSXSD1
    AQTSXTCO AQTSXTSL AQTSXTSU AQTSXTS0 AQTTIJSP AQT02AAC AQT02ACC
    AQT02ACT AQT02ALT AQT02AP1 AQT02AP2 AQT02ATB AQT02CAC AQT02CAT
    AQT02CDC AQT02CFG AQT02CON AQT02C10 AQT02DYN AQT02ENQ AQT02FGV
    AQT02FRF AQT02GQD AQT02GQR AQT02GTI AQT02LTB AQT02MFS AQT02PSD
    AQT02QIT AQT02RAC AQT02RTB AQT02STA AQT02TCO AQT02TRC AQT02UCR
    AQT02UNL AQT02USW AQT02ZPR
    

Fix information

  • Fixed component name

    SMRT ANL OPT DB

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R210 PSY UK97786

       UP13/09/28 P F309

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":"210","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 October 2013