A fix is available
APAR status
Closed as new function.
Error description
FIFTH SMP/E INSTALLABLE FOR IDAA VERSION 4.1.0 IDAAV4R1/K
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: All users of the * * IBM DB2 Analytics Accelerator for z/OS * * Version 4.1 * **************************************************************** * PROBLEM DESCRIPTION: This PTF contains stored procedure * * and accelerator server updates that are * * part of IBM DB2 Analytics Accelerator * * for z/OS version 4 refresh 5. * **************************************************************** * 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=swg27039487 * * * * This PTF contains: * * Server version: 4.1.5 * * (build: 20150422-1027) * * Stored procedure build: 4.1.5 * * (build: 20150323-1646) * * * * 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 (RELFILES) for * * FMID HAQT410 must have been applied. * * Do not transfer or apply any software * * from these RELFILES to any accelerator. * * 2. FMID HCHCA21 must have been applied. * * 3. The IBM DB2 Analytics Accelerator Studio * * version 4.1.0.5 or higher 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. Netezza Performance Server (NPS) version * * higher or equal to 6.0.8.P2 * * 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: * * * * 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 * * 11.3.3.4289 (build date 20150422-1027) * * 2.Replication Engine base * * version 11.3.3 (Build BR_LSTYTHIK_96_9) * * (build date 20150422-1027) * * * * 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. 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 NPS 7.2.0.3-P2 * * (build 43166) (build date 20150422-1027). * * 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 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=swg27045592 ================================================================ 1. What's New v ================================================================ 1.1 Load performance improvements (skipping empty tables) v ================================================================ ================================================================ 1.2 Incremental updates - suspending faulty tables v ================================================================ ================================================================ 1.3 Incremental updates in parallel v ================================================================ ================================================================ 1.4 Scalability of the incremental update function - v Automatically define distribution and organization keys v ================================================================ ================================================================ 1.5 Automatic restart of incremental updates v ================================================================ ================================================================ 1.6 Clean-up of the CDC Capture Agent catalog v ================================================================ ================================================================ 1.7 Load improvements with NPS 7.2.0.2 v ================================================================ ================================================================ 1.8 N3001-001 support v ================================================================ ================================================================ 1.9 Physical partition numbers in input strings for v the load, archive, and restore stored procedures v ================================================================ ================================================================ 1.10 In-database transformation v ================================================================ ================================================================ 2. Solved Problems v ================================================================ 2.1 Incorrect table status reported during load v ================================================================ ================================================================ 2.2 Table cannot be enabled for incremental updates v ================================================================ ================================================================ 2.3 Enabling or disabling incremental updates for a DB2 v subsystem fails with a timeout error v ================================================================ ================================================================ 2.4 DB2 archive tables cannot be moved by the 'High v Performance Storage Saver' (HPSS) v ================================================================ ================================================================ 2.5 Loads with product v version 4 are slower than loads with version 3 v ================================================================ ================================================================ 2.6 Versions of Access Server and replication engine only v displayed in user interface if a v DB2 subsystem has been enabled for incremental updates. v ================================================================ ================================================================ 2.7 Trace for stored procedures is generated although v trace level is 'OFF' for all components v ================================================================ ================================================================ 2.8 The SYSPROC.ACCEL_LOAD_TABLES stored procedure returns v message AQT10205I when users cancel a load task v ================================================================ ================================================================ 2.9 Trace collection fails v ================================================================ ================================================================ 2.10 Trailing blanks in accelerator name cause failure v of queries v ================================================================ ================================================================ 2.11 Repeated transfer of packages from the HFS to the v accelerator fails v ================================================================ ================================================================ 2.12 Stored procedure SYSPROC.ACCEL_LOAD_TABLES returns error v message AQT10050I v ================================================================ ================================================================ 2.13 Transfer of large files with stored procedure v SYSPROC.ACCEL_UPDATE_SOFTWARE fails v ================================================================ ================================================================ 2.14 SQL error when identifiers start with an v underscore character v ================================================================ ================================================================ 2.15 An internal error occurred during: 'Save Trace...'. v ================================================================ ================================================================ 2.16 SQL errors when out-of-range numeric values v are mapped to the generic SQLCODE -904 v ================================================================ ================================================================ 2.17 Sporadic heartbeat failure v ================================================================ ================================================================ 2.18 High system workload causes crash v ================================================================ ================================================================ 2.19 Elapsed time reported in DB2 Analytics Accelerator query v history is too high v ================================================================ ================================================================ 2.20 Stored procedure SYSPROC.ACCEL_LOAD_TABLES returns wrong v error message v ================================================================ ================================================================ 2.21 Fluctuating numbers of result rows and result v bytes shown in query history for running queries v ================================================================ ================================================================ 2.22 Allow users to turn the 24:00 support off v ================================================================ ================================================================ 2.23 Load fails if the names of columns with an unsupported v data type start with an underscore character v ================================================================ ================================================================ 2.24 Data loss when the distribution key of an incrementally v updated table is changed v ================================================================ ================================================================ 2.25 SYSPROC.ACCEL_LOAD_TABLES fails when columns of a v distinct type are encountered that are based on the v VARBINARY or the TIMESTAMP WITH TIME ZONE data type v ================================================================ ================================================================ 2.26 SYSPROC.ACCEL_ARCHIVE_TABLES creates an unwanted v image copy and returns message AQT10306I if the ZPARM v FCCOPYDDN is set v ================================================================ ================================================================ 2.27 Typed non-ASCII characters are ignored in configuration v console. v ================================================================ ================================================================ 2.28 IBM DB2 Analytics Accelerator needs a long time to v restart v ================================================================ ================================================================ 2.29 Invalid timestamp representations resulted in SQLCODE v -904 v ================================================================ ================================================================ 2.30 Replication stops after failover due to time v synchronization restrictions v ================================================================ ================================================================ 2.31 Stored procedures hang if too many concurrent v read or write processes are running on the accelerator v ================================================================ ================================================================ 2.32 LOAD fails after activating conversion of 24:00h v timestamps as time portion in timestamps v ================================================================ ================================================================ 2.33 Visual Explain shows an error message with a v java.lang.NullPointerException v ================================================================ ================================================================ 2.34 Problem setting multiple environment variables for stored v procedures in the MESSAGE input parameter v ================================================================ ================================================================ 2.35 Wait time in query history incorrect v ================================================================ ================================================================ 2.36 Load operation does not finish v ================================================================ ================================================================ 2.37 Trace files lack system information from passive host v ================================================================ ================================================================ 2.38 Connection between DB2 and IBM DB2 Analytics Accelerator v breaks in case of timeout v ================================================================ ================================================================ 2.39 Problems when connecting to the IBM DB2 Analytics v Accelerator Console v ================================================================ ================================================================ 2.40 Cancellation of a DB2 thread that executes a v SYSPROC.ACCEL_LOAD_TABLES call takes too long v ================================================================ ================================================================ 2.41 Stored procedure SYSPROC.ACCEL_LOAD_TABLES returns error v message AQT10050I v ================================================================ ================================================================ 2.42 Replication latency increases v ================================================================ ================================================================ 2.43 Query history unusable v ================================================================ ================================================================ 2.44 Virtual accelerator function not available in v IBM DB2 Analytics Accelerator Studio GUI v if stored procedures are not installed. v ================================================================ ================================================================ 2.45 New mappings of IBM DB2 Analytics Accelerator for z/OS v errors to SQLCA information v ================================================================ ================================================================ 2.46 A reload of incremenally updated tables without v detectChanges="DATA" or forceFullReload="true" might v result in incorrect table data v ================================================================
Problem conclusion
Temporary fix
Comments
--
APAR Information
APAR number
PI30282
Reported component name
SMRT ANL OPT DB
Reported component ID
5697AQT00
Reported release
410
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-11-25
Closed date
2015-04-30
Last modified date
2015-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI27392
Modules/Macros
AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10 AQTDBDYN AQTDBQIT AQTDBTRC AQTDBUNL AQTDBZPR AQTDEFTR AQTENV AQTNILIC 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 AQT02MIG 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 UI27392
UP15/05/14 P F505
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:
01 June 2015