A fix is available
APAR status
Closed as new function.
Error description
FIRST 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 1. * * * * 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.1 * * (build: 20151217-2301) * * Stored procedure build: 5.1.1 * * (build: 20160112-1532) * * * * 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. A detailed description for each fix can be found in the following support document: http://www.ibm.com/support/docview.wss?uid=swg27047477 ================================================================ 1. Solved Problems ================================================================ ================================================================ 1.1 Query history shows truncated statements ================================================================ ================================================================ 1.2 Transfer software update packages from IBM Analytics Accelerator Data Studio not possible ================================================================ ================================================================ 1.3 Tables not displayed anymore after changing to an unsupported table type ================================================================ ================================================================ 1.4 Accelerator stops working ================================================================ ================================================================ 1.5 Stored procedures that create trace file entries fail with error AQT10200E ================================================================ 1.6 TIMESTAMP arithmetics results of IBM DB2 Analytics Accelerator for z/OS V5.1.0 might differ from results in DB2 for z/OS ================================================================ 1.7 Unsupported type of HAVING clause not documented in "Incompatibilities between DB2 for z/OS and IBM DB2 Analytics Accelerator for z/OS" ================================================================ 1.8 Query does not return anything (query hangs) ================================================================ 1.9 Special characters not allowed in accelerator-only tables ================================================================ 1.10 Timestamp columns with a precision other than 6 or 12 are incorrectly created as precision 6 columns in accelerator- only tables. This should not block SELECT, INSERT, UPDATE, or DELETE operations on these columns, but DB2 for z/OS blocks such operations for no apparent reason. ================================================================ 1.11 Timestamp operations do not return fractional seconds ================================================================ 1.12 Rare occurrences of SQL errors if the system utilization is high ================================================================ 1.13 After a reload, query acceleration is disabled for a table that is enabled for incremental updates ================================================================ 1.14 Load operation aborts with SIGABEND if the system utilization is very high ================================================================ **************************************************************** ================================================================ 2. Migration considerations ================================================================ If you want to upgrade to the newest version of the incremental update function from a version older than 4.1 PTF-5, you must update the replication engine two times. The first time, apply the base package (RE Base) of V5.1 GA, and then the update package of V5.1 GA (RE Update). Wait until RE Base has been applied successfully before you continue with RE Update. Attention: Make sure that a replication status other than 'Error' is displayed in the header of the Accelerator view in IBM DB2 Analytics Accelerator Studio before you apply an update of the replication engine. Otherwise, the accelerator might stop working and enter a state that requires the help of IBM support. To avoid this issue, use IBM DB2 Analytics Accelerator Studio Version 5.1.0.1 or a higher version for the update because this version checks the replication status before an update can be applied. ================================================================ **************************************************************** ================================================================ 3. Known issues v ================================================================ Please see here: A detailed description for the solved problems and the known issues can be found in the following support document: http://www.ibm.com/support/docview.wss?uid=swg27047477 ================================================================
Problem conclusion
Temporary fix
Comments
-- ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI56036 FOR DESCRIPTION ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI56036 FOR DESCRIPTION ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI56036 FOR DESCRIPTION ×**** PE16/04/15 PTF IN ERROR. SEE APAR PI60730 FOR DESCRIPTION
APAR Information
APAR number
PI56036
Reported component name
SMRT ANL OPT DB
Reported component ID
5697AQT00
Reported release
510
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-01-26
Closed date
2016-02-03
Last modified date
2016-04-22
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI35012
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 AQT02ENQ AQT02FGV AQT02FRF AQT02GQD AQT02GQR AQT02GTC AQT02GTI AQT02ISP AQT02LTB AQT02MIG AQT02PSD AQT02RAC AQT02RAT AQT02RTB AQT02STA AQT02SYN AQT02TCO AQT02UCR AQT02USW
Fix information
Fixed component name
SMRT ANL OPT DB
Fixed component ID
5697AQT00
Applicable component levels
R510 PSY UI35012
UP16/02/09 P F602
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:
22 April 2016