IBM Support

APARs fixed for IBM Db2 Analytics Accelerator for z/OS Version 7

Product Documentation


Abstract

This document lists the APARs fixed with maintenance level 7.1.8 or higher

Content

APARs fixed with maintenance level 7.5.6

APAR # APAR description Comments
PH33677 A query containing a CASE WHEN EXISTS-clause incl. a subquery using 'FETCH FIRST 1 ROWS ONLY' may deliver incorrect results.
PH35721 Operations such as Add, Remove, Load, CONTROL_ACCELERATOR do not finish and may lead to message AQT10050E.
PH36364 An HTAP query may end with SQLCDE -904 (accompanied by message text "Set of tables is empty or invalid.")
PH36479 The cancellation of a task (Load or Query) may result in a restart of the accelerator.
PH36484 The cancellation of a Load task may lead to a hang of this task
PH36727 Users of accelerator on Z do not see encryption status in Data Studio Only applies to IDAA V7 on Z
PH36776 WAITFORDATA queries seem to get a time penalty when Integrated Synchronization is used as replication method.               
PH38537 Processing of a query with a large IN-LIST may end with  SQLCODE=-954, SQLSTATE=57011                                           
PH38542 SQL lock events are no longer retrieved and purged from Db2wh

APARs fixed with maintenance level 7.5.5.2

APAR # APAR description Comments
PH36129 ACCELERATOR ON Z MANAGEMENT CONSOLE NOT ALLOWING SCROLLING DOWN

APARs fixed with maintenance level 7.5.5.1

APAR # APAR description Comments
PH33711 Upgrade to accelerator maintenance level 7.5.4 requires a restart after occurrence of a Disable-Webconsole-Timeout
PH35210 Custom thresholds in Db2 LUW (defined via CREATE THRESHOLD) may cause a crash of the accelerator with subsequent automatic restart  
PH35326 Query Monitoring in IBM Db2 Analytics Accelerator Studio lists canceled queries with state 'FAILED' and SQLCODE 0.
PH35370 Multiple-row Insert (MRI) into an accelerator-only table using DB2  Connect inserts incorrect values
PH35373 Multiple-row Inserts (MRI) of a local application into an
accelerator-only table my fail with a negative SQLCODE. 
PH36450 A query may return more rows compared to running it in DB2 for z/OS or using V5 of the accelerator.

APARs fixed with maintenance level 7.5.5

APAR # APAR description Comments
PH33419 Table partitions in 'ARCHIVE INCOMPLETE' state cannot be re-archived.
PH33950 Data Studio shows wrong table size after full table reload.
PH34319 When working with the 'QUERY HISTORY' OF DB2 Analytics Accelerator Studio the default "REFRESH" interval needs to be 'AUTOMATIC OFF'.   
PH34511 Working with Query Monitoring leads to message "The entity name must immediately follow the '&' in the entity reference".
PH34723 Using stored procedure ACCEL_COLLECT_TABLE STATISTICS
erroneously ends with message AQT20139E.
PH35160 Replication using Integrated Synchronization may fail with
SQLCODE=-20570, SQLSTATE=22551.
PH35591 Queries on federated reference tables may end with  SQLCODE -551.

APARs fixed with maintenance level 7.5.4.2

APAR # APAR description Comments
PH33657 Queries conveyed using an ODBC/CLI driver end with  SQL0902C, reason code "9", SQLSTATE=58005              

APARs fixed with maintenance level 7.5.4.1

APAR # APAR description Comments
PH33490 Although having chosen to include the appliance trace, the
accelerator trace archive does not include it.          

APARs fixed with maintenance level 7.5.4

APAR # APAR description Comments
PH27585 When enabling incremental updates for Integrated Synchronization options asking to specify  'Y/N' are  ending with garbled characters
PH29742 Loading tables to the accelerator may end prematurely with msg "SQL0954C Not enough storage is available in the application heap to proc statement" 
PH32431 CPU cost value (for query execution) disappeared in IBM DB2 Analytics Accelerator Studio
PH33421 Integrated Synchronization commands may fail due to replication state 'PAUSED'

and

InSync goes into error state (long running UR causes Java Heap OOM)

PH33491 Using Integrated Synchronization replication latency may not be updated for a longer period of time.
PH33835 A load request may time out due to issues with the underlying 'create table'-request
PH34322 The accelerator trace may be flooded with messages containing 'getSubscriptionName()' but not specifying a subscription
 

APARs fixed with maintenance level 7.5.3

APAR # APAR description Comments
PH25997 Definition of multiple IP addresses in the activation profile for the SSC LPAR currently is not supported Only applies to IDAA V7 on Z
PH27055 When upgrading IDAA V7 maintenance level 7.5.0.x to 7.5.2 the installation log of the Apply process may show incorrect data
PH27420 When stopping the accelerator, for example in the context of an upgrade of the accelerator, a query may return incorrect data
PH27626 A full reload may end successfully although none of the data to be loaded were transferred to the accelerator
PH27644 IBM Db2 Analytics Accelerator Studio does not execute
'Alter Keys' if the keys are not changed           
Requires IBM Db2 Analytics Accelerator Studio 7.5.3
PH27646 IBM Db2 Analytics Accelerator Studio does not show the progress indicator correctly when altering or setting an organizing key Requires JCC driver 4.27.26
PH27771 Stored Procedure SYSPROC.ACCEL_ADD_TABLES fails with assertion: an  assertion '( MCCSID.GETVALUE() > 0 )' failed       PTF UI72071
PH27773 Stored Procedure SYSPROC.ACCEL_GET_TABLES_INFO fails with message AQT10402E: Error 'Invalid character encountered' PTF UI72071
PH27984 When upgrading IDAA on Z maintenance level 7.5.2(.1) to a  higher level an 'Error' message box will be displayed erroneously      Only applies to IDAA V7 on Z
PH28293 When running a load using stored procedure ACCEL_LOAD_TABLES the load request may hang in Db2 warehouse.                                            
PH28404 Using 'Reboot all appliance nodes' function on the accelerator console fails with an error message
PH28723 MSG DSNX881I ... Magneto Issue: ID 1384 Severity: MAJOR console_alerts ...Failed to collect status from resource manager
PH28727 IBM Db2 Analytics Accelerator Studio, Query monitoring: using "Show EXPLAIN details" may fail with messages AQT20001W and AQT20125E
PH29288 If load operations lead to a deadlock situation, the accelerator restarts itself.                                 
PH29409 A query may end with message 'SQL0901N The SQL statement or command failed because of a database system error. SQLSTATE=58004'
PH29940 Integrated Synchronization stops and cannot be started again
using the administration console.                           
PH30066 Message DSNX881I "...901 Storage utilization above threshold ...SW://FS.SDA8/HADOMAIN1.NODE..." may occur in DB2MSTR     Only applies to IDAA V7 on IIAS
PH30147 Upon or after saving an IDAA trace the system may go into a general hang state due to a 'File system full' condition  
PH30260 Replication using Integrated Synchronization and involving members of a data sharing group may lead to incorrect data on the accelerator           
PH31550 When using Integrated Synchronization for replication between Db2z and the accelerator users may see an error message such as
"X rows parsed, but apply changed Y rows. Table Z is           
inconsistent, set table state to ERROR."                      

APARs fixed with maintenance level 7.5.2.2

APAR # APAR description Comments
PH28026 Using IBM DB2 Analytics Accelerator Studio a refresh of the accelerator view may lead to error message mentioning invalid XML
PH28029 A query may deliver wrong results if it contains a scalar subquery and 'FETCH FIRST 1 ROW'
PH28030 Queries may be running extremely slow if parallel calls of SP ACCEL_GET_QUERY_DETAILS2 hit the 15 minute processing timeout of EXPLAIN

APARs fixed with maintenance level 7.5.2.1

APAR # APAR description Comments
PH27523 Initial installation of IBM DB2 ANALYTICS ACCELERATOR ON Z with a multi-node setup may fail Only applies to IDAA V7 on Z
PH27593 Accelerator tasks, for example LOAD, fail due to a 'Drop Table' statement hanging in the database engine                    
PH27594 Query fails when LENGTH function return NEGATIVE or 0;
the accelerator database engine crashes subsequently           
PH27596 Long-running queries may finally fail with SQLCODE -904
PH27609 A query requiring spill-to-disk for the result set may be hanging without the possibility to cancel it.
PH27683 IBM Integrated Sychronization (InSync): replication suddenly
goes into state 'Error'. Attempts to restart replication by  
inSnyc are not successful and lead to message AQT20126E.

APARs fixed with maintenance level 7.5.2

APAR # APAR description Comments
PH24437 Special register values returned by Stored Procedure
ACCEL_GET_QUERIES2 are truncated                  
PH25111 In rare cases customers may experience repeated restarts of Integrated Synchronization which may suspend the subscription
PH25253 A load of a table on the accelerator failed with error message
"Target table status conflict with detected LOAD status"     
PH25302 When enabling replication after initial load of a table, REORGs following subsequent loads to not remove old table versions
PH25452 Replication based on Integrated Synchronization may enter the 'ERROR' state followed by an 'OUT OF DISK SPACE' condition.
PH25560 Performance degradation may occur with queries on HPSS tables. Distribution/organizing keys are not applied to archived tables.
PH25995 SSC root disk may be filled up with diagnostic data Only applies to IDAA V7 on Z
PH25998 Definitions of static network routes (attribute static_routes in the Accelerator configuration file) are currently not applied for bonding networks. Only applies to IDAA V7 on Z
PH26790 Load tasks may be hanging after a failure in the corresponding stored procedure and cannot be cancelled.
PH26946 During operation of IDAA 7.5 or during an upgrade the message "201: Unhealthy component detected" may occur.        Only applies to IDAA V7 on IIAS
PH27055 When upgrading IDAA V7 maintenance level 7.5.0.x to  7.5.2 the installation log of the apply process may show incorrect data Only applies to IDAA V7 on IIAS
PH27097 Inserting or updating of VARCHAR, VARGRAPHIC, or VARBINARY columns may result in a corruption on disk
PH27635 Cancelling of a load may lead to unintentional restart of the
IDAA server. All currently running queries and loads will be
aborted.                                                    
PH27793 If  Integrated Synchronization is forced to restart, an error message like "2 rows parsed, but apply changed 4 rows" may occur.

APARs fixed with maintenance level 7.5.1

APAR # APAR description Comments
PH20898 A query may end with SQLCODE -904 and resource name  -1656
PH21932 With customization parameter  ENABLE_COPY_TABLE_STATISTICS set to TRUE users may see warning messages in IBM DB2 Analytics Accelerator Studio
PH23578 With customization parameter  ENABLE_COPY_TABLE_STATISTICS set to TRUE a reload of a table may result in a restart of the accelerator
PH23995 (Re-)loading data to the accelerator may end with message
AQT10420E or AQT10421E.
PH24432
Cancelling a long-running query is not successful.
Message "DSNX881I ...2001 W SQL statement with task ID nnnnnnn is running"
PH24441 Load requests to the accelerator are failing with SQLCODE 466, SQLSTATE 0100C and are accompanied by message AQT10050E     
PH24448 Load tasks are hanging. Cancellation of those tasks using IBM
Db2 Analytics Accelerator Studio won't work
PH24629 When upgrading IDAA V7 maintenance level 7.5.0.x to  7.5.1 the installation log of the apply process may show incorrect data Only applies to IDAA V7 on IIAS

APARs fixed with maintenance level 7.5.0.2

APAR # APAR description Comments
PH23674 IBM DB2 Analytics Accelerator on IBM Z (maintenance level  7.5.0 or 7.5.0.1): Restart fails three months after initial installation Only applies to IDAA V7 on Z

APARs fixed with maintenance level 7.5.0.1

APAR # APAR description Comments
PH20394 Using IDAA on Z adding of DASDs to the accelerator using the JSON configuration file may fail Only applies to IDAA V7 on Z
PH20802 Using Analytics Accelerator Studio the replication status of a subscription shows 'ERROR' without any preceding replication issues Also known as CDC File handle issue - JR61803
PH21308 Stored Procedure SYSPROC.ACCEL_ARCHIVE_TABLES fails with error AQT10200E 
PH21562 Default value for DB2WH configuration parameter  AUTO_STMT_STATS is OFF 

APARs fixed with release 7.5

APAR # APAR description Comments
PH19810 USING IDAA V7 ON Z, MAINTENANCE LEVEL 7.1.9, THE GDPS SERVER LOOKS OUT FOR A SYSTEM NAMED "SINGLE" WHICH IS NOT FOUND Only applies to IDAA V7 on Z

APARs fixed with maintenance level 7.1.9.1

APAR # APAR description Comments
PH19670 UPGRADING IDAA V7.1 ON IIAS TO MAINTENANCE LEVEL '7.1.9' MAY BRING THE SYSTEM DOWN Only applies to IDAA V7 on IIAS

APARs fixed with maintenance level 7.1.9

APAR # APAR description Comments
PH15516 OUT OF THE SUDDEN REPLICATION GOES INTO STATE 'ERROR' AND MAY BE ACCOMPANIED BY MESSAGE CHC6503E.       
PH16538 IDAA V7 CALL-HOME FUNCTION ON IIAS: TESTING OF THE CALL-HOME CONNECTIVITY INDICATES A FAILURE.    
PH17974 AN ACCELERATOR MAY BECOME TEMPORARILY OFFLINE WHILE PREMATURELY SWITCHING INTO SYSTEM STATE 'UNKNOWN'.     

APARs fixed with maintenance level 7.1.8

APAR # APAR description Comments
PH12496 MULTIPLE ROW INSERT LEADS TO SQLCODE -254 (SQLSTATE 22530)
PH12631 IDAA V7 CUSTOMERS USING IIAS MAY RECEIVE MESSAGE "DSNX881I .. MAGNETO ISSUE ...TITLE: FAILED TO COLLECT STATUS"
PH12632 MESSAGE "DSNX881I ...MAGNETO ISSUE ....TITLE: STATEMENT PERFORMANCE ISSUE" APPEARS IN DB2MSTR
PH12634 A QUERY USING STRING MANIPULATION FUNCTION "UPPER" MAY FAIL WITH SQLCODE -904 (SQLSTATE 57011)
PH12804 LOADING A TABLE USING IDAA LOADER V2.1 MAY RESULT IN AN ERROR INDICATING "HLPPIPE API ERROR"
PH13004 USING DB2 12 WITH DSNHDECP PARM APPLCOMPAT SET TO V12R1M501 OR HIGHER MAY CAUSE ENABLING OF REPLICATION TO FAIL
PH13804 IDAA LOAD TABLES PERFORMANCE DECREASE AFTER INSTALL OF IDAA 7.1.8 Fixed with 7.1.8.1
PH14156 STATUS OF REPLICATED TABLES CHANGES TO 'SUSPENDED' IN IBM DB2 ANALYTICS ACCELERATOR STUDIO Fixed with 7.1.8.2
PH15241 ACCELERATOR BACKEND DATABASE MAY RESTART EVERY 10 MINUTES: ALSO ACCELERATOR STATUS FLIPS BETWEEN "ONLINE" & "MAINTENANCE" Fixed with 7.1.8.3

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS4LQ8","label":"Db2 Analytics Accelerator for z\/OS"},"Component":"--","Platform":[{"code":"PF035","label":"z\/OS"}],"Version":"7.1.0 \n7.5.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 August 2021

UID

ibm10958189