IBM Support

PI56956: IBM DB2 ANALYTICS ACCELERATOR FOR Z/OS VERSION 4 GA UPDATE #6 - INCREMENTAL UPDATE - ACCESS SERVER UPDATE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • MESSAGE AQT20021I FOR TABLE LOAD
    IDAAV4R1/K
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of                                 *
    *                 IBM DB2 Analytics Accelerator for z/OS       *
    *                 Version 4.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: This PTF is needed for the enablement   *
    *                      of IBM DB2 Analytics Accelerator for    *
    *                      z/OS Version 4.1 Refresh 6.             *
    *                      IDAAV4R1/K                              *
    ****************************************************************
    * RECOMMENDATION: Refer to the closing information of          *
    *                 APAR PI48745 for installation instructions.  *
    *                                                              *
    *                 This PTF contains the following part for     *
    *                 the enablement of IBM DB2 Analytics          *
    *                 Accelerator for z/OS Version 4.1 Refresh 6:  *
    *                                                              *
    *                 Access Server component update               *
    *                    Core Version 11.3.3.4289                  *
    *                    Build date 20160208-1649                  *
    *                    Simple Version 4020100042230              *
    ****************************************************************
    This PTF provides the Access Server update part component
    enabling the IBM DB2 Analytics Accelerator for z/OS Version 4.1
    Refresh 6.
    
    This PTF contains a fix for the following issue:
    
    PROBLEM DESCRIPTION:
    You receive an AQT20021I error message in the following
    situation:
    
    1. A table exists on more than one accelerator. The original
       DB2 table contains columns with data types that are not
       supported by IBM DB2 Analytics Accelerator.
    2. Incremental updates for this table have been configured
       successfully on at least one accelerator.
    3. You have enabled incremental updates for the same table
       on an additional accelerator. The initial load of this
       table is outstanding.
    
    You receive the error before the initial load of the table.
    
    The problem occurs only if the original DB2 table has columns
    with unsupported data types.
    
    PROBLEM SUMMARY:
    Error AQT20021I is returned before the initial load of a
    table that has been enabled for incremental updates if the
    table exists on multiple accelerators, is already incrementally
    updated on at least one accelerator, and is related to a DB2
    base table with unsupported column data types.
    

Problem conclusion

  • The problem has been fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI56956

  • Reported component name

    SMRT ANL OPT DB

  • Reported component ID

    5697AQT00

  • Reported release

    410

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-10

  • Closed date

    2016-02-16

  • Last modified date

    2016-03-02

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

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

    UI35374

Modules/Macros

  •    AQTPKAS0 AQTPKCFA
    

Fix information

  • Fixed component name

    SMRT ANL OPT DB

  • Fixed component ID

    5697AQT00

Applicable component levels

  • R410 PSY UI35374

       UP16/02/18 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.



Document information

More support for: z/OS family

Software version: 410

Operating system(s): z/OS

Reference #: PI56956

Modified date: 02 March 2016


Translate this page: