A fix is available
APAR status
Closed as new function.
Error description
THIRD SMP/E INSTALLABLE FOR IDAA VERSION 3.1.0 IDAAV3R1/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of the * * IBM DB2 Analytics Accelerator for z/OS * * Version 3.1 * **************************************************************** * PROBLEM DESCRIPTION: This PTF contains part 1 of 3 * * of IBM DB2 Analytics Accelerator for * * z/OS Version 3 Refresh 3. * * * * This PTF contains: * * Server version: 3.1.3 * * (build: 20130723-1727) * * Stored procedure build: * * 20130709-0632 * * * * IDAAV3R1/K * **************************************************************** * RECOMMENDATION: Before installing this PTF, * * make sure that all prerequisites are * * installed on your target system. * * For information, see: * * http://www.ibm.com/support/ * * docview.wss?uid=swg27035960 * * * * If you have not yet configured * * IBM DB2 Analytics Accelerator for z/OS * * Version 3.1, read the * * * * "Getting Started" manual * * http://publibfp.dhe.ibm.com/ * * epubs/pdf/h1269860.pdf * * and the * * * * Installation Guide * * http://publibfp.dhe.ibm.com/ * * epubs/pdf/h1269830.pdf * * * * ATTENTION: * * Prerequisite for activating this PTF: * * 1. The base package for FMID HAQT310 must * * have been applied and configured, * * including pairing to an IDAA * * server system. * * 2. FMID HCH650 must be applied * * (not necessarily configured). * * 3. The IBM DB2 Analytics Accelerator Studio * * version 3.1 was installed. * * 4. Netezza: on the accelerator was installed * * - NZ 6.0.8 P-9 for N1001 * * - NZ 7.0.2 P-3 for N2001 * * 5. DB2 PTFs must be installed: * * See the prerequisites site: * * http://www.ibm.com/support/ * * docview.wss?uid=swg27035960 * * * * Activating the PTF is a three-step process: * * * * 1. Activate Incremental Update parts * * from prerequisite PTFs in the following * * order (unless these or later versions * * are already installed): * * 1.Access Server * * 2.Replication Engine * * For instructions, see the * * Installation Guide, Chapter 10: * * "Installing Updates" * * * * 2. Update 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 10: * * "Installing Updates" * * * * 3. Activate the stored procedures included * * in this PTF by following * * the steps in the * * Installation Guide, Chapter 5: * * "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". * * * **************************************************************** This PTF contains fixes for the issues described below. Further information as well as IBM DB2 Analytics Accelerator Studio related problem descriptions can be found in the following support document: http://www-01.ibm.com/support/docview.wss?uid=swg27039174 ###################################### # Fixes # ###################################### **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: The IDAA supplied sample AQTSCALL does * * not support calling the SYSPROC.ACCEL_ALTER_TABLES stored * * procedure. * **************************************************************** Problem conclusion: SYSPROC.ACCEL_ALTER_TABLES support was added to the AQTSCALL sample program. The new function can be invoked by calling the AQTSCALL sample program with the following options: RUN PROGRAM(AQTSCALL) PLAN(AQTSCALL) - LIB('!SAMPLOAD!') PARMS('ALTERTABLES') **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: Loading or archiving a table via * * SYSPROC.ACCEL_LOAD_TABLES or SYSPROC.ACCEL_ARCHIVE_TABLES * * never completes under 4 seconds even if the table is empty. * **************************************************************** The processing overhead can have a significant affect on the overall elapsed time if many small tables are loaded. Problem conclusion: Processing overhead per table was reduced to a few milliseconds. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: * * When using a UNIQUE WHERE NOT NULL index on a table that is * * incrementally updated not all rows may be replicated * * to the target table. * **************************************************************** Problem conclusion: Code was changed to handle UNIQUE WHERE NOT NULL indexes correctly. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users calling an IDAA stored procedure * * like SYSPROC.ACCEL_ADD_TABLES from a native * * (SQL-bodied) stored procedure. * **************************************************************** * PROBLEM DESCRIPTION: If an IDAA V3.1 stored procedure is * * called from a native SQL-bodied stored procedure, the called * * IDAA procedure abends and sqlcode -430 is returned. * * The CEEDUMP of the WLM stored procedure address space shows * * following entry in its stack trace: * * ibm_aqt_sp::Connection::commit(). * **************************************************************** Problem conclusion: The problem is fixed so that IDAA stored procedures can be called from a native SQL-bodied procedure. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users calling the IDAA stored procedure * * SYSPROC.ACCEL_LOAD_TABLES for tables with * * field procs. * **************************************************************** * PROBLEM DESCRIPTION: When loading a table with field proc * * the IDAA V3.1 ACCEL_LOAD_TABLES returns message AQT10205I. * **************************************************************** Problem conclusion: The problem is fixed. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: * * IDAA trace collection does not collect files necessary to * * diagnose out of memory problems (heap dumps). * **************************************************************** Problem conclusion: Code was changed to include these files and to remove them on the clear trace action. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: * * Problems in Netezza, CDC or IDAA sometimes require manual * * process restarts as a workaround to get the system running * * again while the problem is investigated. This fix introduces * * new options in the configuration console to restart * * processes. * **************************************************************** Problem conclusion: New options in the configuration console allow to restart IDAA processes. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: * * Database, schema, table or columns names with trailing * * blanks might cause one of the following error messages when * * used with incremental update: * * 1. AQT20009I - Operation 'enableReplication' failed: * * 'Invalid path: DBNAME .ABCDEF.' * * 2. AQT20021I - The load table operation was successful, * * however, a subsequent replication operation failed. * **************************************************************** Problem conclusion: Problem is fixed. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: SYSPROC.ACCEL_LOAD_TABLES returns the * * following error: AQT10050I - An internal error occurred on * * the '<accelerator-name>' accelerator: An assertion * * 'numBytesRead == availableReadSpace' failed. * **************************************************************** Problem might occur if the table to be loaded contains BLOB, CLOB, DBCLOB, or XML columns. Problem conclusion: Problem is fixed. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users using incremental update. * **************************************************************** * PROBLEM DESCRIPTION: IDAA GUI shows an incorrect version of * * the incremental update component. * **************************************************************** After an upgrade of incremental update components it might take up to 30 minutes until the correct version is shown in the IDAA GUI. Problem conclusion: Problem is fixed. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users sing incremental update. * **************************************************************** * PROBLEM DESCRIPTION: An incremental update console operation * * failed with * * 'An assertion 'messageNode->hasChildNodes() == true' failed.'* **************************************************************** The original error message was masked by the "Assertion failed" error message. Problem conclusion: Problem is fixed. Correct message is shown. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: ACCEL_LOAD_TABLES stored procedure * * might take some time when ACCEL_REMOVE_TABLES runs * * in parallel. * **************************************************************** Running ACCEL_LOAD_TABLES and ACCEL_REMOVE_TABLES cocurrently may cause the load to wait for the table removal to complete. This might occur even if the table sets are disjoint. Problem conclusion: If the table set to be loaded is disjoint from the table set being removed the load now proceeds without waiting for the removal to complete. **************************************************************** * USERS AFFECTED: IBM DB2 Analytics Accelerator for z/OS V3.1 * * users with N200x models with sub-capacity * * licensing. * **************************************************************** * PROBLEM DESCRIPTION: Sub-capacity licensing is not supported.* **************************************************************** Problem conclusion: Sub-capacity licensing support was added to the configuration console. It allows to set the maximum resource percentage to the resource sharing group for each paired DB2 subsystem. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: Queries using CURRENT TIMESTAMP, * * CURRENT DATE, or CURRENT TIME might return different results * * when running in DB2 compared to running in IDAA. * **************************************************************** System time was not always synchronized between DB2 and IDAA when the accelerator is used by several DB2 sub-systems. Problem conclusion: Problem is fixed. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: Impact messages returned by software * * update operations might be wrong. * **************************************************************** Software Update might indicate that some tables will be dropped when they are not. Problem Conclusion: All software update scenarios now display the correct impact messages. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: DSNX881l message does not include * * the Wall IP and the name of the accelerator. * **************************************************************** Problem conclusion: Problem is fixed. **************************************************************** * USERS AFFECTED: All IBM DB2 Analytics Accelerator for z/OS * * V3.1 users. * **************************************************************** * PROBLEM DESCRIPTION: The activation of software updates * * fails without reporting error details. * **************************************************************** Problem conclusion: Problem is fixed.
Problem conclusion
Temporary fix
Comments
--
APAR Information
APAR number
PM84725
Reported component name
SMRT ANL OPT DB
Reported component ID
5697AQT00
Reported release
310
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-03-13
Closed date
2013-07-31
Last modified date
2013-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK96194
Modules/Macros
AQTENV AQTNOTE AQTOSR AQTSCALL AQTSCI01 AQTSCI02 AQTSJI00 AQTSJI01 AQTSJI02 AQTSJI03 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 AQT02RTB AQT02STA AQT02TCO AQT02UCR AQT02USW AQT03ACC AQT03ACT AQT03AP1 AQT03AP2 AQT03CAT AQT03CFG AQT03CON AQT03C10 AQT03DYN AQT03MFS AQT03QIT AQT03TRC AQT03UNL AQT03ZPR
Fix information
Fixed component name
SMRT ANL OPT DB
Fixed component ID
5697AQT00
Applicable component levels
R310 PSY UK96194
UP13/08/09 P F308
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":"310","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
03 September 2013