Fix List for DB2 Version 11.1 for Linux, UNIX and Windows
DB2 11.1 APAR Fix list contains list of APARs shipped for each fix pack in DB2 Version 11.1 for Linux, UNIX and Windows products. The Severity column value of 1 is high and 4 is low. Severity column represents the severity of the PMR at the time the APAR was opened.
Product Name : DB2 UDB Version 11.1 Updated : Tue Mar 28 10:19:50 EDT 2017
Select a Fix Pack: 1 iFix001 | 1
| DB2 Version 11.1 Fix Pack 1 iFix001 | |||||
|---|---|---|---|---|---|
| APAR | Sev. | Abstract | |||
| Fix Pack 1 iFix001 - CDE Data | |||||
| IT18637 | 2 | [POST11M1FP1GASAP_CANDIDATE]-901 CAN ONLY INPLACE UPDATE THE HEAD REC OF A MULTI-PAGE RECORD, DATABASEMETAWRITER.CPP:1417 | |||
| IV91752 | 2 | THE FIRST UPDATE STATEMENT FOR A COLUMN-ORGANIZED TABLE MAY IN RARE CASES CAUSE FUTURE QUERIES TO MISS SOME MATCHING RESULTS. | |||
| Fix Pack 1 iFix001 - CDE Query | |||||
| IT18914 | 2 | WITH DB2 V11.1 M1FP1 ON ZLINUX WITH HARDWARE LEVEL EQUAL OR OLDER THAN ZEC13 DB2START WILL FAIL | |||
| Fix Pack 1 iFix001 - Codegen and Runtime | |||||
| IT18072 | 2 | SQL0902 MAY OCCUR DURING EXECUTION OF QUERY CONTAINING LARGE RESULTSET | |||
| IT19462 | 2 | WINDOWS EVENT HANDLE LEAK WITH PARALLELIZED QUERY PLANS (INTRA_PARALLEL YES) - MAY CAUSE OSERR 1450 | |||
| Fix Pack 1 iFix001 - Data Recovery Services | |||||
| IT17844 | 1 | UPGRADE DATABASE COMMAND MIGHT FAIL IN SQLPMIGRATEMFH | |||
| IT19687 | 2 | DB2 NOT CALCULATING 'REUSABLE' SPACE CORRECTLY DURING UPGRADE | |||
| IT19023 | 2 | AFTER CRASH RECOVERY, AN DEFERRED ONLINE REORG CLEANUP MIGHT CAUSE AN X ROW LOCK MISSING FOR AN INDOUBT TRANSACTION. | |||
| IT19780 | 2 | IN RARE TIMING CONDITION, THE DATABASE CAN HANG DUE TO DEADLATCH BETWEEN HADR PROCESSES. | |||
| IT19781 | 2 | IN A DPF DATABASE INSTANCE, IN RARE TIMING CONDITION A SEG-FAULT/TRAP CAN OCCUR IN FUNCTION SQLPSETTID() | |||
| Fix Pack 1 iFix001 - Install and Catalog Services | |||||
| IT15485 | 2 | SECURITY: TABLE PRIVILEGE CHECKING MAY RETURN OUTDATED RESULTS AFTER A TABLE IS RENAMED (CVE-2017-1150) | |||
| Fix Pack 1 iFix001 - Process Model | |||||
| IT16127 | 1 | IN DPF, DB2 TRAPS IN SQEDBMGR::LOCALDEACTIVATE IF A NODE FAILS AND THAT NODE IS THE CATALOG NODE FOR SOME DATABASE | |||
| Fix Pack 1 iFix001 - Query Compiler QGM | |||||
| IT18170 | 2 | WRONG RESULT IS POSSIBLE IF GENERATED ALWAYS EXPRESSION REFERENCES A BUILT-IN FUNCTION WITH MORE THEN ONE STRING INPUT | |||
| Fix Pack 1 iFix001 - pureScale Services | |||||
| IT17913 | 3 | DB2GCF MIGHT INCORRECTLY REPORT INSTANCE AS OPERABLE INSTEAD OF AVAILABLE WHEN USING VIRTUAL HOSTNAME IN DB2NODES.CFG | |||
| DB2 Version 11.1 Fix Pack 1 | |||||
|---|---|---|---|---|---|
| APAR | Sev. | Abstract | |||
| Fix Pack 1 - Buffer Pool Services | |||||
| IT15752 | 1 | REVERT TO PREVIOUS METHOD OF CALCULATING ASYNCHRONOUS WRITE TIME FOR DB2 MONITORING | |||
| Fix Pack 1 - CDE Data | |||||
| IT16128 | 2 | SLOW PERFORMANCE WITH GROUP BY ON VARCHAR COLUMN WITH COLUMN BASED TABLES | |||
| Fix Pack 1 - Client Interfaces | |||||
| IT17403 | 1 | CONNECTION TO DB2 DATABASE USING ODBC DRIVER MANAGER IN MAC OS X FAILS WITH SQL1024N ERROR | |||
| IT11512 | 2 | DB2DCLGN -Z OS390 WRITES 05 LEVEL FOR GRAPHIC DATA TYPE | |||
| Fix Pack 1 - Codegen and Runtime | |||||
| IT17179 | 2 | IF ARRAY USED IN AN OPEN CURSOR IS MODIFIED THEN WRONG RESULT OR A TRAP ARE POSSIBLE | |||
| IT16869 | 2 | SELECT ROW CHANGE TOKEN WILL RETURN WRONG RESULT WHEN USINGRIDSCAN (ROW IDENTIFIER SCAN) | |||
| IT17259 | 2 | QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN | |||
| IT16656 | 2 | SQL0801 AND WRONG RESULTS FROM STDDEV_SAMP, VARIANCE_SAMP, COVARIANCE_SAMP WHEN USED IN AN OLAP SPECIFICATION | |||
| IT16860 | 2 | DB2STOP FORCE HANG DUE TO THE NOT INTERRUPTIBLE OSSSLEEP FUNCTION IN WINDOWS | |||
| Fix Pack 1 - DRDA Services | |||||
| IT11963 | 3 | KILL -9 TO A PURESCALE MEMBER RETURNS XAER_RMFAIL UNEXPECTEDLY | |||
| Fix Pack 1 - Data Management Services | |||||
| IT17214 | 2 | THE DATABASE MIGHT ABEND DUE TO PROGRAMMING ERROR IN LIST PREFETCH PROCESSING. | |||
| IT17489 | 2 | SELECT AGAINST AN MDC TABLE WITH A RANGE PREDICATE IN SMP MIGHT RETURN A WRONG RESULT | |||
| IT16569 | 2 | CURCOUNT IN DB2PD -REORG IS NOT MONITORED WHEN ONLINE REORG WITH CLEANUP OVERFLOWS OPTION | |||
| Fix Pack 1 - Data Management Utilities | |||||
| IT17130 | 2 | SORT RESERVATION MAY BE LEAKED UNDER CONSTRAINED SORT TUNING CON DITIONS, LEADING TO PERFORMANCE DEGRADATION AND SQL0955 ERRORS | |||
| Fix Pack 1 - Data Recovery Services | |||||
| IT12449 | 2 | DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT. | |||
| IT16274 | 2 | DB2CKBKP/DB2ADUTL MIGHT REPORT INCONSISTENT OBJECT HEADER FLAGS IN COMPRESSED BACKUP IMAGE | |||
| IT18238 | 3 | EXCESSIVE DB2DIAG MESSAGE WHILE RUNNING READLOG PROGRAM | |||
| Fix Pack 1 - Federation | |||||
| IV90269 | 1 | QUERIES WITH MULTIPLE OLAP CLAUSES AND DISTINCT AGAINST COLUMN ORGANIZED TABLES COULD RETURN WRONG RESULTS | |||
| JR56738 | 2 | CREATE WRAPPER AND CREATE NICKNAME FAILING WITH FODC TRAP ON SIG #4 | |||
| IT16062 | 3 | DB2 MIGHT RETURN SQL0901N WHEN EXECUTING QUERY WITH SCALAG FUNCTIONS USED IN A CASE STATEMENT | |||
| Fix Pack 1 - Index Manager | |||||
| IT17023 | 2 | DEADLATCHING DURING MULTIPLE INDEX INFO PAGES CREATION IN PURESCALE | |||
| Fix Pack 1 - Install and Catalog Services | |||||
| JR57036 | 2 | REPLICATION CENTRE TOOL IS MISSING ON V11.1 | |||
| IT16385 | 2 | DB2 DATA SERVER CLIENT SILENT INSTALL FAILS WITH ERROR: PRODUCT: IBM DATA SERVER CLIENT - DB2COPY1 -- ERROR 1314. | |||
| IT17230 | 2 | ADD LIBIBMC++.SO.1 32 BIT AND 64 BIT TO DB2 IMAGE FOR LINUX UBUNTU 16, SLES 12 AND RHEL 7 ON IBM Z SYSTEMS. | |||
| IT16407 | 2 | DB2PREREQCHECK INCORRECTLY LISTS LIBSTDC++.SO.5 AS REQUIRED FOR INSTALLATION OF DB2 V11.1 ON LINUX 390 (ZSERIES) | |||
| IT16741 | 3 | CUSTOMER CANNOT INSTALL DB2 WINDOWS CLIENT AFTER USING DB2UINS -F TO UNINSTALL OLDER VERSION OF DB2 WINDOWS CLIENT | |||
| IT17219 | 3 | SYSCAT.COLUMNS AND SYSIBM.SYSCOLUMNS MAY SHOW INLINE_LENGTH OF 0 FOR A TABLE'S LOB COLUMNS | |||
| IT17097 | 3 | SYSCAT.COLUMNS AND SYSIBM.SYSCOLUMNS MAY SHOW INLINE_LENGTH OF 0 FOR A TABLE'S LOB COLUMNS | |||
| Fix Pack 1 - Parsing and SQL PL | |||||
| IV90750 | 2 | INCORRECT RESULTS ARE POSSIBLE WHEN MULTIPLE ROW_NUMBER() , INLINED SQL SCALAR UDF AND COLUMN ORGANIZED TABLES ARE PRESENT | |||
| IT17941 | 2 | POSSIBLE WRONG RESULTS WHEN THE INPUT PARAMETERS OF AN INLINED SQL SCALAR UDF CONTAINS AN OLAP SPECIFICATION | |||
| Fix Pack 1 - Performance | |||||
| IT07722 | 2 | HADR STANDBY MAY CRASH DUE TO MEMORY CORRUPTION WITH TOP FUNCTION SQLOCRASHONCRITICALMEMORYVALIDATIONFAILURE | |||
| Fix Pack 1 - Problem Determination | |||||
| IT03399 | 2 | THE AMOUNT OF DATA WITCH CAN BE FETCHED BY PD UDFS IS AT MOST 500MB. | |||
| Fix Pack 1 - Process Model | |||||
| IT17143 | 2 | MEMBER SUBSET IS NOT DROPPED AFTER HOST DATABASE IS DROPPED | |||
| Fix Pack 1 - Query Compiler Optimizer | |||||
| IT17556 | 1 | INCORRECT RESULTS ARE POSSIBLE WHEN JOIN AGAINST CDE TABLES IS DONE AND AN UNDOCUMENTED JOIN SUPPORT REGISTRY VARIABLE SET | |||
| IT17458 | 2 | IN DB2 DPF, POSSIBLE WRONG RESULT WHEN OUTER JOIN PREDICATE COL1=COL2 AND BOTH COLUMNS ARE FROM THE OUTER TABLE | |||
| Fix Pack 1 - Query Compiler QGM | |||||
| IT17361 | 1 | FODC_TRAP, DROP() HIT SEGV DURING SQLNR_SPLIT_AND_GBPD | |||
| IT16271 | 2 | JOIN-CONDITION RETURNS SQLCODE -338 WHEN TABLE FROM IMPLICIT CROSS JOIN IS REFERENCED | |||
| IT16703 | 2 | DB2 MAY RETURN INCORRECT RESULTS WHEN USING STRING EQUALITY PREDICATES CONTAINING DIFFERING CODE UNITS | |||
| IT16599 | 2 | THE DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_HANDLE_MODULE_OBJ_REF WHEN CREATING A SQL ROUTINE | |||
| IT16792 | 2 | INCORRECT QUERY RESULTS WHEN USING OFFSET-CLAUSE AND/OR FETCH-FIRST-CLAUSE | |||
| IT17872 | 2 | DB2 MAY TRAP IN SQLNR_CHECK_CAN_ADD_GB_DISTINCT WHEN COMPILING SOME QUERIES | |||
| IT17256 | 2 | DB2 CRASH ON INVALID OBJECT | |||
| IT17452 | 2 | WRONG RESULT IN STORED PROCEDURE QUERY WHEN ADD/DROP CHECK CONSTRAINT | |||
| IT16575 | 2 | SQLCODE -120 WHEN UDF WITH DEFAULT VALUE USED WITHIN AN AGGREGATE FUNCTION IN SQL PL OR PL/SQL | |||
| IT09673 | 2 | XML QUERY MAY RETURN INCORRECT RESULT WHEN IT HAS OLAP AND ORDER BY | |||
| IT16112 | 3 | A CORRELATED SCALAR SUBQUERY IN AN UPDATE STATEMENT MAY NOT CORRECTLY RETURN SQL0811N | |||
| Fix Pack 1 - Security | |||||
| IT17190 | 2 | DB2AUDIT HIT EFAULT WHEN TRYING TO FORMAT THE OUTPUT. | |||
| IT16893 | 2 | ONLINE BACKUP WITH COMPRESSION AND ENCRYPTION MAY CREATE A CORRUPTED BACKUP FILE | |||
| Fix Pack 1 - Text Search | |||||
| IT17233 | 2 | SECURITY: NET SEARCH EXTENDER AFFECTED BY MULTIPLEÂ VULNERABILITIES INÂ OPENSOURCE EXPAT XML PARSER | |||
| IT15265 | 2 | DB2TS CLEAR EVENTS DOES NOT WORK WHEN EVENTTABLLE HAS ROWS > 1000. | |||
| Fix Pack 1 - pureScale Services | |||||
| IT16158 | 1 | DB2 PURESCALE HANG DUE TO MISSING LOCK NOTIFICATION | |||
| IT17462 | 3 | RHEL 7: THE DB2 FAULT MONITOR FEATURE DOES NOT SUPPORT THE SYSTEMD INIT SYSTEM | |||
| IT17469 | 3 | WHEN RUNNING 'DB2CLUSTER -LIST -ALERT', DB2ROCME LOGS TO THE DB2DIAG.LOG WITH UTC TIMESTAMP (+000) INSTEAD OF LOCAL TIME | |||