• Db2 11.5 (11.10.19)
         
    IBM Db2 V11.5
    Four editions - two license models
     
invispix 10x10
invispix 10x10

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


Translate this page:

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.
invispix 10x10
invispix 10x10
Technical InfoTechnical Info

Technical Info

DocumentationDocumentation

Documentation

IBM NewsletterIBM Newsletter

IBM Newsletter

Current BugsCurrent Bugs

Current Bugs

Bug ResearchBug Research

Bug Research

Bug FixlistsBug Fixlists

Bug Fixlists

Feature RequestFeature Request

Feature Request

Release NotesRelease Notes

Release Notes

Versions InfomailVersions Infomail

Versions Infomail

Product LifecycleProduct Lifecycle

Lifecycle

Media DownloadMedia Download

Media Download

invispix 10x10
Service and SupportService and Support

Service and Support

IBM Db2 for purchasersIBM Db2 for purchasers

IBM Db2 for purchasers

IBM Software for ISVsIBM Software for ISVs

IBM Software for ISVs

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.