A fix is available
APAR status
Closed as new function.
Error description
FIRST SMP/E INSTALLABLE FOR IDAA VERSION 4.1. IDAAV4R1/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of the * * IBM DB2 Analytics Accelerator for z/OS * * migrating to version 4.1 from a previous * * release or users of version 4.1 exploiting * * the incremental update feature. * **************************************************************** * PROBLEM DESCRIPTION: In some cases after migration from * * a previous release of the IBM DB2 * * Analytics Accelerator for z/OS to the * * version 4.1 the accelerator does not * * start. This PTF replaces version 4.1 * * PTF1 UI12770 and must be applied BEFORE * * installing the IBM DB2 Analytics * * Accelerator for z/OS Version 4 on an * * accelerator. * * * * This PTF contains: * * Server version: 4.1.0 * * (build: 20140116-1530) * * Stored procedure build: * * 20131111-1826 * * * * IDAAV4R1/K * **************************************************************** * RECOMMENDATION: Before installing this PTF, * * make sure that all prerequisites are * * installed on your target system. * * For information, see: * * http://www-01.ibm.com/support/ * * docview.wss?uid=swg27039487 * * * * This PTF contains: * * Server version: 4.1.0 * * (build: 20140116-1530) * * Stored procedure build: * * 20131111-1826 * * * * 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 for FMID HAQT410 must * * have been applied * * 2. FMID HCHCA21 must be applied * * (not necessarily configured) * * 3. The IBM DB2 Analytics Accelerator Studio * * Version 4.1.0 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. Currently installed Netezza Performance * * Server (NPS) is version 6.0.8.P2 or * * higher. * * 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: * * * * (In case of running IDAA 4.1 installation * * it is only necessary to transfer and apply * * the IDAA server software as in step 2 below) * * * * * * 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.2220 (build date 20131114-1445) * * 2.Replication Engine base * * version 10.2.1 (Build CCTRJYPP_20_4) * * (build date 20131114-1445) * * * * 2. Transfer and activate the software on * * the IDAA system with the update included * * in this PTF. * * 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 * * prerequisite PTFs) if the NPS version * * is lower than 7.0.2.P9 * * (build date 20131114-1527). * * 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 enables IBM DB2 Analytics Accelerator for z/OS version 4.1 and contains fixes for the issues described below. A detailed description for each fix can be found in the following support document: http://www.ibm.com/support/docview.wss?uid=swg27041210 ================================================================ 1.1 Accelerator does not start after migration to version 4.1.0v ================================================================ **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * users migrating to version 4.1.0 * **************************************************************** * PROBLEM DESCRIPTION: The accelerator server does not start * * after migration from a previous release. * **************************************************************** Problem Summary: After migrating in some cases the server does not start and requires manual support from IBM service. Problem conclusion: The problem cause is fixed. Customers who ran into the problem already need to call IBM service. ================================================================ 1.2 Incremental update stops without user intervention. v ================================================================ **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V4.1 users. * **************************************************************** * PROBLEM DESCRIPTION: Incremental update stops unexpectedly. * **************************************************************** Problem Summary: In some cases of low change activity on replicated tables, incremental update stops unexpectedly. If this is not detected early enough, the amount of changes may be too high to catch up when manually starting incremental update again. Problem conclusion: The problem is fixed.
Problem conclusion
Temporary fix
********* * HIPER * *********
Comments
--
APAR Information
APAR number
PI09547
Reported component name
SMRT ANL OPT DB
Reported component ID
5697AQT00
Reported release
410
Status
CLOSED UR1
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2014-01-14
Closed date
2014-01-22
Last modified date
2014-02-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI14404
Modules/Macros
AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10 AQTDBDYN AQTDBQIT AQTDBTRC AQTDBUNL AQTDBZPR 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 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 UI14404
UP14/01/28 P F401
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:
05 February 2014