************************************************************
Product Name : DB2 UDB Version 11.5
Updated : Nov 15, 2023
************************************************************
Select a Fix Pack: | | | | | | | | |
DB2 Version 11.5 Fix Pack m9fp0 Known Issue Symptom Abstract DT148867 Incorrect Output [IN] IT42001: DB2ADUTLUPLOAD MAY WRONGLY UPDATE A HISTFILE ENTRY THAT CORRESPONDS TO A BACKUP SEQUENCE THAT FAILS TO BE UPLOADED DT161058 Abnormal End Of The Program [AB] TRAP IN FUNCTION SQLPDOUPDATELSNVALUESINXHDRS WHEN WRITING A LOGRECORD DT173258 Abnormal End Of The Program [AB] LOGICAL_RESTORE fails with "Unable to find the metadata file info.json for" error when restoring single schema out of multi-schema backup image. DT179023 Incorrect Output [IN] It is not possible to upload images/logs using db2adutl when the attached database partition number is different than the one used in DBPARTITIONNUM DT195969 New Function [NF] LBAR - Fixing the Problem with CREATE EXTERNAL REMOTESOURCE DT196027 New Function [NF] LBAR - Fixing the Problem with Wrong Order of Restoring Dependent Views DT209085 Integrity Problems [IG] LOGICAL_RESTORE - Ignore RCAC Options if No RCAC Tables Present in Backup Image and in Restore Set DT212931 Integrity Problems [IG] INDOUBT TRANSACTIONS NOT RESOLVED AUTOMATICALLY DT222096 Coded Halt [HL] LOGICAL_RESTORE fails when replaying schema DDL statements with syntax errors DT228165 Coded Wait [WS] ROLLFORWARD COMMAND MAY HANG WITH LOW DBHEAP MEMORY DT237799 Abnormal End Of The Program [AB] ROLLFORWARD OF DATABASE RESTORED FROM SNAPSHOT BACKUP MAY FAIL WITH AN UNEXPECTED CONDITION DT149261 Coded Halt [HL] IT42027: PURESCALE MEMBER RESTART HANG DUE TO CIRCULAR DEPENDENCY WITH BACKUP EXECUTING ON A DIFFERENT MEMBER DT149262 Incorrect Output [IN] IT42041: HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED DT196637 Integrity Problems [IG] LOGICAL_RESTORE fails on image check due to unexpected file DT211715 Incorrect Output [IN] Ignore non Critical Errors During Logical_Restore DT212779 Additional Information [AI] Audit records failures to access RCAC table data originating from LOGICAL BACKUP when it is not run DT213313 Performance [PR] Slow performance during database recovery when replaying TRUNCATE TABLE or CREATE/ALTER TABLE NOT LOGGED INITIALLY DT224265 Integrity Problems [IG] When running an online backup with EXCLUDE LOGS option and with DB2_DISABLE_FLUSH_LOG setting enabled, backup gets completed successfully but db2diag.log shows "DIA8414C Logging can not continue due to an error" message. DT173699 Abnormal End Of The Program [AB] SQL1797N with "Directory not empty" errors when calling LOGICAL_RESTORE or LOGICAL_BACKUP_DETAILS DT189208 Incorrect Output [IN] -902 reported by LOGICAL_BACKUP or LOGICAL_RESTORE when provided incorrect cloud URL DT197487 New Function [NF] Using ET or LBAR with an unrecognized production IBM Cloud Object Storage endpoint results in SQL20569N DT208663 Integrity Problems [IG] Remove temporary directories and files as part of LOGICAL_RESTORE cleanup DT209692 Abnormal End Of The Program [AB] DATABASE OUTAGE DUE TO LACK OF LOG SPACE WHEN DB2_CDE _DCC ENABLED DT212699 Coded Halt [HL] SYSPROC.SYSINSTALLOBJECTS['LBAR', 'M' ...] stored procedure unable to migrate IIAS restore history tables DT215662 Incorrect Output [IN] Online BACKUP of SMS table space can fail with deadlock due to concurrent LOAD operation DT225192 Incorrect Output [IN] Unsetting OVERFLOWLOGPATH does not disable OVERFLOWLOGPATH after next activation DT148514 Abnormal End Of The Program [AB] OUT OF LOG SPACE DURING COMMIT OR ROLLBACK WHEN REPLICATION IS ENABLED DT173106 Incorrect Output [IN] Error message from db2logts EDU DT179518 Incorrect Output [IN] Db2diag.log is flooded with message from "sqlpLLMUpdateLockWithGLMResponse, probe:3090" DT189209 New Function [NF] LBAR: Allow -drop-existing with -keep-rcac for LOGICAL_RESTORE and Fixing -keep-rcac and -replace-rcac Pre-checks DT208660 Loop [LP] Hang in LOGICAL_RESTORE Python Script When Restoring from DPF to SMP DT208662 Abnormal End Of The Program [AB] LOGICAL_RESTORE fails to restore INC/DEL backup image DT208667 Incorrect Output [IN] ADMIN_DROP_SCHEMA or LOGICAL_RESTORE fail when RCAC tables exist in schema DT214627 Incorrect Output [IN] LOGICAL_BACKUP [Schema-Level Backup] Produces Corrupted Backup Image If There are RCAC Tables in the Schema DT238513 Unpredictable [UN] Security: Db2 is affected by vulnerabilities in compression routines [zlib] DT148686 Abnormal End Of The Program [AB] IT41856: TRAP/ERROR READING FROM LOG FILES WITH ALSM ENABLED DT170181 New Function [NF] Fixes to productize Logical Backup in Db2 11.5.8 DT188273 Incorrect Output [IN] SYSIBMADM.PRIVILEGES missing SCHEMARCAC privilege DT209817 Abnormal End Of The Program [AB] DATABASE OUTAGE AFTER CRASH RECOVERY when using columnal table with intra-parallelism. DT237077 Integrity Problems [IG] Table space not set to ROLLFORWARD PENDING state when it was not accessible during crash recovery DT237938 Abnormal End Of The Program [AB] logical_backup stored procedure with -tsm option fails with SQL1797N DT130507 Errors when attempting to use UTL_DIR functions DT169944 Abnormal End Of The Program [AB] Assertion Failure "nextTSNOnPage == currTSN". Additional info: Page next TSN inconsistent with table next TSN DT236724 Incorrect Output [IN] SQL0901N 'numCurrentHWMs ~2-5 GB] DATA, AFTER LOAD COPY IMAGE FILE REPLAYED/PROCESSED, LEAD TO DATA CORRUPTION IT38511 3 ROLLFORWARD OF LOAD COPY IMAGE FROM OBJECT STORAGE CANNOT BE RECOVERED DUE TO PATH TRUNCATION IT37792 3 REMOVE DIAG MESSAGE "ROW HASH MISMATCH" WHEN LOAD ASKED TO DISCARD SUCH ROWS ON V11.5 Fix Pack m7fp0 - Data Recovery Services IT37671 1 TABLE SPACE ROLLFORWARD CAN FAIL UNDER ADVANCED LOG SPACE MANAGEMENT IT38506 1 DB2READLOG API FAILS TO RETRIEVE LOG FILE WITH SQL2657N IT38461 2 HADR STANDBY LOG FILES ACCUMULATING IN THE DATABASE LOG PATH. IT35086 2 SQL2536W DURING BACKUP IT36964 2 TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY IT38900 2 AFTER REACTIVATING A CRASHED STANDBY DATABASE, SOME READ ON STANDBY OPERATIONS MIGHT GET BACK SQL0901 IT38431 2 DB2ADUTL UPLOAD FAILS TO UPLOAD THE WHOLE RANGE OF LOGS IF ONE OF THE LOGS WAS ALREADY UPLOADED IT37382 2 TOTAL_LOG_USED INCREASE GRADUALLY TO AN UNREAL VALUE IT37021 2 SNAPSHOT BACKUP FAILED WITH SQL1550N RC 5 IT37863 3 HADR GRACEFUL TAKEOVER CAN TIMEOUT DUE TO SUSPENDED DB2AGENT PROCESSES IT36568 3 A DATABASE OUTAGE IS REQUIRED IN ORDER FOR A NEW CERTIFICATE FOR HADR WITH SSL TO TAKE EFFECT IT37926 3 LOCK ESCALATION OCCURS IN PURESCALE WHEN DB2_AVOID_LOCK_ESCALATION IS SET IT37514 3 DB2 CRASH DUE TO LOG MISSING REQUIRED BY A ROLLBACK. Fix Pack m7fp0 - Federation IT38046 1 NNSTAT MIGHT FAIL TO UPDATE NUMERIC COLUMN STATS WITH SQL1227N RC=3 IF VACHAR2 COMPATIVILITY IS ENABLED. IT37846 1 NNSTAT FAILS TO UPDATE NICKNAME'S STATICS DUE TO DIFFERENT CURRENT SCHEMA SETTING IT37965 1 THE REMOTE CHAR COLUMN LENGTH OVER 86 REPORT SQL0901 AFTER THE COLUMN LENGTH AUTO VARIATION IT37587 2 DB2 FEDERATION CAN NOT BE FORCED OFF DURING ABNORMAL SHUTDOWN OF MSSQL SOURCE SERVER IT38446 2 WHEN REMOTE DATA SOURCE IS DB2 AND THE TABLE HAS CLOB COLUMN, IT MIGHT CAUSE THE -901 INVALID NICKNAME COLUMN LENGTH ERROR IT37014 2 WITH FEDERATION USE OF A FLAT FILE FAILS IF THE FILE > 3GB IN SIZE ON WINDOWS IT38209 2 AS FEDERAION LACK OF CODEPAGE CONVERSION FOR CLOB DATA TYPE IN R EMOTE DATA SOURCE, IT WILL CAUSE -901 ERROR "REAL COLUMN LENGTH Fix Pack m7fp0 - Index Manager IT39048 1 HANG WAITING FOR SQLO_LT_SQLI_IDXCB__IDXTREELATCH WITH NO HOLDERS AFTER FAILED REORG INDEX[ES] .. RECLAIM EXTENTS IT36666 1 REORG TABLE RECLAIM EXTENTS ON INSERT TIME CLUSTERING [ITC] TABLES CAN RESULT IN FODC_INDEXERROR Fix Pack m7fp0 - Install and Catalog Services IT37423 2 INSTALLDSDRIVER -UPGRADE FAILS TO UPGRADE WHEN MOVING FROM ONE MODPACK TO ANOTHER IT37851 2 INVALID ENTRIES IN CATALOGCACHE , REMOVE INVALID ENTRIES FROM SYSCODEPROPERTIES CACHE. IT37424 2 TRAP WHEN RUNNING ADMIN_REVALIDATE_DB_OBJECTS[] IT37995 2 PURESCALE CAN NOT BE SETUP WITH DB2LOCSSH IT37836 2 IN-PLACE INSTALLFIXPACK GETS SEGMENTATION FAULT ON RHEL 8.X WITH PACEMAKER IT38186 2 APPLYING HIGH CAPACITY LICENSE ON TOP OF DB2 STANDARD OEM LICENSE DOES NOT REMOVE THE MEMORY AND CORE LIMITS. IT38027 2 32-BIT ICCSIG.TXT IS MISSING FROM DB2 11.5.6.0 UNIX [AIX, LINUX, ETC.] IMAGES Fix Pack m7fp0 - JDBC Driver IT38240 2 JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING IT38241 2 ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR IT37644 2 DURING XA TRANSACTION, WHEN XAER_RMFAIL IS RECEIVED FROM SERVER, SUCH CONNECTIONS ARE NOT ISOLATED, CLOSED AND REMOVED FROM CONN IT37216 2 JCC 4.27.25 CAUSES ABENDS IN DB2 WHILE ACCESSING BLOB DATA MORE THAN 1MB SIZE IT37215 2 SOMETIMES FEW BYTES OF DATA ARE MISSING WHEN LOB LOCATORS ARE USED FOR FETCHING DATA WHICH CONTAINS MULTI BYTE CHARACTERS IT37126 2 ARRAYINDEXOUTOFBOUNDSEXCEPTION OCCURS DURING MULTITHREADED SQLJ APPLICATION PROFILE PROCESSING. IT36131 2 UNEXPECTED ERROR SEVERITY CODE 8 ERRORCODE=-4228, SQLSTATE=NULL WHEN USING PREPARED STATEMENT WITH SETARRAY METHOD Fix Pack m7fp0 - Monitoring IT38659 2 EXECUTING ADMIN_MOVE_TABLE ON A TABLE WITH SOME KINDS OF STATEMENTS > 64KB SIZE, WILL RETURNED SQL0104N OR SQL1224N IT38013 2 ADMIN_MOVE_TABLE MIGHT FAIL WITH SQL2103N RC=16 IF RUNSTATS PROFILE CONTAINS NUM_FREQVALUES /NUM_QUANTILES IT38011 2 ADMIN_MOVE_TABLE FAILS WITH ERROR WHEN MOVING TABLE WITH USAGE LIST AND SPECIAL CHARACTERS IT37690 2 SPACE USED BY LOBS IN SOME EVENT MONITORS NOT REUSED WHEN THOSE LOBS ARE DELETED IT36891 2 MON_GET_LOCKS FAILS IN SINGLE MEMBER WITH "NO MEMORY AVAILABLE". IT38627 2 ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL WITH SQL0010N IF LOW2KEY/HIGH2KEY CONTAINING 0 BYTE IT37956 2 ADMIN_MOVE_TABLE FAILS WITH SQL0104N WHEN MOVING TABLE WITH DOUBLE QUOTES IN NAME WHICH HAS A STATISTICS PROFILE IT36731 3 ADMIN_MOVE_TABLE FAILS WITH SQL0010N - WHEN RUNSTATS STATS_PROFILE IS GREATER THAN 1024 CHARACTERS. IT36203 3 ADMIN_MOVE_TABLE WITH COPY_STATS OPTION MIGHT FAIL WITH SQL2102N RC 28 Fix Pack m7fp0 - Parsing and SQL PL IT37213 1 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR BACKUP [CVE-2021-29825] Fix Pack m7fp0 - Platform Specific IT37087 1 NX842 BACKUP AND LOG FILE COMPRESSION MIGHT FAIL IT38996 2 INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC IT38006 2 BACKUP FAILS WITH BAD PAGE ERRORS DUE TO MISMATCH BETWEEN THE PH YSICAL SIZE OF THE CONTAINER AND WHAT IS SAVED IN THE SPCS FILES IT36839 2 DB2LOGGR MAY TRAP AND SIGSEGV DUE TO OVERSHOOT BUFFERSIZE MEMORY IT38467 3 SQL1128W REASON CODE 6 MISSING FROM KC AND MRI MESSAGES Fix Pack m7fp0 - Problem Determination IT37531 2 DB2_HANG_DETECT SCRIPT MAY DETECT HANG INCORRECTLY AND KILL THE INSTANCE WITH ACTION=TERMINATE Fix Pack m7fp0 - Process Model IT38238 2 MEMORY CORRUPTION WHILE PERSISTING PLAN ACTUAL HASH TABLE TO DISK IT35720 2 PURESCALE MAY HANG WHEN THERE ARE 2 MORE CONCURRENT NODE FAILUR ES AND ONE OF THE NODE FAILURES CAUSES A DATABASE DEACTIVATION. IT38379 2 IN CERTAIN SITUATIONS, A SMALL MEMORY LEAK WILL BE OBSERVED IN SQLE_APPLICATION.C ON A DPF INSTANCE IT38716 2 IN PURESCALE, POTENTIAL DATA CORRUPTION IF NETWORKING FAILS BETWEEN MEMBERS IT37339 2 A USER INTERRUPT DURING AN IMPLICIT REBIND WHILE OPENING A CURSOR IN A STORED PROCEDURE MAY CAUSE A TRAP IT37164 2 POSSIBLE TRAP IN SQLO_SLATCH_CAS64::RELEASECONFLICT WHEN CLEANING UP FEDERATED FMP IT37196 2 IF NODE FAILURE RECOVERY OCCURS AFTER END OF TRANSACTION, THE NEXT OPERATION CAN RECEIVE SQL1229 IT37100 2 DB2STOP RESULTS IN SQL1042C AN UNEXPECTED SYSTEM ERROR OCCURRED. SQLSTATE=58004 IT37240 3 DB2CFEXP FAILS TO EXPORT SSL_CLNT_KEYDB AND SSL_CLNT_STASH DBM CFG PARAMETERS FROM A CLIENT INSTANCE IT36628 3 ZRC=0XFFFFFFFF=-1 ERROR IN DB2DIAG.LOG WHEN USING PURESCALE WITH SSL Fix Pack m7fp0 - Query Compiler Optimizer IT37511 2 POOR PERFORMANCE OF FEDERATED QUERIES IN CERTAIN CASES IT37986 2 INSTANCE CRASHED RUNNING A QUERY IT37081 2 INCONSISTENT OLAP RESULTS ON COLUMNAR TABLES IN AN MPP ENVIRONMENT IT38246 2 RUNSTATS FAILS DUE TO A DEADLOCK [SQL2310N ERROR "-911" ] ON SYSIBM.SYSCOLGROUPSCOLS WHEN COLLECTING COLUMN GROUP STATISTICS. IT36903 2 -901 ERROR WITH REASON "NO PLAN FOUND" IT35804 2 SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N. IT37540 2 SQLCODE: -901 AND FODC_TRAP: ASSERTIONFAILEDEXCEPTION: AN ASSERT ION 'MCSETEMPMAP.FIND[CSETEMPNAME] == MCSETEMPMAP.END[]' FAILED. IT38508 2 EXCESSIVE QUERY COMPILATION TIME WITH A VERY LONG SELECT DISTINCT COLUMN LIST AND VERY MANY COLUMN GROUPS IT37911 2 INNER JOIN OF AT LEAST 4 COLUMN-ORGANIZED TABLES MIGHT RETURN WRONG RESULTS UNDER SPECIFIC CONDITIONS IT37236 2 EXPLAIN_FROM_SECTION RETURNS SQL0220N FOLLOWING UPGRADE TO DB2 V11.5.5 DESPITE RUNNING DB2EXMIG IT37168 3 DB2EXFMT TRAPS WHILE PROCESSING A QUERY CONTAINING HEXADECIMAL VALUES Fix Pack m7fp0 - Query Compiler QGM DT146904 1 QUERY PERFORMANCE IS SUB-OPTIMAL WHEN SCROLLABLE CURSORS ARE USED WITH COLUMN-ORGANIZED INDEX SCANS IT38400 1 INCORRECT RESULT WHEN DB2 QUERY HAS EXISTS SUB QUERY WITH IS NULL PREDICATE IT38558 1 SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM [CVE-2021-38931] IT37556 2 GRPBY INTRODUCED IN V11.5.5.X ACCESS PLAN CAUSED SQL16003N IT38549 2 WRONG RESULT WHEN SUBSELECT WITH SCALAR AGGREGATE REFERENCED MULTIPLE TIMES IT36276 2 UNEXPECTED SQL0206N FROM FEDERATED VIEW USING WITH CLAUSE. IT38832 2 DB2 QUERY MAY PERFORM POORLY WHEN NULL PRODUCING SIDE OF OUTER JOIN IS ON BASE TABLE. IT38829 2 DB2 MIGHT ABEND WHEN RUNNING QUERIES CONTAINING CASE EXPRESSIONS AND SCALAR AGGREGATIONS IT35385 2 QUERY COULD FAIL WITH -901 WHEN MQT IS USED IT38344 2 SQL0901N ERROR CODE RETURNED WHEN CASTED MEMORY TABLE JOINING ON VARCHAR COLUMNS IT36016 2 ABSTRACT: -901 ERROR WITH REASON PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP RETURNS IN QUERY COMPILATION. IT37785 2 TRAP IN FUNCTION SQLNR_JOINPPD_COND WHEN RUNNING UPDATE STATEMENT IT36743 2 PREVENT PUSHING DOWN LARGE IN LIST PREDICATES TO UNION BRANCHES. IT37889 2 DB2 QUERY MAY ABEND OR RETURN A SQL 901 WHEN USING A CORRELATED COMMON TABLE EXPRESSION IT38399 2 WRONG RESULT WHEN DB2 QUERY HAS CORRELATED EXISTS PREDICATE IT38833 3 DB2 QUERY PLAN DOES NOT CHOOSE INDEX WHEN IN PREDICATE HAS PARAMETER MARKER. IT37626 3 ERROR SQL0102N RETURNED WHEN DB CFG VARCHAR2=ON, STMT_CONC=LITERALS AND STRING_UNITS=CODEUNITS32 IT37632 3 DB2 QUERY MAY ABEND WHEN EXPRESSION REFERENCED FROM MQT Fix Pack m7fp0 - Relational Data Services IT37102 1 APPLICATION HANG IN DPF AFTER ISSUING DDL, CANNOT BE FORCED IT37425 2 FODC TRAPS WHEN USING DPF, COLUMN ORGANIZED TABLES AND ARRAY INPUT IT36825 2 SQLTEMPSPACE OR AGGSQLTEMPSPACE THRESHOLDS DO NOT WORK WITH ROWSTORE OLAP OPERATORS THAT SPILL TO DISK. IT38229 2 LOCKTIMEOUT[VIRTUAL DEADLOCK] OCCURRED ON GLOBALPKGLOCK IT38355 2 DB2 SERVER MAY CRASH WITH SEGMENTATION FAULT IT38660 2 MEMORY CORRUPTION DETECTED IF CONNECTION CONCENTRATOR IS ENABLED Fix Pack m7fp0 - Sailfish Operational Compatibility IT37275 2 EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING. IT37266 2 EMPTY STRING INSERTED AS NULL WHEN USING QUOTEDVALUE IT37938 2 EXTERNAL TABLE CAN FAIL WHEN A LARGE INPUT FILE CONTAINS STRING DATA THAT HAS AN ESCAPED QUOTE IN THE QUOTED STRING. IT38968 2 INSERT BINARY DATA INTO EXTERNAL TABLE RETURNS ERROR SQL0901N IT38472 3 EXTERNAL TABLE FIXED FORMAT LOAD OF NEGATIVE BIG INTS FAILING Fix Pack m7fp0 - Security IT37939 4 SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE [CVE-2021-29678] IT36906 4 SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE UNDER SPECIFIC CONDITIONS [CVE-2021-29763] IT36907 4 SECURITY: IBM DB2 IS VULNERABLE TO WEAK FILE PERMISSIONS ALLOWING ACCESS TO SPECIFIC FILES [CVE-2020-4976] IT37254 4 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE [CVE-2021-29752] IT38561 4 SECURITY: INDIRECT READ ACCESS TO A TABLE THAT THE USER IS NOT AUTHORIZED TO SELECT FROM [CVE-2021-38931] IT38196 2 ADD SUPPORT FOR FIPS MODE OF OPERATION TO LINUXPPC64LE IT37032 2 IN CERTAIN SITUATIONS, AUTHORIZATION ERROR INFORMATION MAY NOT BE LOGGED TO THE DB2DIAG.LOG IT38170 2 GROUP LOOKUP FAILING FOR GROUPS THAT CONTAIN LARGE NUMBER OF USERS IT36961 2 FOR SSL CONNECTIONS ONLY, AUTHENTICATION CACHE IS NOT ABLE TO PERFORM USER OR GROUP LOOKUP IT36847 2 WHEN DB2_ALTERNATE_GROUP_LOOKUP=GETUSERATTR, A USER'S PRIMARY GROUP MAY NOT BE REPORTED BY DB2. IT35907 2 NO AUDIT OF START HADR AND STOP HADR IT38481 2 PKCS11 DRIVER MAY RETURN UNEXPECTED ERROR CODES WHEN HSM SESSION IS CLOSED IT37184 3 WHEN TRUSTED CONTEXT IS DROPPED, SETSESSIONUSER PRIVILEGES ARE ALSO DELETED Fix Pack m7fp0 - Text Search IT37498 2 TEXT SEARCH UPGRADE FROM 11.1 TO 11.5.5.1 DOES NOT UPDATE SYSIBMTS.SYSTSDEFAULTS Fix Pack m7fp0 - XML IT38624 2 ENGINE CRASH IN XMLRNNODEMGR::FETCHTEMPNODE[] Fix Pack m7fp0 - pureScale Services IT39233 2 DATABASE CREATE FAILS WITH SQL2049N RC=2 WHEN DB2_DATABASE_CF_MEMORY BEING SET TO 0 IT37578 2 NEW ENVIRONMENT VARIABLE TO TUNE WAIT TIMES BETWEEN UDAPL API CALLS [ LINUX ON IBM Z SYSTEMS ONLY ] IT39252 3 DB2HAICU -REMOTE_ENABLE MAY FAIL WHEN REMOTE HOST USES NLS MESSAGES IT36213 3 REMOVE IRRELEVANT ALERT ABOUT NETWORK INTERFACE: 'VIRBR0' WHEN USING PURESCALE ON REDHAT IT39261 3 IMPROVE ERROR MESSAGE WHEN PUTTING CLUSTER IN TO MAINTENANCE MODE WITHOUT DB2CLUSTER -ALL OPTION. IT33256 3 DB2CLUSTER -LIST -ALERT CAN FAIL TO LIST AN ALERT IN CERTAIN TRANSIENT STATES IT37136 3 SQL1659 IS NOT RETURNED EVEN WHEN A RDMA DEVICE CANNOT BE OPENED DURING DB2START, AND DB2DIAG.LOG IS SPAMMED WITH ERROR MESSAGES
DB2 Version 11.5 Fix Pack m6fp0 Known Issue Sev. Abstract IT35576 3 HADR TAKEOVER FAILED WHEN DECLARE GLOBAL TEMPORARY TABLE IS USED IN A DISTRIBUTED TRANSACTION IT37301 3 DB2 BACKUP OPERATIONS USING THE NETBACKUP [NBDB2.S064] LIBRARY WILL FAIL WITH AN SQL2079N ERROR, IN VERSION 11.1.4.4. IT37079 3 COUNT DISTINCT QUERIES AGAINST COLUMNAR ORGANIZED TABLES COULD RETURN INCORRECT RESULTS IT35926 3 WRONG RESULT WITH MULTIDIMENSIONAL CLUSTERING [MDC] TABLE AND ZIGZAG JOIN [ZZJN] IT36093 3 DB2_FMP_COMM_HEAPSZ VALUES GREATER THAN 1GB NOT HONORED IT36323 3 MEMORY BLOCK FREED TWICE IN SQLOFMBLKEX IT36128 3 ERROR -901 IN CONCATINFO.HPP ENCOUNTERED WHILE RUNNING A QUERY IT36937 3 IF ROW BEING SORTED IS VERY WIDE MEMORY OVERWRITES OR WRONG RESULTS ARE POSSIBLE. IT36948 3 RARE TRAP IS POSSIBLE DURING COLUMNAR HASH JOIN . IT33777 3 BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART['WEEK', '2020-03-09'] IT35943 3 QUERIES REFERENCING AN EXISTS SUB-QUERY WITH FETCH FIRST 1 ROW R EFERENCED IN A CASE STATEMENT IN THE SELECT LIST MAY RESULT IN I IT35891 3 WRONG RESULT MIGHT BE RETURNED WHEN SUBSTR WITH IF ELSE CLAUSES WAS USED AND THE COLUMN WAS CREATED IN CODEUNIT32 IT36753 3 IN SOME RARE CASES, A SORT ON A COLUMNAR TABLE CAN HANG IT36467 3 A TRUNCATE TABLE STATEMENT ON A COLUMN ORGANIZED TABLE WITH LOBS MAY RETURN SQLCODE -964 [TRANSACTION LOG IS FULL]. IT36572 3 FEDERATED QUERY MULTIBYTES CHARACTERS RETURNING '001A' USING THE ODBC WRAPPER Fix Pack m6fp0 - Administration Tools IT35682 2 POSSIBLE FMPTRAP IN CHECK_CREATE[] WHEN RUNNING DB2LOOK IF AN OBJECT GETS DROPPED WHILE THE TOOL IS RUNNING IT32728 2 PERIODIC TASKS THAT RUN THROUGH DB2ACD ARE NOT EXECUTED AFTER HADR FAIL OVER Fix Pack m6fp0 - Buffer Pool Services IT33546 2 QUERIES MIGHT HANG IN UOW-EXEC WAITING ON SQLO_LT_SQLB_HASH_BUCK ET_GROUP_HEADER__GROUPLATCH IN SQLBFINDPAGEINBPORSIM FUNCTION IT34100 2 REDIRECT RESTORE FAILS AFTER SET TABLESPACE CONTAINERS USING AUTOMATIC STORAGE IT33688 2 ROLLFORWARD CAN RESULT IN SQL1042C AFTER SET TABLE SPACE CONTAINERS USING AUTOMATIC STORAGE IT36166 2 DATABASES CREATED WITH "AUTOMATIC STORAGE NO" MAY CORRUPT STORAGE GROUP FILES AFTER UPGRADE IT36337 3 PREFETCHERS INFINITELY LOOPING IN SQLBSERVICELEAFREQUEST Fix Pack m6fp0 - CDE Data IT33760 1 SEGV OR PANIC WHILE DOING PARALLEL INSERTS IT36327 1 AUTO REORG..RECOMPRESS AND ONLINE BACKUP CANNOT BE RUN CONCURRENTLY IT36818 1 POSSIBLE DATA LOSS IF DELETE AND RUNSTATS/REORG ARE IN A SINGLE TRANSACTION AND THE TRANSACTION IS THEN ROLLEDBACK IT34924 2 DB2DART AND INSPECT COMMANDS FOUND ERROR TYPE VARIABLE-LENGTH DA TA AT OFFSET XXXX IS READ INCORRECTLY. THE EXPECTED OFFSET IS 0 IT36476 2 HANG DURING INSERT FROM NODES SENDING HISTOGRAMS IT35949 2 OUT OF MEMORY: SIGNAL
11 DATABASETABLEACCESSOR::DESTROYDELETEREPLICATOR IT36396 2 -901 APPERR WHEN INSERT INTO
AFTER TRUNCATE WITHOUT IMMEDIATE CLAUSE Fix Pack m6fp0 - CDE Query IT34991 2 QUERY WITH OLAP MIGHT FAIL WITH SQL0955C IN CDE IT35973 2 NESTED IN PREDICATES CAUSES -901 ERROR IT36924 2 IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N RETURNED IT36311 2 WHEN RUNNING NLJN AGAINST COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR IT32579 3 VALUE OF STATISTIC COLUMN AVGENCODEDCOLLEN IS INCORRECTLY COLLECTED DURING THE LOAD Fix Pack m6fp0 - Client Interfaces IT36757 2 CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USES IBM.DATA.DB2 .NET PROVIDER IT35180 2 BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIA ODBC IT36275 2 UNCATALOG SYSTEM ODBC DATA COURCE FAILS WITH DB21036E IT33194 2 IN CERTAIN TIMING CONDITIONS, CLI CLIENT ACR CAN FAIL TO REROUTE CONNECTIONS IT36235 2 PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINED OPTIMIZATION GUIDELINES IT34587 3 DB2TRC FMT -CLI CRASHES ON WINDOWS FOR SQLFREEHANDLE API Fix Pack m6fp0 - Codegen and Runtime IT33610 2 POSSIBLE FLOODING OF DB2DIAG.LOG FILE WITH MESSAGES FROM 'SQLNLSICUCONVERTTOMERIDIANFORMAT[]' IT37253 2 IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY IT35994 2 TRAP IN SQLNGREORDERAGGOPS WHEN ATTEMPTING TO COMPILE A JASON ARRAY IT35984 2 A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT IT36245 2 SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW IT33282 2 DB2 MIGHT SHUTDOWN WHEN HANDLING A REGULAR EXPRESSION [REGEX] IN SQLRI_REGEXP_LIKE_LONG_BODY[] WITH INVALID DATA IT34764 2 SLOW PERFORMANCE IN REGULAR EXPRESSION FUNCTIONS ON BIG ENDIAN PLATFORMS Fix Pack m6fp0 - DB2 Tools IT35061 2 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORG FROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC Fix Pack m6fp0 - DRDA Services IT36026 1 SECURITY: IBM DB2 IS VULNERABLE TO A DOS WHEN A TABLE IS DROPPED WHILE BEING ACCESSED IN ANOTHER SESSION [CVE-2021-29777] IT36201 2 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT Fix Pack m6fp0 - Data Management Services IT34966 1 SECURITY: DB2 EXTERNAL TABLE CREATION IS VULNERABLE TO RACE CONDITION ATTACK IT34964 1 SECURITY: IBM DB2 IS VULNERABLE TO AN ARBITRARY FILE OVERWRITE IT36525 1 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY IT34381 2 A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN IT35993 2 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG IT33456 2 DB2 MIGHT HANG IN PURESCALE SETUP UNDER A MEMORY CONSTRAINED SITUATION IT31723 3 LOB PAGES MAY NOT BE REUSED PROPERLY IN PURESCALE. IT35082 3 HIGH CPU AND DECREASED PERFORMANCE WITH HIGH CONCURRENCY OF INDEX CREATION [ON TEMP TABLES] Fix Pack m6fp0 - Data Management Utilities IT36770 2 IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS. IT35679 3 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT. IT34197 3 DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC Fix Pack m6fp0 - Data Recovery Services IT34889 2 DB2ADUTL DELETE LOGS WITHOUT PROMPTING" DELETES LOGS ONE BY ONE AND THEREFORE SLOWER THAN DELETING LOGS IN BATCH IT36461 2 ACTIVATE DATABASE ON ONE MEMBER IN PURESCALE HUNG WHEN ANOTHER MEMBER IS EXECUTING CREATE INDEX ON HADR PRIMARY DATABASE IT35714 2 PERFORMANCE OF DB2LOGGR MIGHT BE AFFECTED DUE TO UNNECESSARY SYMBOL RESOLUTION IN SQLPGRENAMEFILEDURINGLOGRECLAIM IT36569 2 DB2FLSN TOOL INCORRECTLY DISPLAYS "N/A" AS THE MAXIMUM LSN FOR A LOG FILE INSTEAD OF THE ACTUAL MAXIMUM LSN VALUE. IT35119 2 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED IT36140 2 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS IT36820 2 DB2ADUTL FAILS TO READ DB CONFIG ON PURESCALE OR DPF ON NODES OTHER THAN CATALOG NODE IT33960 2 SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED IT36378 2 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT. IT31624 3 REDIRECT RESTORE WITH REBUILD OPTION FAILS WITH SQL2025N IT35695 3 INCORRECT HADR_TARGET_LIST CONFIGURATION IN PURESCALE CAN RESULT IN UNEXPECTED SQL1776 RC 6 IT35161 3 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS IT37302 3 HADR TAKEOVER FAILED WITH SQL1770 RC 7 DUE TO EVENT MONITOR BLOCKS FORCING OFF ONLINE REORG ON PRIMARY IT34547 4 DIA8550C MESSAGES FILLING UP DB2DIAG.LOG WHEN LOG PATH IS MAPPED TO AN UNC PATH IN WINDOWS ENVIRONMENT Fix Pack m6fp0 - Engine Other IT36334 3 ERROR LOG MAY BE CONTINUE TO GENERATE IN HADR CONFIGURED BY PACEMAKER ON AWS. Fix Pack m6fp0 - Federation IT36252 1 ROLLBACK THE FIX OF MARIADB LENGTH[CHAR] PUSHDOWN IT36413 1 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 IT36279 1 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT [CVE-2020-4739] IT35685 1 QUERY WITH 'ORDER BY' AND REFERENCING A COMMON SUBEXPRESSION OVER COLUMN-ORGANIZED TABLES MAY RETURN ROWS IN THE WRONG ORDER IT34670 2 ACCESSING HIDDEN COLUMNS WITH FEDERATION RECEIVES SQL0206N IT36474 2 WILD POINTER REQUEST->AGT_RUNTIME_OBJ IN SQLQG_SIGNAL_HANDLER LEADS TO DATABASE CRASH IT33184 2 THE MARIADB COLUMN LENGHT IS OVER 32K, BUT THE IMPORT FILE ONLY HAS 32768 CHARACTERS. IT33052 2 WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N. JR63711 2 DV ISSUE: PUSHDOWN ISSUE FOR DB2 AND ORACLE JDBC WRAPPER IT36387 2 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES IT34402 2 FEDERATION MARIADB CURRENT TIMESTAMP "GETTING PARAMETER TYPE METADATA ARE NOT SUPPORTED" ERROR SQL1822 IT33183 2 FEDERATION SERVER ODBC WRAPPER FETCHES KOREAN CHARACTERS FROM MARIADB, BUT RETURNS UNREADABLE TEXT. IT36380 2 GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER IT36199 2 POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INF O[] WHEN RUNNING FEDERATED QUERY IT35805 2 MULTI-THREADED DB2FMP TRAPPED IN SYBASE CALLS INTERMITTENTLY Fix Pack m6fp0 - Index Manager IT36812 2 INSTANCE MAY CRASH WITH SQLIDUMPINXCURSOR ON THE STACK WHEN DUMPING FODC DIAGNOSTICS [-901 OR TRAP] IT36449 2 DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR. IT36256 3 DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR Fix Pack m6fp0 - Install and Catalog Services IT36454 2 SQL0901N - INVALID FEDERATED THREE PART NAME IJ21543 2 DB2PREREQCHECK SHOULD NOT CHECK MODPROBE FILE WHEN USING MELLANOX CX-4 IB/ROCE CARD ON LINUX PLATFORM IT25907 2 -P PARAMETER IS BEING IGNORED BY DB2ICRT IT34619 2 ENHANCEMENT: SETUP.EXE CHECKS CURRENT DIRECTORY NAME WHETHER IT HAS SPACE[S] OR NOT ON WINDOWS IT35734 2 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING IT36376 2 EXPORT RETURNS SQL0204N "SYSTEM.SYSCAT.FUNCTIONS" IS UNDEFINED. IT33815 3 REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR IT34188 3 DB2LOOK CREATEDB OR PRINTDBCFG PARAMETERS DON'T REPORT THE ACURATE VALUE IN DB2LOOK FOR STRING_UNITS . IT36468 3 REPLAY OF REVOKE ON HADR STANDBY WITH READS ON STANDBY ENABLED MAY RESULT IN A SMALL MEMORY LEAK IT31631 3 CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT [CREATE INSTANCE] IT34384 4 DB2PREREQCHECK CHECKS FOR JAVA, BUT WE BUNDLE JAVA WITH DB2 Fix Pack m6fp0 - Monitoring IT36150 2 ADMIN_MOVE_TABLE CANNOT BE USED TO MOVE TABLE HAVING DOUBLE QUOTES IN NAME IT36521 2 SQL405N REPORTED BY DB_MEMBERS AND DB_PARTITIONS TABLE FUNCTIONS IF NETNAME EXCEEDS 128 CHARACTERS IN DB2NODES.CFG IT34510 3 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION Fix Pack m6fp0 - Parsing and SQL PL IT30559 2 DB2 MAY ABEND WHILE COMPILING COMPOUND SQL [COMPILED] STATEMENTS Fix Pack m6fp0 - Platform Specific IT33313 2 "DB2" FRONT END PROCESS DOES AN UNNECESSARY INTERNAL INITIALIZATION WHICH MIGHT CAUSE A PERFORMANCE DEGRADATION IT36041 3 ALTER TABLESPACE WITH NO FILE SYSTEM CACHING OPTION FAILS ON LINUX390 IT35710 3 INTERMITTENT FAST PREALLOCATION FAILURES ON AIX Fix Pack m6fp0 - Problem Determination IT36266 2 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS IT34869 2 DB2PD -DBPTNMEM CAN CRASH IF USING USING MEMBER NUMBERS GREATER THAN 9 IT35318 2 LARGE PRIVATE MEMORY LEAK WHEN PD_GET_DIAG_HIST IS INTERRUPTED PROCESSING A LARGE DB2DIAG.LOG OR NOTIFY FILE IT37300 3 NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT Fix Pack m6fp0 - Process Model IT36331 1 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND IT36504 2 WHEN THE DBNAME DOES NOT MATCH THE DBALIAS HADR FAILS TO START ON THE PRIMARY IT35376 2 DB2 MIGHT CAUSE EXCESSIVE LOGGING [SQL0952N MESSAGES] WHEN A QUERY IS INTERRUPTED. IT36821 2 SET EVENT MONITOR STATE STATEMENTS MAY BE INCORRECTLY QUEUED BY THE ADAPTIVE WORKLOAD MANAGER IT36833 2 OCCURS ON PARTITIONED DATABASE, DB2 MAY CRASH WHEN TRYING TO UNLATCH A LATCH THAT IS NOT HELD IT33580 2 INCORRECT ESTIMATION OF PARTITIONS WHERE QUERY MAY EXECUTE MAY CAUSE EXCESSIVE QUEUING WITH THE ADAPTIVE WORKLOAD MANAGER IT36862 2 POSSIBLE 15 SECOND DELAY IN SQLEPEEKREQUEST IT33410 2 SQL1041 DB2 NOT FOLLOWING NUMDB SETTING IT34227 3 ADMIN_CMD AND GET_DB_CONFIG CANNOT HANDLE EXTENDED NUMBER RANGE OF LOGBUFSZ IT35832 3 SQLCODE -1229 CONTINOUSLY WRITTEN IN DB2DIAG.LOG AFTER NODE FAILURE IT36113 3 V11.5.5 ONLY: DB2ADUTL COMMAND FAILS WITH SQL1031N IN PURESCALE ON ALL MEMBERS EXCEPT MEMBER 0. Fix Pack m6fp0 - Query Compiler Optimizer IT36104 1 DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION IT35953 1 INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP IT34668 1 INSERT INTO COLUMN-ORGANIZED TABLE FROM COMPLEX SUBSELECT CAN TRAP DURING QUERY OPTIMIZATION IT34102 2 CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY LEAD TO A TRAP IT35309 2 DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 REASON CODE "CONSTANT OF UNSUPPORTED TYPE" IT35997 2 SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR Fix Pack m6fp0 - Query Compiler QGM IT34871 2 USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH IT35066 2 LPAD OR RPAD BUILTIN FUNCTION FAIL WITH -901 "VALUE IS TOO LARGE FOR THE BUFFER" IT35055 2 DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE IT36401 2 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK IT34347 2 MONTHS_BETWEEN FUNCTION IN NPS MODE RETURN NEGATIVE IT33192 2 DB2 QUERY MAY ABEND WHEN THERE ARE COMMON TABLE EXPRESSION USED IN UNION IT36384 2 UPDATE STATEMENT WITH IN/EXISTS MAY GENERATE SQLCODE -913 IT36742 2 SQL0901N WHEN DB2 QUERY HAS CDE TABLE AND JOIN PREDICATE HAS TYPE MISMATCH IT35085 2 DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE" IT36106 2 SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN IT35059 2 LPAD, RPAD OR REPLACE MAY RESULT IN SQLCODE -901 WHEN SOURCE-STRING REFERENCES A COLUMN-ORGANIZED TABLE COLUMN IT30018 2 DB2 MAY RUN OUT OF STATEMENT HEAP WHILE COMPILING QUERIES INVOLVING UNIONS AND PREDICATES WITH WEAK UDTS IT36441 3 DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR IT36498 3 DB2 MAY RETURN -901 WHEN IMPLICITLY CASTING NON-STRING TO A STRING AND THE ENVIRONMENT DEFAULT STRING UNITS ARE CODEUNITS32. IT35058 3 SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS IT36473 3 TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS IT36320 3 QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS IT35062 3 CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE IT36388 3 UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES IT33287 3 WRONG RESULT/901 WHEN IN USED ON SELECT Fix Pack m6fp0 - Relational Data Services IT36046 2 PANIC MAY OCCUR IN HADR TAKEOVER IT36853 2 DB2AGENT REPORTED SQLD_PARM ERROR WHEN TRUYING TO FIND/FIX TCB WITH OBJECTID=0 IT35518 2 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE IT34418 2 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED IT32552 2 MULTIPLE SEVERE/INFO MESSAGES WITH -803 COULD BE RECORDED IN DB2DIAG.LOG AND MAY AFFECT PERFORMANCE Fix Pack m6fp0 - Sailfish Operational Compatibility IT36751 1 EXTERNAL TABLES WITH LFINSTRING OPTION MAY FAIL IF DATA CONTAINS A FIELD INCLUDING A NON ESCAPED DELIMITER CHARACTER IT35075 2 SELECTING FROM AN EXTERNAL TABLE THAT USES LFINSTRING ON CAN FAIL WITH SQL5199N Fix Pack m6fp0 - Security IT36475 1 SECURITY: IBM DB2 IS VULNERABLE TO AN INFO. DISC. FOR USERS WHO CREATE AN INLINE SQL FUNC. WHEN AUTO_REVAL SET TO DEFFERED_FORC IT40980 2 Security: IBM Db2 may be impacted by a Denial of Service IT36418 2 LDAP PLUGIN NOW ALLOWS CONFIGURATION TO CHECK LDAP PASSWORDPOLICYRESPONSE IT36177 2 WHEN USING GSSPLUGIN IBMIAMAUTH.SO CRASHES DB2 Fix Pack m6fp0 - pureScale Services IT36431 2 DB2CLUSTER -VERIFY FAILURE DUE LATE SERVER STARTUP IJ27796 2 "LIST INDOUBT TRANSACTIONS" COMMAND PERFORMANCE IMPROVEMENT WITH PURESCALE. IT29557 2 MORE ROBUST CLEANUP STATUS CHECKING IT35801 2 MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE H ADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. THIS SHO IT37103 2 PURESCALE DELETE ROWS PERFORMANCE REGRESSION ON RDMA NETWORKS IT35828 3 "DB2CLUSTER -CFS -SET -OPTION CCRENABLED -VALUE NO" COMMAND TIMES OUT IT36816 3 DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2 IT36894 3 "TOO MANY ARGUMENTS" MESSAGE WHEN RUNNING DB2CM -CREATE -DB IN HADR WITH PACEMAKER WITH MULTIPLE STANDBY SETUP IT36393 3 CIB ATTRIBUTE FAILED TO SET DURING PRIMARY REBOOT IT36457 4 AFTER A REBOOT, HADR DATABASE MAY FAIL TO BE ACTIVATED BY AUTOMATION. DB2 Version 11.5 Fix Pack m5fp1 Known Issue Sev. Abstract IT34838 2 LEFT FUNCTION CAN NOT BE PUSHED DOWN IT35883 3 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE IT34960 3 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS. IT32664 3 XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN IT35798 3 SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN IT34748 3 UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS. IT35017 3 CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERRENCING NULL POINTER IT35185 3 DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURINGEXECUTION OF THE MON_GET TABLE FUNCTION IT35705 3 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE IT35439 3 DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THE EXPECTED RESULT IT36027 3 IMPROVEMENTS TO CDE JOIN MEMORY USEAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS. IT33529 3 PRESENCE OF CANDIDATE ACCESS PLAN WITH SINGLE-NODE HASH-DIRECTED PARTITIONING PREVENTS OPTIMAL PLAN WITH REPARTITIONED JOIN IT35680 3 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR IT34693 3 DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS IT34396 3 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING IT34242 3 BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION IT35833 3 SQL1585N IS INCORRECTLY RETURNED FOR CERTAIN TYPES OF QUERIES IT34658 3 DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS IT35047 3 MGB:STORED PROCEDURE CALLS PERFORMANCE ARE SIGNIFICANTLY WORSE AFTER MIGRATION IT34559 3 ELEMENT ALLOCATION ISSUE, AND ONE OF THE VECTORS WAS MESSED UP AND CAUSE TRAP/SEGFAULT. IT31536 3 MON_GET_LOCKS FAILS IN DPF WITH SQL1607N BECAUSE OF UNDERLYING RPC MECHANISM BEING LIMITED TO 2 GIGABYTES IT34108 3 NLJN NOT PUSHING DOWN IT35033 3 CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK IT35728 3 SQL0407N WHEN COMMON SUBQUERY HAS VALUES IT35548 3 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL IT35739 3 DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY. JR62967 3 DB2 V11.5 QUERY PLAN WITH "UNION ALL" IS DIFFERENT FROM QUERY PLANS IN V11.1 IT35880 3 DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED IT35992 3 SQL0811N WHEN THERE IS SCALAR SUBQUERY WITH FETCH FIRST 1 ROWS IT36210 3 IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE. IT35399 3 FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS Fix Pack m5fp1 - Abstract Data Types and Spatial Extender IT35444 2 MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS Fix Pack m5fp1 - Buffer Pool Services IT33994 2 DB2 MAY HANG SHORTLY AFTER COMMITTING A CREATE TABLE WITH AN AGE NT WAITING FOR SQLO_LT_SQLD_TCB__LOADINPROGRESS LATCH IN SQLBFIX IT36108 2 INTERRUPTING ALTER TABLESPACE REDUCE MAY CAUSE A MEMBER SHUTDOWN Fix Pack m5fp1 - CDE Data IT35182 2 CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS [ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY]. IT34037 2 DEADLATCH BETWEEN ONE THREAD WRITING A DICTIONARY TO DISK USING VECTORIZEDADC AND ANOTHER THREAD DOING A NEW EXTENT ALLOCATION Fix Pack m5fp1 - CDE Query IT35163 1 DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE IT36230 2 DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO IT35211 2 POSSIBLE SIGSEGV IN Q REPLICATION DUE TO INCORRECT LOG RECORDS FOR COLUMN-ORGANIZED DGTT IN DPF ENVIRONMENT IT35158 2 REDUCE LIKELYHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS Fix Pack m5fp1 - Client Interfaces IT35521 1 CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS IT34606 2 USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT IT34589 2 ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO IT35405 3 CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA > ?GET EXTERNAL DATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5 Fix Pack m5fp1 - Codegen and Runtime IT35377 2 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATKnown IssueT TABLE ON THE INNER AND NULL KEYS. IT35486 2 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG. JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT. IT34579 3 DB2 BACKUP OPERATIONS USING THE NETBACKUP [NBDB2.S064] LIBRARY FAIL WITH SQL2079N ERROR Fix Pack m5fp1 - Communication IT35289 1 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND [CVE-2020-5024] IT34882 2 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL IT34504 2 GSKKM_STORECACERT: GSKIT ERROR = 100 ERRORS IN DB2DIAG.LOG Fix Pack m5fp1 - DRDA Services IT35750 2 THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSL INTO ACCOUNT. IT34432 2 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL Fix Pack m5fp1 - Data Management Services IT34294 1 SECURITY: IBM® DB2® IS VULNERABLE TO A DENIAL OF SERVICE ON WINDOWS [CVE-2020-4642] Fix Pack m5fp1 - Data Management Utilities IT35936 2 DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATKnown IssueT FUNCTION IT35965 3 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN Fix Pack m5fp1 - Engine Other IT35987 2 "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURED IN 32 BIT MODE. Fix Pack m5fp1 - Federation IT33598 2 INSERT STATEMENT FAILS WITH -901 ERROR USING FEDERATION IT35968 2 WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N IT34588 2 SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER [VARIABLE] VIA JDBC IT35226 2 CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES [AS400] FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED JR62802 2 PROBLEM RUNNING UPDATE ON MARIADB [FEDERATION] IT34941 2 QUERY ON NICKNAME RESULTS WITH VALUES TRUNCATED ON MARIADB IT34862 2 DB2 CRASH DUE TO A -901 WAS RAISED BY MINMAXPARTIALEVALUATOR.CPP WHEN MAX[TO_CHAR[]] OR MIN[TO_CHAR[]] EXISTS IN THE SELECT LIST Fix Pack m5fp1 - Install and Catalog Services IT35672 2 UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME IT33810 2 INVALID LICENSE ERROR USING DB2 CONNECT LICENSE WITH .NET CLI DRIVER ON OPENSHIFT CONTAINER Fix Pack m5fp1 - Platform Specific IT34929 2 ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH Fix Pack m5fp1 - Problem Determination IT33783 2 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H [TIME PERIOD SPECIFIERS] Fix Pack m5fp1 - Process Model IT34261 1 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND Fix Pack m5fp1 - Query Compiler Optimizer IT35198 1 A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED IT35183 2 POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT. Fix Pack m5fp1 - Query Compiler QGM IT34950 1 DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROM INVALID VIEWS IT34758 2 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR IT35670 2 REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAY RESULT IN -901 IT34613 2 INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED' IT35925 2 DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLE WHEN COISBAR IS ENABLED IT34311 2 QUERY WITH ALIAS FOR COMPLEX COLUMN USED IN GROUP BY CLAUSE TRAPS AND GENERATES FODC IT34860 2 DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN IT34304 2 SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 OR SYSIBM.DUAL IT34222 3 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE IT34940 3 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE. Fix Pack m5fp1 - Relational Data Services IT33355 2 DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE. IT35546 2 -901 SQLCODE DURING REBIND FOR PACKAGES BOUND WITH CERTAIN BIND OPTIONS IT34671 2 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK IT33429 2 SQL1598N MIGHT BE RAISED IF A LICENSE WAS NOT APPLIED BEFORE SIMULTANEOUS ATTEMPTS TO CONNECT THROUGH THE DATA SERVER DRIVER IT35221 2 WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HIST ORY FOR SHORT QUERIES. THIS CAN LEAD TO UNNECESSARY QUEUING OF V Fix Pack m5fp1 - Sailfish Operational Compatibility IT35770 2 OOM HIT WHILE RUNNING ET NZ INTERNAL FORMAT MIGRATION. IT35855 2 MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT IT35165 2 DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE. Fix Pack m5fp1 - Security IT35445 1 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS [CVE-2020-4976] IT36060 2 IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWT AUTHENTICATION IS ENABLED IT36085 2 DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION Fix Pack m5fp1 - pureScale Services IT36088 1 DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT IT36086 1 DB2CLUSTER -VERIFY POTENTIAL HANG IT35303 1 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW [CVE-2020-5025] IT35552 2 CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE IT35558 2 SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS IT35662 2 CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX
DB2 Version 11.5 Fix Pack m5fp0 Known Issue Sev. Abstract Fix Pack m5fp0 - 1 IT34866 3 IT34866: ADDITIONAL FIX TO Known Issue IT13674, TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT IT33863 3 PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLAT CH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR IT33576 3 REDUCE CHANCE OF SQL0289N IT33525 3 INACCURATE RESULT OF DECIMAL DIVISION ON NON-AIX PLATFORM Fix Pack m5fp0 - Administration Tools IT34534 3 DB2 ADMINISTRATIVE TASK SCHEDULER STOPS EXECUTING SCHEDULED TASKS Fix Pack m5fp0 - Buffer Pool Services IT34560 2 DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR Fix Pack m5fp0 - CDE Data IT33714 1 RUNNING REPLICATED CDE WORKLOAD WITH INVALID DB2_DCC_FILE_PATH VALUE WILL CAUSE DB2 TO FAIL WITH SQL1224. IT33570 2 A CDE UPDATE STATEMENT MIGHT FAIL WITH SQL0901N '!ISROWLOGBUFFERINITIALIZED[]' AND TRAP IN SQERDFSROWSERIALIZER IT34280 2 CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP' IT34500 2 REORG RECLAIM CODE CAN LEAD TO DEADLATCH IT33707 2 FODC_FORCEDBSHUTDOWN OCCURS AFTER AN INSERT STATEMENT IS INTERRUPTED AND ATTEMPTS TO ROLL BACK. Fix Pack m5fp0 - CDE Query IT34026 2 INSTANCE COULD GO DOWN WHEN DOING A FULL OUTER JOIN ON TWO COLUMNAR ORGANIZED TABLES WITH NULL COLUMNS IT34235 2 IMPROVE PERFORMANCE BY IMPLEMENTING SCALAR FUNCTIONS DAYOFMONTH, DAYS_TO_END_OF_MONTH IN COLUMNAR ORGANIZED LOGIC. IT34147 2 VARIOUS ERROR POSSIBLE: SQL0901N , SQL0955N IT33467 2 CDE HSJN WITH RESIDUAL PREDICATES THAT HAVE SCALAR FUNCTION APPL IED TO A HOST VARIABLE OR REGISTRY VARIABLE COULD FAIL WITH -901 IT33293 2 QUERY FAILING WITH SQL0901N AND AN ASSERTION FAILURE "UNABLE TO ACCESS TARGET PAGE FROM PAGE MAP" Fix Pack m5fp0 - Client Interfaces IT33902 2 INTERMITTENT FAILURE WITH CLR_EXCEPTION_SYSTEM.OBJECTDISPOSEDEXCEPTION IT31498 3 SQL2731N WHEN AN INPUT FILE SIZE OF ZLOAD IS BIGGER THAN 4GB IT32956 3 DB2 .NET PROVIDER WITH DOUBLE HYPHENS [] STYLE COMMENT IN SQL STATEMENT HAVING NAMED PARAMETERS THROWS SQL0206N IT32276 3 NO SQL OVERFLOW ERROR WHEN INSERTING A DECIMAL[20,4] THAT DOES NOT FIT INTO A SMALLINT OR INTEGER COLUMN IT33640 3 IBM DATA SERVER ADD-INS FOR VISUAL STUDIO [VSAI] DOES NOT SHOW NON-TABLE SCHEMAS Fix Pack m5fp0 - Codegen and Runtime IT33578 2 OPTIMIZE THE PERCENTILE_CONT AGGREGATE FUNCTION TO USE MEMORY MORE EFFICIENTLY AND SPILL TO TEMP IF REQUIRED IT33236 2 COMPLEX QUERIES WITH EXISTS CLAUSE ON A COLUMNAR TABLE EXECUTED WITH DEGREE GREATER THAN 1 MAY HANG Fix Pack m5fp0 - Data Recovery Services IT32894 1 DB2 : SET WRITE RESUME COMMAND HANGS IT34022 2 DB2 MIGHT TRAP WHEN EXECUTING MON_GET_UNIT_OF_WORK IT33533 3 SQL0913 RC=80 NOT BEING CAPTURED BY DB2PDCFG -CATCH LOCKTIMEOUT IT32560 3 ILOGS ARE ARCHIVED TO BOTH LOG ARCHIVING METHODS ONLY FROM THE ACTIVE LOG PATH WITH DUAL LOGGING ENABLED Fix Pack m5fp0 - Federation IT32523 1 PRIVATE MEMORY LEAK DURING DDL ON COLUMN-ORGANIZED TABLES IN DPF ENVIRONMENT JR62529 2 QUERIES ON NICKNAMES TO TABLE ON MARIADB RETRIEVES ONLY FIRST CHARACTER OF COLUMN NAMES JR62557 2 FEDEATION MARIADB JDBC: DATA TYPE MAPPING ERROR JR62556 2 INSERT INTO SELECT ERROR ON JDBC Fix Pack m5fp0 - Index Manager IT31287 1 DB2 MAY TRAP WHEN USING SELECT RID_BIT[] FUNCTION ON A COLUMN ORGANIZED TABLE Fix Pack m5fp0 - Install and Catalog Services IT33705 1 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES IT32984 1 SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE [CVE-2020-4411] IT32939 1 SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE [CVE-2020-4412] IT34221 1 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT IT33708 2 DB2ICRT FAILS WHEN CHECKING GPFS ON PURESCALE IT33515 2 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES IT34039 2 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. IT32679 2 ROUTINE MIGRATION FAILS WITH A SQL0478N WHEN A ROUTINE IS USED AS PART OF A TABLE DEFINITION IT33548 2 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES IT33712 3 COMPLETE FIX FOR IT13674 IT33312 3 DB2ICRT AND DB2PREQCHECK FREE SPACE AND HOST FAILURE Fix Pack m5fp0 - JDBC Driver IT32581 3 CLPPLUS 11.5 CLIENT THROWS EXCEPTION SQL20570N WITH EXTERNAL TABLE OPERATION HAVING EMPTY FILE WITH GZIP COMPRESSION IT33041 3 JCC DRIVER NOT SENDING COMMIT AFTER THE LICENSE SP CALL EVEN IF AUTOCOMMIT IS TRUE IT33602 2 INSERT FROM EXTERNAL TABLE FAILS WITH SQLCODE -4499 -T2LUW Fix Pack m5fp0 - Monitoring IT34023 2 FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINE EXECUTION LIST MONITORING IS ENABLED. IT33264 3 CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N Fix Pack m5fp0 - Parsing and SQL PL IT34440 2 ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE IT33885 3 DB2 MAY ATTEMPT TO REPEATEDLY OPEN A NON-EXISTENT FILE WHICH MAY IMPACT QUERY COMPILATION PERFORMANCE Fix Pack m5fp0 - Platform Specific IT34140 1 SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED IT34101 3 FMP PROCESS CAN HANG IN NESTED SIGNAL HANDLER CODE PATH Fix Pack m5fp0 - Problem Determination IT33783 2 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H [TIME PERIOD SPECIFIERS] Fix Pack m5fp0 - Process Model IT33508 1 IN DPF ENV, SORTSHRHEAPUTIL THRESHOLD MAY NOT TRIGGER PREDICTIVELY FOR QUERIES USING SORT MEMORY ON DATA NODES IT34607 2 DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS. IT33186 2 LOCK-WAIT ON DECOUPLED DB2ADCBLD IT34257 2 DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE IT34284 2 SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM IT33826 2 LIST STORAGE ACCESS COMMAND GIVES 0 ENTRIES EVEN IF THE CATALOG STORAGE ACCESS COMPLETED SUCCESSFULLY Fix Pack m5fp0 - Quality Assurance IT34614 4 SECURITY: MULTIPLE BUFFER OVERFLOW VULNERABILITIES AFFECT DB2 Fix Pack m5fp0 - Query Compiler Optimizer IT33554 2 SQL0901N PARTITIONED BLU SORT WITH 0 PARTCOLS IS UNEXPECTED IT34007 2 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE. IT33338 2 COLUMNAR SEARCHED UPDATE AND DELETE STATEMENTS EXECUTING WITH HS JOIN THAT APPLIES RESIDUAL PREDICATES MIGHT FAIL WITH SQL0901N " Fix Pack m5fp0 - Query Compiler QGM IT32992 1 WRONG RESULT, WHEN OPTIMIZATION LEVEL IS LESS THAN 5 AND NULL EQUALS NULL PREDICATE IT34308 2 REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS IT33171 2 WRONG RESULT WHEN QUERY HAS SCALAR SUBQUERY AND FETCH FIRST 1 ROW IT34382 2 POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION IT33459 2 FIX ISSUES WITH OPTIMIZER VERSION CONTROL [DB2_OPTIMIZER_VERSION REGISTRY VARIABLE] IT33527 2 POOR PERFORMANCE OF DB2 QUERY HAVING IN SUBQUERY PREDICATE IT34115 2 INCORRECT QUERY OPTIMIZATIONS RESULTING IN POOR PERFORMANCE OCCUR WHEN STATEMENT CONCENTRATION IS ENABLED IT32923 2 DB2 MAY ABEND WHEN COLUMN ALIAS USED IN PREDICATE. IT33870 2 SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN IT32640 2 QUERY FAILS WITH SQL0901 "NO CAST FUNCTION" WHEN DB2_ENABLE_MULTIPLE_CCSIDS=TRUE, DATABASE IS UNICODE IT33577 2 PERFORMANCE: NEQN [I.E. NULL EQ NULL] PREDICATES NOT DETECTED BY MAGIC DECORRELATION IT34078 2 DB2 MAY NOT GENERATE TRAILING SPACE AFTER GROUP BY IT33822 2 HANG IN WHERE ALIAS DUE TO CYCLIC REFERENCE. IT34222 3 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE IT33557 3 USING "ISNOTTRUE" OR "ISNOTFALSE" ROUTINES WITH DECFLOAT DATA TYPE RETURNS SQL0440N IT33871 3 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE Fix Pack m5fp0 - Relational Data Services IT33691 1 ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT IT34110 2 -901 SQLCODE [CANNOT FIND CURSOR INFO IN ERT] FOLLOWED BY TRAP Fix Pack m5fp0 - Routine Infrastructure IT34156 2 ALLOW FMP POOLING FOR SPECIFIC USER IDS Fix Pack m5fp0 - Sailfish Operational Compatibility IT34151 2 USING PIPE INTERFACE DURING UNLOAD OPERATION IF PIPE IS USED IT33740 2 CREATE EXTERNAL TABLE USING SAMEAS/LIKE WITH BASE TABLE HAVING HIDDEN COLUMN IS GETTING CREATED WITH HIDDEN COLUMN IT33615 2 SQL20570N WHILE LOADING EMPTY FILE USING OPTION REMOTESOURCE GZIP SAME WORKS FINE WITH LZ4 IT34356 2 FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH Fix Pack m5fp0 - Security IT34107 2 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLE AND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES Fix Pack m5fp0 - pureScale Services IT33790 3 DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST. IT33851 3 TSA INITIATED TAKEOVER IN AN AUTOMATED HADR ENVIRONMENT MAY FAIL DUE TO PEER WINDOW HAVING EXPIRED.
DB2 Version 11.5 Fix Pack m4fp0 Known Issue Sev. Abstract Fix Pack m4fp0 - Buffer Pool Services IT32436 2 HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR Fix Pack m4fp0 - CDE Data IT30387 1 DB2 MIGHT HANG WITH AN EDU WAITING ON SQLO_LT_SQLD_CHAIN__FULLCH AINLATCHNS WHILST HOLDING SQLO_LT_SQELOCALDATABASE__DBLATCH IT33198 2 IN DB2 V11.5 GA, SQL0901N ERROR MAY OCCUR WITH DB2DIAG.LOG SQLER RMC "UNEXPECTED ERROR AT SYNOPSISTABLETUPLEACCUMULATOR.HPP:130" Fix Pack m4fp0 - CDE Query IT32589 1 CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON IT31975 2 SELECT WITH SUBSTRING[] RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN IJ24133 2 WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. Fix Pack m4fp0 - CLI IV98044 2 NEW MONGODB CLIENTS ARE UNABLE TO CONNECT TO IBM JSON WIRE LISTENER IT31045 3 BULKCOPY ERROR WHILE CHAIN INITIALIZATION WITH NULL VALUE FOR DECIMAL COLUMNS IT33421 2 SQLGETCONNECTATTR[] FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBER_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME IT30451 2 NOT ABLE TO LOAD AND USE THE DB2CLIO.DLL IT33461 3 ERROR ENCOUNTERED WHILE FETCHING SMALLINT DATA USING IBM DATASERVER PROVIDER FOR ENTITY FRAMEWORK CORE Fix Pack m4fp0 - Codegen and Runtime IT32599 2 QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW IT32367 2 SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB Fix Pack m4fp0 - Communication IT32766 1 SECURITY - DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK IT32357 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION Fix Pack m4fp0 - DRDA Services IT32363 2 SECURITY: IBM® DB2® LUW IS VULNERABLE TO A DENIAL OF SERVICE ATTACK Fix Pack m4fp0 - Data Management Services IT33146 1 DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. IT33218 1 DB2 SERVER TERMINATES ABNORMALLY IN THE SQLDFETCHLARGEROW FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. IT30494 2 CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY Fix Pack m4fp0 - Data Recovery Services IT33172 3 SLOW DATABASE RECOVERY LOG REPLAY ON A WORKLOAD WITH MANY DDLS SPECIFICALLY CREATE / ALTER / TRUNCATE / DROP TABLE Fix Pack m4fp0 - Federation IT31455 3 CREATE SERVER COMMAND IS FAILED IN SQL1816N WHEN DB2/LUW IS SPECIFIED IN V11.5 Fix Pack m4fp0 - Install and Catalog Services IT31637 1 SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS [CVE-2020-4204] IT29745 1 IN A PURESCALE ENVIRONMENT, DB2IUPDT COMMAND FAILS ON RHEL 7.6 AS IT CHECKS FOR AN OBSOLETE PACKAGE [LIBIBCM] IT32256 2 DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY IT31741 2 DB2PREREQCHECK FILLS UP / AND /TMP DUE TO SCP TSAMP WITH UNNECES SARY FILES DURING PURESCALE INSTALLATION OR DB2IUPDT COMMAND IT31588 3 WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID IT32751 2 HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE Fix Pack m4fp0 - JDBC Driver IT30972 2 JDBC DRIVER NOT TERMINATING TIMER THREADS WITH VERSION 4.26.14 IT29195 2 CLPPLUS DOES NOT RUN THE LOGIN.SQL SCRIPT DURING STARTUP. IT32580 2 INTRODUCED A NEW PROPERTY USEJDBC4DATATYPE IN JCC DRIVER AS IT IS NOT BACKWARD COMPATIBLE FOR CLOB/CHAR/VARCHAR DATA TYPE. IT31612 3 PIGGYBACK COMMANDS ARE NOT REPLAYED IF FAILURE HAPPENS DURING FIRST SQL EXECUTION IN CASE OF NON-SEAMLESS FAILOVER IT33042 2 DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION Fix Pack m4fp0 - Monitoring IT31573 2 DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. Fix Pack m4fp0 - Platform Specific IT31007 2 DT159865: MULTIPLE CLP FRONTENDS ISSUED FROM DIFFERENT SHELL SCRIPTS USES THE SAME BACKEND AGENT, CAUSING UNEXPECTED RESULTS OR ERRORS. IT31704 2 MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES IT32507 3 ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID[] Fix Pack m4fp0 - Problem Determination IT32716 1 SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE AND DENIAL OF SERVICE IT32689 1 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE IT32714 1 SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE Fix Pack m4fp0 - Process Model IT32439 1 INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES IT31679 3 DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH IT31378 2 DB2STOP FAILS WITH SQL6037N, LEAVING [DB2SYSC] Fix Pack m4fp0 - Query Compiler Optimizer IT32195 2 IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS Fix Pack m4fp0 - Query Compiler QGM IT31167 2 SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT IT31557 2 SQL1224N AFTER CERTAIN OUTER JOIN QUERIES IT32731 2 DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION IT28109 2 INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? IT32612 2 -901 ERROR IS HAPPENED[BAD PLAN; UNRESOLVED QNC FOUND] WHEN EXECUTING PACKAGE REBIND IN V11.5. IT31862 2 TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE IT31634 2 WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. Fix Pack m4fp0 - Relational Data Services IT31701 1 APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS Fix Pack m4fp0 - Routine Infrastructure IT32126 2 MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO Fix Pack m4fp0 - Sailfish Operational Compatibility IT32568 2 FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH Fix Pack m4fp0 - Text Search IT31755 2 THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 Fix Pack m4fp0 - pureScale Services IT31054 3 EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" IT31454 3 EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" IT40847 2 DT147376: ENDLESS ITERATION OF DB2 CLEANUP AND KILL PROCESSES MAKE DB2 PURESCALE CLUSTER HANG
DB2 Version 11.5 Fix Pack m3fp0 Known Issue Sev. Abstract Fix Pack m3fp0 - Buffer Pool Services IT31892 1 CRASH RECOVERY CAN FAIL AFTER INCORRECTLY REPLAYING EXTENT MOVEMENT LOG RECORDS WITH LARGE RECOVERY WINDOW IT32436 2 HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR Fix Pack m3fp0 - CDE Data IT31385 3 INCORRECT CALCULATION OF COLUMNAR-ORGANIZED TABLE SPACE CONSUMPTION IN TBPSIZE_ENTITLEMENT_REQ.SQL Fix Pack m3fp0 - CDE Query IT32589 1 CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON IT31975 2 SELECT WITH SUBSTRING[] RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN IT31628 2 SQL STATEMENT WITH ORDER BY ACCESSING COLUMNAR TABLES MAY BE HUNG IN DPF IJ24133 2 WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. IT31619 2 IN DPF AGAINST COLUMNAR TABLES WRONG RESULT IS POSSIBLE FOR SQL WITH LIMIT WHEN OVER[PARTITION BY] AND ORDER BY IS USED IT30770 2 SORTHEAP IS TOO SMALL Fix Pack m3fp0 - Client Interfaces IT31515 1 SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK. [CVE-2020-4200] Fix Pack m3fp0 - Codegen and Runtime IT31163 1 WRONG RESULTS ARE POSSIBLE WITH COMPLEX SQL WHICH USES UDFS AND CONSTANTS AND ENCOUNTER A COMPLEX PLAN. IT31783 2 POSSIBLE TRAP [SEGV] WHEN RUNNING A QUERY ON A NICKNAME POINTING TO A FEDERATED SOURCE AND FEDERATED GOES DOWN. IT32599 2 QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW IT32367 2 SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB Fix Pack m3fp0 - Data Management Services IT30494 2 CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY Fix Pack m3fp0 - Data Recovery Services IT30259 2 ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH IT30816 3 MESSAGE PDRECOVERY, PROBE:10 AND PROBE:20 IS LOGGED WITH EACH DIAGEVEL Fix Pack m3fp0 - Federation IT32121 1 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 LEADING TO DENIAL OF SERVICE OR PRIVILEGE ESCALATION IT32598 2 [FEDERATION]CREATE NICKNAME FAILS WITH -901 WHEN COLUMN IS DECIMAL[P,S] P>31 Fix Pack m3fp0 - Install and Catalog Services IT31637 1 SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS [CVE-2020-4204] IT32256 2 DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY IT31588 2 WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID IT31924 2 INVOKE SCP WITH THE -T OPTION DUE TO CVE-2019-6111 Fix Pack m3fp0 - Monitoring IT31573 2 DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. IT20712 3 SYSIBMADM.LOG_UTILIZATION IS RETURNING SQL0801N ON STANDBY Fix Pack m3fp0 - Platform Specific IT31704 2 MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES IT31615 2 UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG IT22910 3 PDHADDCOUNTER FAILED WITH OSERR -1073738824IN FUNCTION OSSGETPROCESSRAWCPUUSAGE[] IT32507 3 ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID[] Fix Pack m3fp0 - Process Model IT31520 1 SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK [CVE-2020-4135] IT32439 1 INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES IT31679 3 DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH Fix Pack m3fp0 - Query Compiler Optimizer IT31132 2 DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN IT32195 2 IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS IT30946 2 DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES Fix Pack m3fp0 - Query Compiler QGM IT29945 1 10 CHAR VALUE CAN BE INSERTED INTO VARGRAPHIC[5 CODEUNITS32]. THIS SHOULD FAIL WITH SQL0433N ERROR. IT31557 2 SQL1224N AFTER CERTAIN OUTER JOIN QUERIES IT30866 2 DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_UDF_SPECIFIC WITH STMT_CONC=LITERALS IT28109 2 INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? IT30926 2 TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY IT31862 2 TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE IT31634 2 WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. Fix Pack m3fp0 - Relational Data Services IT31701 1 APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS Fix Pack m3fp0 - Routine Infrastructure IT32126 2 MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO Fix Pack m3fp0 - Sailfish Operational Compatibility IT32568 2 FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH IT31437 2 EMPTY STRING IS NOT INSERTED AS NULL VALUE WHEN NULLVALUE IS EMPTY STRING Fix Pack m3fp0 - Security IT31969 3 EXTRA PRIVILEGES ON NULLID.ATSO05 PACKAGE ARE ADDED TO PUBLIC AFTER RESTORING OLDER RESTRICTIVE DATABASE IMAGE Fix Pack m3fp0 - Text Search IT31755 2 THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 IT31449 2 INTERMITTENT HANG IN SOCKET SELECT Fix Pack m3fp0 - pureScale Services IT31054 3 EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" IT29256 3 DB2INSTANCE -LIST MAY SHOW THE SECONDARY CF IN TRANSIENT ERROR STATE DURING CATCH UP ON BUSY SYSTEMS. IT31454 3 EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING"
DB2 Version 11.5 Fix Pack m2fp0 Known Issue Sev. Abstract Fix Pack m2fp0 - Buffer Pool Services IT31716 1 ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TO PANIC THE DATABASE ON ENCRYPTION ERROR. IT30898 2 TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH IT30326 2 INSTANCE MAY TRAP IN FUNCTION SQLBGETVICTIMFROMBLOCKHATELIST Fix Pack m2fp0 - CDE Data IT31719 2 ADDING A NEW TABLE USE FOR DISABLING VECTORIZED ADC Fix Pack m2fp0 - CDE Query IT31181 2 INSTANCE CAN GO DOWN WHEN COLUMN ORGANIZED TABLES ARE USED Fix Pack m2fp0 - Codegen and Runtime IT29583 2 MEMORY LEAK RELATED TO JSON QUERIES. IT30005 2 DB2 MAY PRODUCE INCORRECT RESULTS FOR HSJN WITH PREDICATE THAT HAS CASE[COALESCE] AND NLJN OR ZZJOIN ON THE OUTER IT30456 2 INSERT INTO ... WITH IGNORE DUPLICATES MIGHT FAIL WITH -901 REASON "SQLRIOPN: TABLE IS NOT CREATED" Fix Pack m2fp0 - Data Management Services IT30965 1 AN ISCAN FETCH USING CURRENTLY COMMITTED IN PURESCALE MAY RETURN UNCOMMITTED RESULTS. IT29634 2 INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL IT30061 2 DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE Fix Pack m2fp0 - Federation IT30251 1 WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN Fix Pack m2fp0 - Install and Catalog Services IT31481 1 SECURITY: DB2 IS VULNERABLE TO A PRIVILEGE ESCALATION ATTACK [CVE-2020-4230] IT29832 3 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. Fix Pack m2fp0 - Parsing and SQL PL IT30157 1 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR UPD Fix Pack m2fp0 - Platform Specific IT30432 1 SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION [CVE-2019-4587] Fix Pack m2fp0 - Query Compiler QGM IT31140 1 CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES[RANGE AND OR PREDICATES] IT30742 2 QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP" IT31207 2 INCORRECT RESULT WHEN USING TWICE JOIN WITH THE SAME TABLE WITH GROUP BY IT31462 2 SECURITY: DB2 IS VULNERABLE TO DENIAL OF SERVICE ATTACK [CVE-2020-4161] IT30467 2 DB2 MAY PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERIES CONTAINING JOINS WITH DIFFERING FLOATING-POINT PRECISIONS IT29982 2 DB2 MAY RETURN INCORRECT RESULTS WHEN EXECUTING IUD STATEMENTS CONTAINING A SUBQUERY WITH CORRELATION AND AGGREGATION IT30740 2 COMMENT ON UNICODE TABLE IN A NON-UNICODE DATABASE RESULTS IN UNREADABLE COMMENT Fix Pack m2fp0 - pureScale Services IT30143 1 SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES [CVE-2019-4584]
DB2 Version 11.5 Fix Pack m3fp0 Known Issue Sev. Abstract Fix Pack m3fp0 - Buffer Pool Services IT30789 2 ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION IT30784 2 DEADLATCH BETWEEN AN ONLINE BACKUP, PREFETCHERS AND AN AGENT DOING A WRITE TO THE SAME TABLE SPACE IT30781 2 FALSE POSITIVE AGAINST BACKUP WITH REGISTRY DB2_BCKP_PAGE_VERIFICATION IT30798 2 TABLE SPACE RESTORE UNABLE TO USE ALL CONTAINER PATHS AND FAILS WITH DISK FULL IT30811 3 DB2PD -TABLESPACE DOES NOT INDICATE LOCAL OFFLINE STATE IT30797 3 EXTENT MOVEMENT RETURNS SQL1523N REASON CODE "15" WHEN EXTENT MOVEMENT NOT RUNNING IT30796 3 RESTORE OF SMS AUTOMATIC STORAGE TABLE SPACE IN DB2 DEVELOPER-C EDITION FAILS WITH SQL1139N Fix Pack m3fp0 - CDE Query IT30231 1 ENGINE MIGHT TRAP IN IBM_CDE::TYPES::BITSTRING::ANDWITHEXPANDEDCPU Fix Pack m3fp0 - Client Interfaces IT30803 3 INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX Fix Pack m3fp0 - Data Management Services IT29231 2 UNSUSTAINABLE TRAP CAN OCCUR AFTER A SUSTAINED TRAP IF THERETEMP TABLES ARE USED BY TRANSACTIONS Fix Pack m3fp0 - Data Management Utilities IT30793 1 RESTORING A LOADCOPY WHEN THERE IS A MODIFICATION STATE INDEX ON A COLUMN ORGANIZED TABLE MAY CORRUPT THE INDEX. IT30807 2 ROLL FORWARD OR CRASH RECOVERY MAY CRASH WHEN WORKING ON INDEX PAGE. Fix Pack m3fp0 - Data Recovery Services IT30786 2 ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH Fix Pack m3fp0 - Federation IT25058 2 FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG IT30799 3 RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504 Fix Pack m3fp0 - Install and Catalog Services IT30778 2 DB2 CRASH ON FUNCTION SQLRL_GET_FULL_NAME[] Fix Pack m3fp0 - Monitoring IT29595 2 ADMIN_MOVE_TABLE CONVERTS AUTO CGS STATISTICS PROFILE INTO USER STATISTICS PROFILE IT30805 2 EM_LIST_LATCH IS GRABBED AND RELEASED FREQUENTLY EVEN THERE IS NO TRANSACTION EVENT MONITOR CREATED/ACTIVE IT30808 3 DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE Fix Pack m3fp0 - Platform Specific IT30792 1 DB2 MIGHT CRASH IN SQLOFMBLKEX->SQLO_MEM_POOL::MEMTREEPUT WITH "CORRUPT POOL FREE TREE NODE" ERROR MESSAGE IN DB2DIAG.LOG IT30794 2 CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK [WINDOWS PLATFORM ONLY] IT30801 3 STMM REPORTS SEVERE ERRORS ABOUT STMMSIMULATESORTMERGE IN DB2DIAG.LOG Fix Pack m3fp0 - Problem Determination IT30810 2 DB2DART DETECTS ERRORS AFTER UPGRADING Fix Pack m3fp0 - Process Model IT30790 2 DB2LOGGP CAN TRAP WITH SIGNAL
11 IN A FEDERATED ENVIRONMENT IT21822 4 THE DESCRIPTION OF MAXFILOP IN GET DATABASE CONFIGURATION OUTPUT IS WRONG Fix Pack m3fp0 - Query Compiler Optimizer IT29048 2 HSJN RESID PREDICATE ISSUE, LEADING TO -901 FOR THE CDE QUERY AT PARSERWRAPPER/JOINREWRITER Fix Pack m3fp0 - Query Compiler QGM IT30000 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING EXTERNAL ACTIONS AND CORRELATION IT28424 3 UNABLE TO CREATE STORED PROCEDURES WITH SAME NAME BUT DIFFERENT PARAMETERS WHEN SQL_COMPAT ='NPS' Fix Pack m3fp0 - Relational Data Services IT30800 2 SECOND EXECUTION OF A CACHED CDE QUERY IN DPF ENVIRONMENT MIGHT LEAD TO SEGV [FODC TRAP] OR FODC MEMORY FOR ILLEGAL REQUEST SIZE Fix Pack m3fp0 - pureScale Services IT30787 2 DB2CLUSTER SEGFAULT CAUSED BY WRONG ARGUMENTS TO PD_HEXDUMP WHEN RUNNING INSTALLFIXPACK ON PURESCALE IT30788 2 HADR CANNOT BE STARTED DUE TO INSUFFICIENT HADR DATABASE RESOURCE VALIDATION IT30783 3 A SEGMENTATION FAULT [CORE DUMPED] CAN OCCUR WHEN RUNNING DB2HAICU WITH AN XML INPUT FILE. IT30809 3 EXTRANEOUS CODE IN THE MOUNTV111_STOP.KSH SCRIPT IT30806 4 DB2CLUSTER -CM -LIST -TIEBREAKER RETURNS INCORRECT OUTPUT WHEN THE DOMAIN IS STOPPED OR IN MAINTENANCE