A fix is available
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.
[{"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":"410","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
02 March 2016