IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Time value 23:59:59.999999 is returned as 24:00:00
    Incorrect load recommendation for partitioned-by-growth tables
    
    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 4.           *
    *                                                              *
    *                      IDAAV4R1/K                              *
    ****************************************************************
    * RECOMMENDATION: Before installing this PTF,                  *
    *                 make sure that all prerequisites are         *
    *                 installed on your target system.             *
    *                 For information, see:                        *
    *                 http://www.ibm.com/support/                  *
    *                   docview.wss?uid=swg27039487                *
    *                                                              *
    *                 This PTF contains:                           *
    *                 Server version: 4.1.4                        *
    *                   (build: 20150807-1405)                     *
    *                 Stored procedure build: 4.1.4                *
    *                   (build: 20141006-0802)                     *
    *                                                              *
    *                 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.3 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 prerequisite 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 version            *
    *                       10.2.1.2221 (build date 20140723-1400) *
    *                    2.Replication Engine base                 *
    *                       version 10.2.1 (Build CCTRJYPP_20_4)   *
    *                       (build date  20140414-1822)            *
    *                    3.Replication Engine update               *
    *                       version 10.2.1 IF9                     *
    *                       (Build CCTRJYPP_20_52)                 *
    *                       (build date 20140723-1400)             *
    *                                                              *
    *                 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  *
    *                    corresponding PTFs) if the NPS version    *
    *                    is lower than NPS 7.2.0.0-P1              *
    *                    (build 41016) (build date 20141016-2038). *
    *                    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 a fix for the issue described below.
    
    A description for the fix can also be found in the
    following support document:
    http://www.ibm.com/support/docview.wss?uid=swg27043885
    
    
    ================================================================
    2.1 Time value 23:59:59.999999 is returned as 24:00:00         v
    ================================================================
    ****************************************************************
    * USERS AFFECTED: All users of IBM DB2 Analytics Accelerator   *
    *                 for z/OS Version 4.1                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: Queries that access timestamp columns   *
    * return 24:00:00.000000 as the time portion of a timestamp in *
    * the results when the actual value is 23:59:59.999999.        *
    ****************************************************************
    Problem summary: IBM DB2 Analytics Accelerator for z/OS Version
    4.1 supports 24:00:00.00000 values for the time portion of a
    timestamp. In previous versions, 24:00:00.00000 values were
    converted to 23:59:59.999999 using an environment variable. In
    version 4.1, 23:59:59.999999 values are automatically converted
    to 24:00:00.00000. In certain scenarios the behavior in version
    3.1., that is, a conversion of 24:00:00.00000 values to
    23:59:59.999999 during a table load, is preferred over the
    automatic conversion in version 4.1.
    
    Problem conclusion: The problem has been fixed. An option has
    been added to the IBM DB2 Analytics Accelerator Console that
    activates the load-time conversion from 24:00:00.000000 to
    23:59:59.999999.
    
    ================================================================
    2.2 Incorrect load recommendation for partitioned-by-growth    v
        tables                                                     v
    ================================================================
    ****************************************************************
    * USERS AFFECTED: All users of IBM DB2 Analytics Accelerator   *
    *                 for z/OS Version 4.1                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: The SYSPROC.ACCEL_GET_TABLES_DETAILS    *
    * stored procedure returns a recommendation to fully reload a  *
    * partitioned-by-growth table even if the table has just been  *
    * reloaded.                                                    *
    ****************************************************************
    Problem summary: IBM DB2 Analytics Accelerator does not always
    properly detect those table partitions in a
    partition-by-growth table space that have truly changed in DB2
    and therefore require a reload.
    
    Problem conclusion: The problem has been fixed.
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI47113

  • Reported component name

    SMRT ANL OPT DB

  • Reported component ID

    5697AQT00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-08-19

  • Closed date

    2015-08-26

  • Last modified date

    2015-09-02

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

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

    UI30528

Modules/Macros

  •    AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10
    AQTDBDYN AQTDBQIT AQTDBTRC AQTDBUNL AQTDBZPR AQTDEFTR AQTENV
    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 UI30528

       UP15/09/01 P F508

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

Modified date: 02 September 2015


Translate this page: