A fix is available
APAR status
Closed as new function.
Error description
THIRD 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 3. * * * * IDAAV4R1/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=swg27039487 * * * * This PTF contains: * * Server version: 4.1.3 * * (build: 20140730-1600) * * Stored procedure build: 4.1.3 * * (build: 20140715-1310) * * * * 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.3 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 * * 10.2.1.2221 (build date 20140723-1400) * * 2.Replication Engine base * * version 10.2.1 (Build CCTRJYPP_20_4) * * (build date 20140414-1822) * * 3.Replication Engine update * * version 10.2.1 IF9 * * (Build CCTRJYPP_20_52) * * (build date 20140723-1400) * * * * 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.1.0.2-P1 GA * * (build 39556) (build date 20140730-1600). * * 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=swg27042433 ================================================================ 1. What's New v ================================================================ 1.1 Improve full table reload performance v ================================================================ **************************************************************** ================================================================ 1.2 Always display software version of incremental update v components v ================================================================ **************************************************************** ================================================================ 1.3 Load improvements with NPS 7.1.0.2 ================================================================ **************************************************************** ================================================================ 1.4 Default trace configuration for stored procedures ================================================================ **************************************************************** ================================================================ 2. Solved Problems v ================================================================ 2.1 Stored procedure SYSPROC.ACCEL_CONTROL_ACCELERATOR called v with option waitForReplication ends prematurely v ================================================================ **************************************************************** ================================================================ 2.2 Query appears in the query history with error code 57011 v if SPUFI output reaches a 250-row threshold v ================================================================ **************************************************************** ================================================================ 2.3 Enable subsystem for replication returns error CHC0025 W. v The user ID and password combination is not valid. v ================================================================ **************************************************************** ================================================================ 2.4 Authorization issues for DB2 packages of IBM DB2 Analytics v Accelerator during run-time v ================================================================ **************************************************************** ================================================================ 2.5 The sample program AQTSCALL does not support the stored v procedures SYSPROC.ACCEL_CONTROL_ACCELERATOR, v SYSPROC.ACCEL_SET_TABLES_REPLICATION and v SYSPROC.ACCEL_TEST_CONNECTION v ================================================================ **************************************************************** ================================================================ 2.6 Product fails to restart v ================================================================ **************************************************************** ================================================================ 2.7 Stored procedure SYSPROC.ACCEL_GET_TABLES_INFO fails with v error message AQT10200I v ================================================================ **************************************************************** ================================================================ 2.8 Database locks of Netezza backend not available in trace v archive v ================================================================ **************************************************************** ================================================================ 2.9 Accelerator does not come online v ================================================================ **************************************************************** ================================================================ 2.10 Reload with detectChanges='DATA' fails with SQL error v ================================================================ **************************************************************** ================================================================ 2.11 Load performance degradation in DB2 Analytics Accelerator v for z/OS V4 when compared with V3 v ================================================================ **************************************************************** ================================================================ 2.12 Invalid value for column v SYSACCELERATEDTABLES.SUPPORTLEVEL for tables created on v virtual accelerator. v ================================================================ **************************************************************** ================================================================ 2.13 Transfer of Netezza Platform Software aborts with return v code 2 v ================================================================ **************************************************************** ================================================================ 2.14 Network information not included in traces v ================================================================ **************************************************************** ================================================================ 2.15 Literal parameter '12:00 AM' for TIME function and v literal '24:00:00' as time parameter for TIMESTAMP v function are treated incorrectly v ================================================================ **************************************************************** ================================================================ 2.16 SYSPROC.ACCEL_LOAD_TABLES reports a false timeout v situation and returns the internal error AQT10205I. v ================================================================ **************************************************************** ================================================================ 2.17 Stored procedure SYSPROC.ACCEL_LOAD_TABLES fails with v message AQT20021I v ================================================================ **************************************************************** Limitations: Users affected: All product users who have enabled multiple encoding and run SQL queries against Unicode tables that reside alongside EBCDIC tables on the same accelerator. Short summary: Certain DB2 for z/OS queries are incompatible with the product. Details: 1. If the query contains a LIKE condition, and the string value of the condition is shorter than the value length of the column definition, the string value is padded with space characters so that its length matches the length of the column definition. However, the padding might change the string value in the query so that it no longer fits the purpose. Example: A column defined as CHAR(10) contains a string value "012345678". The query reads SELECT * FROM TABLE1 where COLUMN1 LIKE '0123456%_ '. The argument of the LIKE expression no longer fits its initial purpose because a space character is appended to the end of the string. Work-around: Use wildcards for characters at the end of the string, for example '0123456%' or '0123456___'. 2. If a query contains character-based functions, such as RPAD(), to operate on strings in multi-byte encoding, DB2 for z/OS counts the bytes used by the strings, while the Netezza database counts the number of characters. Work-around: Add a 'CAST TO GRAPHIC' expression to the output SQL of the RPAD() function. Users affected: All users of IBM DB2 Analytics Accelerator for z/OS with Netezza Performance Server (NPS) 7.0.4.3 running SQL queries against Unicode tables that reside alongside EBCDIC tables on the same accelerator with multiple encoding function enabled Short summary: Query results differ when they are compared with results delivered by DB2 for z/OS. Details: 1. Use of the TRANSLATE function might result in the truncation of space characters at the end of the result string. 2. Query results differ if queries contain SUBSTRING() and LOCATE() functions that operate on the same table column.
Problem conclusion
Temporary fix
Comments
--
APAR Information
APAR number
PI19232
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-06-04
Closed date
2014-08-01
Last modified date
2014-09-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI20189
Modules/Macros
AQTDBACC AQTDBACT AQTDBCAT AQTDBCON AQTDBC10 AQTDBDYN AQTDBQIT AQTDBTRC AQTDBUNL AQTDBZPR AQTDEFTR 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 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 UI20189
UP14/08/07 P F408
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:
03 September 2014