A fix is available
APAR status
Closed as new function.
Error description
Sixth SMP/E installable for IDAA version 5.1.0 IDAAV5R1/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of the * * IBM DB2 Analytics Accelerator for z/OS * * Version 5.1 * **************************************************************** * PROBLEM DESCRIPTION: This PTF contains stored procedure * * and accelerator server updates that are * * part of IBM DB2 Analytics Accelerator * * for z/OS version 5 refresh 6. * * * * IDAAV5R1/K * **************************************************************** * RECOMMENDATION: Before installing this PTF, * * make sure that all prerequisites are * * installed on your target system. * * This includes the appropriate version * * of the IBM DB2 Analytics Accelerator * * Studio. * * For information, see: * * http://www.ibm.com/support/ * * docview.wss?uid=swg27046305 * * * * This PTF contains: * * Server version: 5.1.6 * * (build: 20180109-0000) * * Stored procedure build: 5.1.6 * * (build: 20171109-1136) * * * * If you have not yet configured * * IBM DB2 Analytics Accelerator for z/OS * * Version 5.1, read the following manuals * * that are all available on * * http://www.ibm.com/support/ * * docview.wss?uid=swg27047135 * * - 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 * * HAQT510 must have been applied. * * 2. FMID HCHCA21 must have been applied. * * 3. For the prerequisites of the following * * components see * * http://www.ibm.com/support/ * * docview.wss?uid=swg27046305 * * a. IBM DB2 Analytics Accelerator Studio * * b. Netezza Firmware (FDT) * * c. Netezza Host Platform (HPF) * * d. Netezza Platform Software (NPS) * * e. DB2 PTFs * * f. Infosphere Change Data Capture Agent * * PTFs * * * * Activating the PTF is a multi-step process: * * * * 1. Transfer and activate Access Server * * (provided with a separate PTF) * * For instructions, see the * * Installation Guide, Chapter 11: * * "Installing Updates" * * For the correct versions, see * * the prerequisites site: * * http://www-01.ibm.com/support/ * * docview.wss?uid=swg27046305 * * * * 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. The next two steps may be performed in * * an arbitrary order. * * * * - 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". * * * * - Transfer and activate NPS (provided with * * separate PTFs). For the correct version * * see the prerequisites site: * * http://www-01.ibm.com/support/ * * docview.wss?uid=swg27046305 * * * * 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=swg27047135 * * * * 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 fixes for the issues described below. ================================================================ 1. What's new? v ================================================================ 1.1 Add column support for replicated tables v ================================================================ 1.2 Hybrid Transactional Analytical Processing (HTAP): v Technical Preview v ================================================================ 1.3 Secure FTP support for Call home v ================================================================ **************************************************************** ================================================================ 2. Solved problems v ================================================================ 2.1 Archiving a table on a second accelerator fails with v message AQT10205S v ================================================================ 2.2 Archiving and restoring of a table on more than one v accelerator may fail with message AQT10402E. v ================================================================ 2.3 SYSPROC.ACCEL_ADD_TABLES fails with error message v AQT10205S for tables created with an old version of DB2/z v ================================================================ 2.4 Stored procedure dumps are not taken v ================================================================ 2.5 Description of submenu item 5 of main menu item 3 on IBM v DB2 Analytics Accelerator console is misleading v ================================================================ 2.6 A failed attempt to enable incremental updates stops v incremental updates for all paired database systems v ================================================================ 2.7 SYSPROC.ACCEL_ARCHIVE_TABLES does not return when table v space name has trailing blanks v ================================================================ 2.8 Enabling the Continuous Replication feature may result in v an error message complaining about the port number v ================================================================ 2.9 Queries may erroneously result in SQLCODE -904 v ================================================================ 2.10 Call home function allows attachments with a size that is v rejected by the mail server v ================================================================ **************************************************************** ================================================================ 3. Known issues v ================================================================ Please see here: A detailed description for the new features, solved problems and the known issues can be found in the following support document: http://www.ibm.com/support/docview.wss?uid=swg27050677
Problem conclusion
Temporary fix
Comments
--
APAR Information
APAR number
PI87839
Reported component name
IDAA FOR ZOS
Reported component ID
5697AQT00
Reported release
510
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2017-09-26
Closed date
2018-01-31
Last modified date
2018-03-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI53528
Modules/Macros
AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10 AQTDBDBI AQTDBDYN AQTDBQIT AQTDBTRC AQTDBTRN AQTDBUNL AQTDBZPR AQTDEFTR AQTENV AQTHFSCL AQTNILIC AQTNOTE AQTPKAP1 AQTPKAP2 AQTPKCFG AQTSCALL AQTSCI01 AQTSCI02 AQTSJI00 AQTSJI01 AQTSJI02 AQTSJI03 AQTSJI04 AQTSJI05 AQTSSCHK AQTSSCPY AQTSXADD AQTSXALT AQTSXCN0 AQTSXCN1 AQTSXCN2 AQTSXCN3 AQTSXCN4 AQTSXIM0 AQTSXQHI AQTSXSD1 AQTSXTCO AQTSXTSL AQTSXTSU AQTSXTS0 AQTTIJSP AQTTRIN AQT02AAC AQT02ALT AQT02ART AQT02ATB AQT02CAC AQT02CDC AQT02CRT AQT02ENQ AQT02FGV AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI AQT02GTR AQT02ISP AQT02LTB AQT02MIG AQT02PSD AQT02RAC AQT02RAT AQT02RRT AQT02RTB AQT02RTR AQT02STA AQT02SYN AQT02TCO AQT02UCR AQT02USW
Fix information
Fixed component name
IDAA FOR ZOS
Fixed component ID
5697AQT00
Applicable component levels
R510 PSY UI53528
UP18/02/03 P F802
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":"510","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
08 March 2018