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

Obtain the fix for this APAR.

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 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.