IBM Support

Fix List for Db2 Version 11.5 for Linux, UNIX and Windows

Troubleshooting


Problem

Db2 11.5 Known Issue Fix list contains list of Known Issues shipped for each Mod Pack, Fix Pack in Db2 Version 11.5 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 Case at the time the Known Issue was opened.

Resolving The Problem

************************************************************
Product Name : DB2 UDB Version 11.5
Updated : Nov 15, 2023
************************************************************

Select a Fix Pack: m9fp0 | m8fp0 | m7fp0 | m6fp0 | m5fp1 | m5fp0 | m4fp0 | m3fp0 | m2fp0 | m3fp0


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 <= numCachedHWMs' in a query that runs concurrent to insert/update activity
DT188759 Incorrect Output (IN) SQL0901N unexpected error in InListEvaluator.cpp
DT188951 Incorrect Output (IN) SQL0901N in JoinSpillInfo::resetPartInfoForRepart() with Keys mis-match before and after repartitioning
DT211633 Abnormal End Of The Program (AB) Very rare risk of possible memory corruption in Columnar Join plans
DT188654 Abnormal End Of The Program (AB) Protective logic against a possible trap CDE
DT215592 Abnormal End Of The Program (AB) TRAP UNDER ibm_cde::query::SortInfo::getPublishingWork
DT220310 Incorrect Output (IN) Incorrect Results when columnar tables JOIN predicate involves SUBSTR on CODEUNITS32 CHAR columns
DT227816 Incorrect Output (IN) Db2 is missing rows inserted into table using QRep
DT160159 Unpredictable (UN) Incorrect padding during conversion from char(8) to char(12) when using CCSID 1047
DT168620 Performance (PR) Excessive storage consumption due to Reorg Table Reclaim Extents not cleaning up extents properly after Trickle Feed Insert is disabled
DT223178 Abnormal End Of The Program (AB) Rare memory corruption when HSJN is done in Columnar logic on Columnar Tables.
DT228229 Abnormal End Of The Program (AB) Db2 takes long time to dump diagnostics to the first occurrence data capture (FODC) directory
DT238478 Abnormal End Of The Program (AB) CDE Query fails with SQL0901N AssertionFailedException Thrown at Scheduler.cpp : 7525
DT171809 Abnormal End Of The Program (AB) Insert query crashes Db2 with RTABLE is ON
DT180543 Incorrect Output (IN) SQL0901N - Reason "unexpected error at MinMaxPartialEvaluator.cpp:68"
DT195966 Abnormal End Of The Program (AB) Insert statement hits FODC_Trap in SavepointResources::refreshNextTSNsToSplitAtSavepointOpen function
DT215090 Abnormal End Of The Program (AB) Extra diagnostics to diagnose rare traps in Columnar HSJN that have CHTExtraPayloadPage in stack.
DT215391 Abnormal End Of The Program (AB) Columnar Aggregation taking excessive amounts of memory
DT223133 Incorrect Output (IN) Query might fail with -901 - Reason "unexpected error at TableQueueEvaluator.cpp:1096".
DT236913 Loop (LP) A SELECT STATEMENT WITH CSE MAY HANG
DT179633 Abnormal End Of The Program (AB) Invalid file handle error returned by SQLDriverConnect/W() API on windows platform causing engine abort
DT221878 Incorrect Output (IN) IBM Database Add-Ins may not install if Build Tools for Visual Studio 2017 are present on the system.
DT168942 Incorrect Output (IN) JCC driver returns ERRORCODE=-4499 where a seamless failover is expected
DT196884 Incorrect Output (IN) Signals could get delivered to CLI sub threads which are meant to be delivered to CLI main thread
DT208149 Incorrect Output (IN) DECIMAL_OLEDB to DECFLOAT conversion fails for value zero .
DT174264 Incorrect Output (IN) odbc_cli driver package does not accept precision greater than 31 for decimal types while connecting to IBM i
DT173390 Abnormal End Of The Program (AB) Null Pointer Exception during HADR failover
DT197561 Abnormal End Of The Program (AB) AccessViolationException in db2app64.dll (Db2 .NET Provider native code) while invoking a StoredProcedure from Db2 .NET driver
DT239599 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to a denial of service when a specially crafted request is used via CLI (CVE-2023-45178)
DT188190 Unpredictable (UN) Allow users with SCHEMAADM authority to create tables without having CREATETAB
DT188650 Incorrect Output (IN) RCAC dependencies can cause database fixpack updates to fail with SQL0478N
DT208717 Incorrect Output (IN) Routines and triggers do not get revalidated by SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS for objects with a schema length below 4 characters.
DT214526 Abnormal End Of The Program (AB) High number of locked objects and lock waits on CatCacheLock - on table SYSIBM.SYSUSERAUTH
DT145029 Abnormal End Of The Program (AB) db2look got SQL0206N when upgrading from Db2 11.5.4 to 11.5.6 or above without db2updv115
DT169621 Incorrect Output (IN) Stored Procedure definitions missing the PARAMETER MODE (IN/OUT/INOUT)
DT180107 Abnormal End Of The Program (AB) Index(es) found in PD which are not found in SYSIBM.SYSINDEXES
DT180628 Unpredictable (UN) Upgrade event monitor target tables fails with SQL0443 - SQL0444
DT189676 Abnormal End Of The Program (AB) Column-organized table may be locked in drop restrict state, preventing drop table from succeeding
DT208817 Incorrect Output (IN) db2updv115 returned SQLCODE -104 error for drop statement
DT209762 Incorrect Output (IN) TOTALDBPARTITIONCONNECTIONS into TOTALMEMBERCONNECTIONS in db2look
DT211422 Incorrect Output (IN) Generate error message for DB2look when the wrong option is specified with -ct
DT212546 Incorrect Output (IN) Binding from an 11.5 client to a down-level server can fail with an SQL0104N error.
DT237745 Coded Halt (HL) db2look encounters SQL0804N in 11.5.8.0
DT171921 Incorrect Output (IN) FODC error during drop table - inconsistency between syscat.indexes and sysibmts.tsindexes
DT172372 Incorrect Output (IN) Make Alter Table block correctly for the In clause and Long In clause condition
DT221822 Abnormal End Of The Program (AB) Allowing the user to receive ownership of a function with a sequence alias as a dependent object
DT168528 Coded Message (MS) Changing "sqeLocalDatabase::AutoBind, probe:20963" from "LEVEL: Warning" to "LEVEL: Error"
DT223909 Incorrect Output (IN) CLP removes new line characters if there are a simple comment between bracketed comments and CREATE PROCEDURE statement
DT178648 Incorrect Output (IN) Allow db2cli refreshldap to work on installed Db2 clients not just Drivers
DT180609 Incorrect Output (IN) SQLCODE -902 can be returned when a client reads larger LOB data using application compile with AIX 32-bit library
DT221927 Incorrect Output (IN) Missing column or index name in some explain diagnostic messages
DT236621 Incorrect Output (IN) More than 350 EINVAL (22) "Invalid argument" LEVEL: Error (OS)[] errors is returned when you pipe the output of a DB2 command to the head operating system command
DT173536 Abnormal End Of The Program (AB) Running zload on a file bigger than 2GB fails with SQL2731N Error while reading from input data file
DT179678 Incorrect Output (IN) IQQD0008E Collection state is invalid for this action
DT213363 Incorrect Output (IN) Data loss potential when using Embedded SQL with multiple agents and Multi-row insert
DT214747 Performance (PR) Server list missing alternate server when value of alternate server matches the value of the server it is set up on for the length of alternate server
DT222034 Incorrect Output (IN) Compiling .cbl file generated by prep command failed with 309 "Malformed subscript" error
DT173047 Performance (PR) Re-authentication occurs when re-using an existing transport for a member in xa transaction
DT188305 Incorrect Output (IN) DB2BULKCOPY MAY RETURN CLI0125E WHEN TRYING TO LOAD MULTIPLES OF16K NUMBER OF ROWS
DT188887 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to a denial of service when attempting to use ACR client affinity for unfenced DRDA federation wrappers. (CVE-2023-27555)
DT207573 Abnormal End Of The Program (AB) TRAP IN SQLEGWRT FUNCTION
DT212309 Abnormal End Of The Program (AB) When using JDBC type 2 driver, abort call from the Transaction Manager could return XAER_PROTO.
DT214991 Abnormal End Of The Program (AB) ACR is disabled for the Federation DRDA fenced wrapper after applying fix for DT188887
DT173970 Coded Message (MS) "SSL socket setup failed" error logging in db2diag.log caused by monitoring the SSL socket
DT178562 Incorrect Output (IN) Resize and redefine the size of char array program_z
DT179750 Incorrect Output (IN) .NET application returns error SQL0843N during connect
DT208528 Abnormal End Of The Program (AB) Documents are not indexed with warning IQQP0009W
DT224887 Incorrect Output (IN) Memory Leak connected with db2acd process
DT224696 Loop (LP) db2support collection hangs when there are indoubt transactions
DT160471 Performance (PR) Possible page latch contention when inserting into an insert time clustered table
DT168735 Abnormal End Of The Program (AB) The INGEST utility on AIX fails with DB21018E when connected to a remote database with an SSL encrypted connection
DT173007 Abnormal End Of The Program (AB) Security: IBM Db2 may be vulnerable to a Denial of Service when executing a specially crafted 'Load' command. (CVE-2022-43929)
DT178367 Abnormal End Of The Program (AB) Segmentation fault in sqldDumpDKEY
DT198274 Integrity Problems (IG) Security: IBM Db2 db2set is vulnerable to arbitrary code execution. (CVE-2023-30431)
DT147509 Incorrect Output (IN) IT38703: INGEST TO PARTITIONED DATABASE DOES NOT WORK OVER SSL
DT147574 Abnormal End Of The Program (AB) IT41721: IMPORT WITH INSERT_UPDATE FAILS WITH SQL3203N AFTER GETTING SQL0437W.
DT148311 Abnormal End Of The Program (AB) INDEX ERROR DURING ROLLBACK WHEN INSERTING INTO A DECLARED GLOBAL TEMPORARY TABLE THAT IS ORGANIZED BY COLUMN
DT149264 Abnormal End Of The Program (AB) IT42035: A CLI LOAD INTO A COLUMN ORGANIZED TABLE MIGHT CRASH WITH A SPECIFIC STACK
DT160180 Performance (PR) Rollforward/replay of online reorg log causes slow log replay
DT169540 Incorrect Output (IN) IT42201: Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables
DT174577 Incorrect Output (IN) SQL16003 from XML query
DT188227 Performance (PR) Private memory leak on COS SDK
DT188237 Abnormal End Of The Program (AB) LOAD into MQT table using LOCK WITH FORCE option does not force all locks and hangs on SET INTEGRITY
DT221994 Abnormal End Of The Program (AB) ADMIN_MOVE_TABLE may hit SQL0911N Reason Code 68 when using CLP option autocomit off
DT222000 Performance (PR) Deadlock on rows in SYSXMLSTRINGS or SYSXMLPATHS when many concurrent applications drive queries and inserts of XML documents
DT241187 Remove XML Extenders since it was discontinued in v9.7
DT169362 Incorrect Output (IN) LOAD from cursor into inline XML with values longer than 256 characters results in SQL1194W
DT169561 Abnormal End Of The Program (AB) Big SQL instance abends with an SQLO_UNEXPECTED_SYSERR from sqloWaitEDUWaitPost()
DT189082 Abnormal End Of The Program (AB) Under certain conditions user can get false SQL0960C The maximum number of objects have been created in the table space
DT205468 Abnormal End Of The Program (AB) db2prereqcheck -tb_dev failed with segmentation fault(segv) at strncpy()
DT207549 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to denial of service with a specially crafted XML query statement (CVE-2023-38728)
DT212891 Incorrect Output (IN) Data loss while ADMIN_MOVE_TABLE possible
DT215290 Incorrect Output (IN) #pragma options in DB2 header files cause compiler warnings
DT224960 Integrity Problems (IG) A table space in an offline state can be incorrectly brought online resulting in data corruption
DT238088 Incorrect Output (IN) Automatic maintenance (db2acd) process may generate "hmonSQLConnect, probe:600 sqlcode=-1035" Error message every 5 minuets on db2diag.log while taking an offline backup
DT147397 Unpredictable (UN) AUTO_REORG MIGHT BE TRIGGERED FOR TABLES WITH ADAPTIVE COMPRESSION ENABLED DUE TO F2 < 70 FOR MDC
DT148675 Abnormal End Of The Program (AB) IT41241: POSSIBLE FMP TRAP WHEN USING ADMIN ROUTINES OR ANY MODULE USING LIBDB2XMLINIT531.A
DT178232 Integrity Problems (IG) Error messages from sqlbExtentMovementEntryPoint can be inadvertently suppressed
DT178710 Performance (PR) pureScale: hate lists temporarily empty after large queries
DT180384 Incorrect Output (IN) Private memory leak while using Sequences
DT202928 Abnormal End Of The Program (AB) Trap in dlopen() causes deadlatch with loadquery() called by Db2 signal handler
DT208144 Unpredictable (UN) SQLD_REC_DELETED "DELETED RECORD ID" may show up during select from sysibmadm.admintabinfo
DT214775 Unpredictable (UN) CONNECTION SLOWNESS/HANG DUE TO MORE LATCH WAIT AT GROUP AUTHENTICATION STEP.
DT224997 Abnormal End Of The Program (AB) Db2 instance hang upon database creation failure SQL1643C
DT148089 Abnormal End Of The Program (AB) IT39613: SIGNAL #11 IN XMLRNSERIALIZER::PACKSTATE
DT148406 Performance (PR) IT38343: ENHANCE DB2_CSL_SEARCH_PERCENT TO IMPROVE INSERT PERFORMANCE
DT148473 Incorrect Output (IN) IT40815: Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables
DT171612 Integrity Problems (IG) Tablespace Reduce Max/HWM can provoke dumps .bin due to unexpected lock holding in SQLP_EXTENT_MOVE_STARTED
DT179583 Incorrect Output (IN) Can't compile in Application with DB2 Client Server 11.5.8. This is the error that the system returns: libdb2.so: undefined reference to sqloRemStgDelete
DT197696 New Function (NF) ENABLE OPTION TO ALLOW AUTOMATIC TABLE MAINTENANCE TO CHOOSE OFFLINE INSTEAD OF ONLINE INDEX REBUILD TO AVOID DEADLOCK.
DT213899 Performance (PR) Slow RUNSTATS performance after upgrade from Db2 v10.5/v11.1 to v11.5
DT214206 Abnormal End Of The Program (AB) A Db2 instance can crash if a database encounters a too many open file handles (SQLO_FHNL) error while opening the database storage group files
DT236661 Incorrect Output (IN) Invalid XML from table monitoring functions FOR BIT DATA
DT188148 Coded Wait (WS) Automatic Reorg Evaluation on an ITC table can hold back completion of an automatic table reorganization on the table
DT209167 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to denial of service under extreme stress conditions. (CVE-2023-40692)
DT215950 Coded Message (MS) installFixPack fails with an ERROR for non-root installations, complains about loaded libraries
DT173853 Incorrect Output (IN) db2iupdt fails to drop a collocated member using the member id
DT197671 Integrity Problems (IG) Security: IBM Db2 on Windows is vulnerable to privilege escalation. (CVE-2023-27558)
DT214851 Incorrect Output (IN) python2 is no longer needed for Db2, but still checked by db2prereqcheck
DT173400 Abnormal End Of The Program (AB) InstallFixPack fails with DBI20105E when attempting to update Pacemaker
DT178134 Incorrect Output (IN) On Sles 15, db2installPCMK hitting "nothing provides pkgconfig(libqb)"
DT222769 Abnormal End Of The Program (AB) Validating "/etc/zipl.conf".. DBT3615E The db2prereqcheck.. Reason Code 3 for Db2 V11.5.8.0
DT242836 Integrity Problems (IG) Security: Multiple vulnerabilities in IBM Java SDK and IBM Java Runtime affect Db2 (Apr 2023 CPU)
DT148431 Incorrect Output (IN) IT39324: FEDERATED OPERATIONS MIGHT LEAD TO INSTANCE CRASH WHEN HEALTH MONITOR IS TURNED ON
DT160132 Unpredictable (UN) IT42096: INCORRECT ERROR HANDLING IN SQLEFEDFMPMANAGER::GETFMPFROMGLOBALPOOL LEADS TO DB2 INSTANCE CRASH
DT173461 Abnormal End Of The Program (AB) Federation returns SQL0901N "Unknown type" error when query numeric value with single quote using ODBC wrapper
DT198104 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to a denial of service through a specially crafted federated query on specific federation objects (CVE-2023-29258)
DT223376 Abnormal End Of The Program (AB) Oracle unfenced wrapper trapping
DT237766 Performance (PR) Federated query performance degradation when DB2_MAXIMAL_PUSHDOWN is set to ‘Y’ by default
DT238497 Abnormal End Of The Program (AB) Create Teradata nickname failed with SQL0204N
DT143275 Performance (PR) IT41646: FEDERATION FUNCTIONS NOT PUSHED DOWN WHEN USING PARAMETER MARKERSUCH AS TO_TIMESTAMP(?,'YYYY-MM-DD HH24:MI:SS')
DT148462 Abnormal End Of The Program (AB) IT40445: CRASH IN WHEN XML SOURCE FILE IS DELETED OR RENAMED
DT173847 Incorrect Output (IN) SELECT NICKNAME MAY RETURN A GARBLED CHARACTER AT THE END
DT213111 Loop (LP) If we lost connection from POSTGRESQL while fetching the data from POSTGRESQL using ODBC wrapper (Federation) and loading into DB2, then load is hanging
DT214010 New Function (NF) Timestamp and Date not pushed down to MongoDB Data Source
DT148223 Incorrect Output (IN) IT37810: REDUCE DB2DIAG.LOG MESSAGE "GET USER MAPPING" AND "SQLQG_FEDSTP_HOOK, PROBE:40 MESSAGE"
DT173486 Abnormal End Of The Program (AB) Security: Db2 federated server is vulnerable to a denial of service when a specially crafted cursor is used. (CVE-2023-46167)
DT208699 Incorrect Output (IN) CREATE NICKNAME command for a remote SQL Server table returns -204 error occurs: undefined name
DT222119 Performance (PR) Db2 federation query with decimal and char comparison predicate becomes slow due to not being able to do pushdown
DT224489 Abnormal End Of The Program (AB) Federating to SQL Server throws SQL1822N Unexpected error code "HY104" received from data source "". Associated text and tokens are " Invalid precision value".
DT148065 Incorrect Output (IN) IT38517: MSSQL_SERVER::GET_ERROR_INFO ERROR IN MS-SQL FEDERATION CONFIGURATION
DT170049 Abnormal End Of The Program (AB) Db2 Federation nickname driver issue
DT180458 Abnormal End Of The Program (AB) Instance crash due to double memory free in sqlqgFedCmt1
DT187940 Abnormal End Of The Program (AB) Security: IBM Db2 federated server is vulnerable to a denial of service when using a specially crafted wrapper using certain options. (CVE-2023-30442).
DT189684 Incorrect Output (IN) Federation: Oracle net8 wrapper-support function pushdown: replace, trim and to_number
DT196289 Incorrect Output (IN) Federated does not push down certain predicates to z/OS
DT196864 Abnormal End Of The Program (AB) Federation server memory panic caused by sqlqgFedRbk1
DT239700 Integrity Problems (IG) Security: Db2 Federated is affected by vulnerabilities in multiple opensource libraries
DT160542 Incorrect Output (IN) Federation SQL1476N error "-433" insert into nickname(varchar_column) select varchar_column from local_table
DT172037 Incorrect Output (IN) Federation ODBC wrapper characters might be truncated for MariaDB, MySQL community edition, and SAP hana data sources
DT203382 Incorrect Output (IN) SQL query containing the OLAP LEAD function returns wrong results
DT220220 Incorrect Output (IN) Federated user mapping change is not refreshed after HADR takeover
DT224589 Coded Message (MS) sqlerReturnFmpToPool messages flood the db2diag.log
DT228892 System/3 Message (MI) Creating Teradata wrapper on AIX failed with SQL10031N from V11.5.4
DT222637 Incorrect Output (IN) SYSTOOLS.MESSAGES is not created in the specified table space
DT170035 Abnormal End Of The Program (AB) GET DB CFG traps if using DB2NODE to fetch data from a remote node
DT170166 Additional Information (AI) LOGGING ENHANCEMENT FOR AN ISSUE CAUSING ORPHANED APPLICATION IN DECOUPLED STATUS IN DPF
DT179060 Loop (LP) application not going away, stuck in sqkfChannel::BroadcastData
DT195996 Performance (PR) Db2 concurrent workload may slow down due to heavy latch wait on the SQLO_LT_sqmPartitionedRequestMetrics__metricsSyncPoint latch
DT202887 Incorrect Output (IN) PD_GET_DIAG_HIST and db2diag tool might return entries outside of specified time range.
DT222611 Incorrect Output (IN) Db2 can fail with SQLKD_PARTNER_ERR - "Received HALT block with zero return code"
DT222775 Incorrect Output (IN) Locking event monitor incorrectly reports RR isolation level for statements that are in compiling state
DT237788 Abnormal End Of The Program (AB) Possible trap under sqkfChannel::AddSlaveChannel() on remote node
DT242834 Integrity Problems (IG) Security: PCRE opensource library affected by multiple vulnerabilities
DT148687 Performance (PR) IT41917: MON_GET_TABLE MAY BLOCK ON A LOCK WHEN EXTERNAL TABLES ARE BEINGUSED
DT149281 Incorrect Output (IN) get_dbsize_info() may return unexpected large value for DATABASECAPACITY
DT189651 Loop (LP) System applications may hang in sqlrrbck if they perform a rollback at the same time as an implicit database deactivation.
DT197244 Abnormal End Of The Program (AB) Incorrect diagnostic log message in sqlkd_snd_buffer may lead to a crash
DT160816 Incorrect Output (IN) Misleading/Incorrect Path Reported by db2diag command
DT174378 Abnormal End Of The Program (AB) Security: Db2 could allow a local user with special privileges to cause a denial of service during database deactivation on DPF (CVE-2023-38719)
DT179659 Abnormal End Of The Program (AB) db2csap generates a core dump when running db2support
DT187963 Integrity Problems (IG) SYSMANAGEDQUERIES wlm work class of type RUNTIME in a 11.5.6 based database with old wlm default environment
DT212788 Incorrect Output (IN) Drop event monitor may result in creation of an applicatoin on non-coordinator nodes
DT214839 Abnormal End Of The Program (AB) Failure on an SQL statement with error may lead to trap in sqmSqlCacheMetrics::CaptureCoordHWMArgs
DT223627 Incorrect Output (IN) During system controller startup, some diagnostics messages are not recorded in the diagnostics log
DT147386 Abnormal End Of The Program (AB) IT41166: SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0)
DT148129 Abnormal End Of The Program (AB) IT41889: A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND.
DT148130 Incorrect Output (IN) IT41926: TRACKING ERROR IN WLM ERROR CORRECTION CAN LEAD TO NON FATAL ASSERTION
DT148314 Abnormal End Of The Program (AB) IT41989: THE EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CAN TRAP FOR LOCK EVENTS INVOLVING A TABLESPACE LOCK WHEN THE TABLESPACE IS ALREADY DR
DT172665 Unpredictable (UN) HADR status changed to disconnected after primary reboot
DT188935 Incorrect Output (IN) Event Table Is Filling Up After the Event Monitor Is Dropped in DPF System
DT236687 Incorrect Output (IN) Reduce severity level of db2diag probe if it is an interrupt for WLM monitoring functions
DT148668 Abnormal End Of The Program (AB) IT40873: SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0)
DT188297 Abnormal End Of The Program (AB) DB2 trap in federation communication against DB2 z/os federated
DT189583 Abnormal End Of The Program (AB) db2pd -apinfo crash with -debug option because of extended memory corruption
DT211718 Loop (LP) "db2 force application('apphdl')" can fail to properly interrupt external table operations using SSL connection.
DT222690 Coded Halt (HL) DB2 SYSTEM APPLICATIONS MAY HANG ON A DB2 DPF INSTANCE
DT223336 Incorrect Output (IN) db2pd -dump all dumpdir='/scratch/' -repeat 5 2 may dump data into wrong directory
DT228901 Abnormal End Of The Program (AB) db2pd -applications may result in messages "Changing data structure forced command termination"
DT160459 Coded Message (MS) DB2DIAG.LOG FLOODED WITH DIAGNOSTIC MESSAGES
DT228889 Performance (PR) Latch Contention in CF for Highly Concurrent, Read Heavy Workloads
DT147773 Abnormal End Of The Program (AB) IT41923: CREATE INLINED TRIGGER FAILED WITH SQL901N (REASON "NO SOURCE TABLE FLAG SET FOR UPDATE FROM QUERY")
DT148852 Abnormal End Of The Program (AB) SQL0901N FODC_AppErr generated when running a query
DT160196 Abnormal End Of The Program (AB) Db2 server may terminate abnormally issuing a query with unreferenced CTE
DT168886 Abnormal End Of The Program (AB) Db2 query may trap when cse with union
DT172257 Incorrect Output (IN) Query execution plan has non-numeric Total Cost values
DT172335 Abnormal End Of The Program (AB) IN MPP CONFIGURATIONS, UNDER RARE CONDITIONS, A QUERY WITH A CORRELATED COLUMN REFERENCE IN A SUBSELECT MIGHT RESULT IN A SEGV TRAP
DT173793 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to denial of service with a specially crafted query. (CVE-2023-30449)
DT188141 Abnormal End Of The Program (AB) Security: Db2 server may terminate abnormally when using a specially crafted query on certain databases. (CVE-2023-30987)
DT188352 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30447)
DT203400 Abnormal End Of The Program (AB) Security: IBM DB2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30446)
DT208544 Integrity Problems (IG) Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2023-30991)
DT209233 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2023-43020)
DT212885 Performance (PR) Provide method to favour access plans that can exploit performance enhancement to column-organized updates/deletes with joins
DT212933 Incorrect Output (IN) A DB2 query may return incorrect results when query references a user defined function and at-least one columnar table
DT220313 Incorrect Output (IN) SQL0901N "No Remote Query output columns given." from table function involving column-organized tables
DT222709 Abnormal End Of The Program (AB) FIXPACK UPDATE MAY LEAD TO ERROR SQL901N
DT237459 Coded Halt (HL) SQL0901 "Empty plan list detected!" when compiling query with full outer join
DT147742 Incorrect Output (IN) 901 ERROR MIGHT OCCUR WITH THE MESSAGE "PLAN NOT FOUND FOR UNIONLEG"
DT147960 Abnormal End Of The Program (AB) IT41629: ISSUING TRUNCATE TABLE STATEMENT MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY.
DT148293 Performance (PR) IT41067: ISSUING SELECT UNION ALL QUERY WITH LARGE CLOB MAY FAIL WITH SQL1585N
DT160619 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to a denial of service as the server may crash when compiling a specially crafted SQL query. (CVE-2023-26021)
DT168757 Incorrect Output (IN) IT42207: WRONG RESULT WHEN GROUP BY COL IS MISSING
DT172693 Abnormal End Of The Program (AB) Creating NZPLSQL routine may result in stack memory corruption
DT173255 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30448)
DT173447 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to denial of service with a specially crafted query. (CVE-2023-30443)
DT180503 New Function (NF) ALLOW AN EMBEDDED OPTIMIZATION GUIDELINE ANYWHERE WITHIN AN SQL STATEMENT.
DT188497 Incorrect Output (IN) Query fails with error SQL0901N "nljn LOJ inner not nullable"
DT188878 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to a denial of service. Under rare conditions, setting a special register may cause the Db2 server to terminate abnormally (CVE-2023-25930)
DT197773 Performance (PR) Automatic catalog statistics sampling occurs incorrectly in some situations
DT211543 Incorrect Output (IN) SQL0901N error with "Empty plan list detected" may be returned for MPP queries which construct XML elements
DT220159 Machine Check (MC) A Db2 query may exhibit long compile times when there are several CSEs (Common Sub-Expressions) referenced
DT228461 Performance (PR) THE FILTER FACTOR WILL NOT BE ADJUSTED TO THE REQUESTED VALUE SPECIFIED BY THE SELECTIVITY CLAUSE
DT148689 Incorrect Output (IN) IT41977: POSSIBLE -901 ERROR FOR NESTED QUERIES WITH CASE EXPRESSIONS WITHSUB-QUERIES REFERENCED THE SELECT LIST.
DT169994 Performance (PR) Slow compilation of queries involving INNER JOINs of multiple tables and some partitioned tables
DT172119 Performance (PR) Poor performance of Db2 query when Group By list has expression and index column
DT173349 Incorrect Output (IN) INSERT INTO COLUMN-ORGANIZED TABLE WITH SUB-SELECT REFERENCING THE TARGET OF THE INSERT MAY RETURN INCORRECT RESULTS IN DPF SYST
DT178597 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to a denial of service as it may trap when compiling a variation of an anonymous block (CVE-2023-29255)
DT211674 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to denial of service with a specially crafted RUNSTATS command on an 8TB table. (CVE-2023-40687)
DT212371 Incorrect Output (IN) SQL0204N due to timestamp checking to compare start of compilation with the creation time of the table
DT214149 Incorrect Output (IN) Subquery with FETCH FIRST n ROWS and OLAP function but without ORDER BY on column-organized tables might return more rows than expected
DT237138 Performance (PR) Poor performance of Db2 query when the following conditions mentioned in the description are met
DT147963 Incorrect Output (IN) IT41976: Missing table name in the diagnostic Information regarding not collected statistics in the explain plan file
DT172317 Incorrect Output (IN) Db2 query may generate Incorrect result when tables have Referential Integrity(RI) relation.
DT173830 Incorrect Output (IN) Use of non-supported RID function triggers SQL0901N error instead of the expected SQL5115N error
DT174494 Abnormal End Of The Program (AB) Security: Db2 server may terminate abnormally when issuing a specially crafted query statement (CVE-2023-40374)
DT178746 Incorrect Output (IN) CREATE TABLE IF NOT EXISTS ignores dft_table_org=COLUMN database configuration parameter
DT187836 Abnormal End Of The Program (AB) Query compile fails with SQL0901N "pid type does not match original untyped code
DT189181 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted subquery. (CVE-2023-27559)
DT189461 Performance (PR) COLUMN-ORGANIZED FETCH-IXSCAN ESTIMATED COST IS INACCURATE FOR QUERIES THAT RETRIEVE A LARGE NUMBER OF COLUMNS AND ROWS.
DT189799 Incorrect Output (IN) Creating an expression-based index may lead to SQL0622N error
DT209442 Incorrect Output (IN) SYSCAT.ROUTINEPARMS missing parameters for LAG and LEAD built-in functions
DT209578 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to denial of service with a specially crafted SQL statement using External Tables. (CVE-2023-40372)
DT211077 Performance (PR) Poor performance of merge statement when hidden column of PK absent in ON
DT212934 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to denial of service with a specially crafted query containing common table expressions (CVE-2023-40373)
DT215096 Performance (PR) Poor performance of Db2 query with always true regexp_like predicate.
DT221828 Abnormal End Of The Program (AB) SQL0508N when DB2_EXTENDED_OPTIMIZATION=MARKMCARD_MISSINGPKCOL ON
DT222859 Abnormal End Of The Program (AB) Security: Specially crafted statement results in abnormal termination of Db2 server (CVE-2023-38727)
DT222991 Incorrect Output (IN) The SYSSTAT.TABLES.FPAGES statistic is sometimes inconsistent with NPAGES and MPAGES
DT160511 Performance (PR) Performance issues when queries contain predicates on columns derived from constants in recursive sub-selects
DT172015 Additional Information (AI) Info level diagnostics might be recorded in db2diag log file for DIAGLEVEL 0-3
DT173922 Incorrect Output (IN) With Db2 DPF, SQLCODE -901 "Correlated part col not in stream." might occur during compilation of a query with correlated grouping sets columns
DT174288 Incorrect Output (IN) Plan ID changes when migrating from 10.x versions of Db2 to 11.1 and later.
DT188308 Incorrect Output (IN) Explicit cast to VARCHAR or VARGRAPHIC without length ignores default string units
DT189575 Incorrect Output (IN) -901 with Can not enforced Maxcard > 1 when multiple joins used in query
DT189592 Incorrect Output (IN) SYSCAT.DATAPARTITIONS contains incorrect statistics values for column-organized tables
DT197954 Incorrect Output (IN) A multi-join query involving column-organized tables and join predicates with complex expressions might yield incorrect results.
DT209344 Performance (PR) Possible performance issue and high demand for STMTHEAP (or SQL0101N) for complex XML queries with multiple Union All branches
DT215667 Abnormal End Of The Program (AB) Security: Specially crafted ALTER TABLE may cause abnormal termination of Db2 server (CVE-2023-38720)
DT224882 Incorrect Output (IN) UPDATE or DELETE of global temporary table returns SQL0551
DT228679 Abnormal End Of The Program (AB) SQL0901 "Predicate not found" during Federated query compilation
DT238314 Abnormal End Of The Program (AB) In complex queries using OLAP function first_value on column ordered tables, in MPP systems, may encounter a trap.
DT174584 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30445)
DT197297 Incorrect Output (IN) "SET ?" returns SQL0901 with stmt_conc=LITERALS
DT189173 Incorrect Output (IN) Make DROPTAB_ACTION optional in Q Capture
DT195980 Fix the unique index issue and Update the new QMAP name for CCD columns.
DT197841 Incorrect Output (IN) If the target table already exists, and the unique index is suitable, Replication Center (RC) and ASNCLP incorrectly still try to create index
DT208526 Incorrect Output (IN) Issue ASN7358I message on Q Capture startup when trans_batch_sz is greater than 1 and Q Capture automatically bumps up MAX_TRANS
DT212936 Integrity Problems (IG) SQL Capture and Q Capture are not updating PART_HIST table for ATTACH/DETACH/ADD range Partition - Potential Data loss after Capture restart
DT222106 Incorrect Output (IN) Oracle Apply initial load with SQL*Loader fails with ASN7530E bad data record for DECIMAL column data having equal precision and scale
DT224566 Incorrect Output (IN) Q Capture needs to set correct default value for TRANS_COMMIT_MODE parameter
DT228669 Incorrect Output (IN) SQL Error "-803" occurs when creating monitor tables with ASNCLP on Oracle.
DT180608 Incorrect Output (IN) Oracle Q Apply gets error ORA-01400 for MRI due to incorrect default for RTRIM_CHAR_TO_VARCHAR parameter
DT208925 Incorrect Output (IN) The message "Parameter index 78 is out of range." is displayed every time Capture is started
DT209069 Incorrect Output (IN) Need COMMITs for retention_limit pruning in SQL Capture
DT213082 Performance (PR) Q Apply should use compression with binary format during columnar table initial load
DT215896 Incorrect Output (IN) Oracle Q Capture should not get ORA-01741 for inserts into the IBMQREP_CAPMON table
DT223427 Incorrect Output (IN) Restore some operations in Replication Center
DT172370 Abnormal End Of The Program (AB) Q Apply startup or STARTQ may fail with SQL-10 when checking if a target is a nickname.
DT174287 Incorrect Output (IN) Replication Center does not display the Alert Group assigned contacts
DT188249 Incorrect Output (IN) Fix ALTER TABLE ALTER COLUMN DROP/SET DEFAULT in v1158
DT188885 Incorrect Output (IN) "Delete gtran committed before restart point" message floods capture log when processing an empty global transaction
DT199933 Incorrect Output (IN) ADDCOL Processing leads to ASN7814E due to inconsistent IS_KEY information between IBMQREP_SRC_COLS and IBMQREP_TGT_COLS
DT211484 Incorrect Output (IN) Oracle QCapture should not stop on OCI_SUCCESS_WITH_INFO
DT215449 Incorrect Output (IN) Asnmon report error message ASN5154W when the alert on QCAPTURE_MEMORY uses a value greater than 2047.
DT225689 Incorrect Output (IN) Missing parameter marker in ASNDB2SQ package
DT238900 Incorrect Output (IN) Q Apply should not activate range partition subscriptions if there are any rejected rows during the initial load
DT172477 Incorrect Output (IN) Add the missing new column HAS_PARTS into migration script.
DT173810 Incorrect Output (IN) Add "NO CACHE ORDER" when creating IBMQREP_APPLYCMD and IBMQREP_CAPCMD control tables.
DT197143 Incorrect Output (IN) CP4D- Q replication server reported the message "ASN8999D Corrupted qStreamedTransMsgHeader on send queue xxxx"
DT197526 Abnormal End Of The Program (AB) When running asnmon on LUW with control tables on z/OS, asnmon terminates with ASN0543E error
DT214858 Incorrect Output (IN) Fix memory corruption error in Q Capture send queue
DT222930 Performance (PR) Q Apply replicating columnar table in DPF may report SQL -644 if target table does not use all data partitions.
DT172482 Incorrect Output (IN) Q Capture should read from serialized XML log records instead of fetching from the table when XML columns are defined in a separate long tablespace
DT189305 Incorrect Output (IN) Q Apply poor performance for complex RI needs to be improved by doing dependency analysis based on RI key values
DT215322 Incorrect Output (IN) Asnmon takes a sigsegv and a dump is generated when it writes to a file with a long path name.
DT225087 Incorrect Output (IN) asnmon getting sql0803n after setting DB2_COMPATIBILITY_VECTOR=ORA
DT238517 Incorrect Output (IN) On Unix and Windows platforms, ASNCLP expose error ASN1551E when creating SQL capture control tables if we specify the UOW keyword
DT149266 Incorrect Output (IN) IT42044: SQL0955 RC=2 MAY BE RETURNED FOR SORT REQUESTS WITH A WIDE SORT KEY (>32K) WHEN AVAILABLE SORTHEAP IS LIMITED
DT171981 Abnormal End Of The Program (AB) Insert into a DGTT which contains XML fields on MPP environment might crash the instance
DT174686 Loop (LP) Agent cannot be forced under certain conditions
DT203318 Coded Halt (HL) Array Input may report -901 sqlcode (probe 020 in sqlktopn(), msg=TQ already open)
DT214228 System/3 Message (MI) OOM because of large section size
DT222401 Performance (PR) A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT
DT236512 Abnormal End Of The Program (AB) Db2 trap due to ipcresources is NULL during db2fmp shutdown
DT239550 Coded Wait (WS) The package cache daemon leaves locks behind with DB2_VARLOCK_VARIANT_ENABLE enabled
DT147258 Abnormal End Of The Program (AB) IT35932: POSSIBLE FMP TRAP WHEN RUNNING DB2EXPLAIN WITH A STATEMENT CONTAINING UNESCAPED NEWLINE (\N) AND MULTIPLE SETS OF '(/)'
DT169432 Incorrect Output (IN) Warning message regarding stmmCreateVirtualSorts should be moved to STMM logs
DT188693 Abnormal End Of The Program (AB) Security: IBM Db2 is vulnerable to a denial of service as the server may crash when an Out of Memory occurs. (CVE-2023-26022)
DT197066 Abnormal End Of The Program (AB) FODC Trap in sqlra_find_var_var
DT208631 Abnormal End Of The Program (AB) Interrupt to fmp may generate many harmless but confusing error message in db2diag.log.
DT211306 Performance (PR) Excessive logging on interrupt in smp
DT212824 Abnormal End Of The Program (AB) FODC Generated When Wide Row Split Across TQ Buffers
DT238133 Incorrect Output (IN) CREATE PROCEDURE fails unexpectedly with SQL20204N
DT147383 Incorrect Output (IN) IT41074: INVALID DATE FORMAT WHEN INSERTING DATES
DT170011 Incorrect Output (IN) Using external UDF in recursive query executes only once and returns wrong number of rows
DT172803 Abnormal End Of The Program (AB) Possible 3 ways hang with FMP and 2 db2agent
DT223682 Abnormal End Of The Program (AB) On 11.5.8.0, java stored procedure may get an exception "java.security.ProviderException: Failed to initialize IBMJCEPlus provider"
DT224613 Abnormal End Of The Program (AB) Possible sustained trap sqlrr_rds_common_post() when Federated Query fails
DT239479 Incorrect Output (IN) PROCEDURE failed to execute jars from /function/jar/
DT128047 Incorrect Output (IN) IT40543: CONNECTION FROM DB2FMP TO THE ENGINE IS NOT CLEANED UP AFTER AN INTERRUPT
DT147693 Abnormal End Of The Program (AB) IT38953: POSSIBLE CORE FILE, TRAP WITH CORRUPTED STACK GENERATED BY DB2FMP WHEN QUERY IS INTERRUPTED
DT169902 Abnormal End Of The Program (AB) Big SQL instance panics with 'Corrupt pool free tree node' from sqloDiagnoseFreeBlockFailure()
DT172626 Coded Wait (WS) An unexpected program error in Db2 self tuning memory (db2stmm) may cause query or database hang
DT173315 Incorrect Output (IN) Wrong DateTime format or delimiter chosen
DT196650 Coded Message (MS) Rebind of a package defined in a module can incorrectly fail with a SQL0440N
DT208338 Incorrect Output (IN) select from DGTT may get wrong results if there is a regular table with the same schema and name
DT208575 Coded Message (MS) SQL0901 (Reason "usertemp inconsistent IUD")
DT213791 Abnormal End Of The Program (AB) DB2 may generate SQL0901N for blu insert query
DT228412 Abnormal End Of The Program (AB) Memory leak while using JSON_TABLE function in sql
DT238735 Abnormal End Of The Program (AB) INSTANCE MAY TRAP WITH POSSIBLE MEMORY CORRUPTION DETECTED
DT160513 Performance (PR) PERFORMANCE DOWNGRADED AFTER UPGRADING TO V11.1.4.7 DUE TO MORE CALL OF sqlra_compile_var
DT168876 Abnormal End Of The Program (AB) IN DPF, In an ERROR SCENARIO IF QUERY IS USING A VARIABLE, IT COULD FAIL WITH -901 or -902 (SQLKT_PGM_ERROR or SQLKT_SEVERE_PGM_ERROR)
DT173735 Performance (PR) PERFORMANCE has slowed down with "DYNAMIC SQL CACHE NON REUSE"
DT178557 Abnormal End Of The Program (AB) applications calling sqlugrpn() with datetime columns in distribution key may abort
DT187825 Performance (PR) When Statement concentrator (stmt_conc) is set to COMMENTS or COMM_LIT, it could result in leak of package cache memory and a reduced package cache hit ratio
DT198759 Incorrect Output (IN) FAILED_SQL_STMTS incorrectly increased the count when the DML statement failed to compile
DT211214 Loop (LP) Under certain conditions query cannot be forced when agent is looping in sqlriPercentileGetValue.
DT214258 Coded Halt (HL) fmp hung during force application
DT195953 Incorrect Output (IN) Incremental restore failing with SQL20569N
DT196248 Incorrect Output (IN) db2look generates an external table DDL that works on v11.5.5 but fails on later versions after two options became mutually exclusive
DT208624 Incorrect Output (IN) create external table when using option TRIMBLANKS BOTH trailing trimming does not work
DT209180 Abnormal End Of The Program (AB) LF/CR in quoted data results in failure when it appears in the last column, and the buffer ends with a record delimiter character
DT209301 Incorrect Output (IN) NULL character in FIXED FORMAT binary data causes SELECT failure VARBINARY
DT212411 Creation of a view on a transient external table results in error “SQL0901 No column information found in the packed descriptor”
DT221915 Incorrect Output (IN) DBMS_LOCK.REQUEST not returning correct status code.
DT169382 Abnormal End Of The Program (AB) External Table load failure when data file > 2MB contains sequential escape characters
DT188851 Incorrect Output (IN) DBMS_LOCK.REQUEST throws error SQL0206N incorrectly when the same lock is requested from a different session which is already being held by another session.
DT208377 Abnormal End Of The Program (AB) QUERY ON EXTERNAL TABLE HAVING BIGINT COLUMN FOLLOWED BY A COLUMN OF ANY DATA TYPE, FAILS WITH SQL20570N
DT213994 Incorrect Output (IN) Under certain conditions DBMS_LOCK.ALLOCATE_UNIQUE can return NULL LOCK HANDLE
DT149246 Abnormal End Of The Program (AB) When an external table command is run using the REMOTESOURCE option set to yes, and a scenario occurs where the coordinator is interrupted during the transfer of data from the remote source to the fmp process, a hang occurs.
DT213848 Incorrect Output (IN) DBMS_LOCK.REQUEST throws error SQL0431N and SQL0803N incorrectly when the same lock is requested from a different session which is already being held by another session.
DT147577 Abnormal End Of The Program (AB) IT41972: DB2 CRASH WHEN ALIAS IS USED TOGETHER WITH A PARTITIONED TRANSIENT EXTERNAL TABLE
DT189717 Incorrect Output (IN) SQL20569N Error when specifying encoding utf8 option for an external table created in a database with non-unicode code page
DT224383 Incorrect Output (IN) When the Db2 driver is repeatedly loaded and unloaded by an application, and the SSLServerCertificate parameter is configured, the in-memory keystore may leak a small amount of memory
DT237617 Incorrect Output (IN) db2look output truncated when a Trusted Context contains a large number of attributes
DT240334 Integrity Problems (IG) Pacemaker docs are being removed due to using an outdated opensource library.
DT172470 New Function (NF) REVERT GSK_MS_CERTIFICATE_STORE BEHAVIOUR AND CREATE A SEPARATE SETTING TO TURN ON MSCNG
DT173489 Integrity Problems (IG) Security: IBM Db2 is vulnerable to an information disclosure vulnerability due to improper privilege management when a specially crafted table access is used (CVE-2022-43927)
DT174059 Integrity Problems (IG) Security: IBM Db2 on Windows is vulnerable to an information disclosure vulnerability as sensitive information may be included in a log file. (CVE-2022-43930)
DT224740 Integrity Problems (IG) Security: In certain cases users with DATAACCESS authority can execute routines they are not authorized to (CVE-2023-38003)
DT224814 Abnormal End Of The Program (AB) Security: Db2 is vulnerable to a denial of service under certain conditions when creating a table (CVE-2023-38740)
DT228354 Coded Message (MS) JWTs(ACCESSTOKEN) exposed in CLI trace and SQLGetInfo
DT236921 Incorrect Output (IN) When TLS 1.3 is enabled, GSKit error 446 might be seen in the diagnostic log when a Java client closes a connection
DT173476 Integrity Problems (IG) Security: IBM Db2 for LUW is vulnerable to insufficient audit logging (CVE-2023-23487)
DT178890 Abnormal End Of The Program (AB) On Linux and AIX platforms with a fix for IT41557, DB2 may panic or hang after a password check times out
DT208180 Integrity Problems (IG) Security: IBM Db2 is vulnerable to remote code execution. (CVE-2023-29257)
DT209435 Incorrect Output (IN) CREATE DATABASE may result in a SQL0552N if the user only has SYSCTRL authority
DT223175 Integrity Problems (IG) Security: Db2 is affected by a vulnerability in GSKit (CVE-2023-32342)
DT236965 Integrity Problems (IG) Security: A vulnerability in libqb affects Db2 High-Availability deployments using Pacemaker (CVE-2023-39976)
DT208397 Integrity Problems (IG) SECURITY: IBM Db2 is vulnerable to information disclosure due to improper privilege management when certain federation features are used. (CVE-2023-29256)
DT211379 Integrity Problems (IG) Security: IBM Db2 JDBC driver is vulnerable to arbitrary code execution. (CVE-2023-27867, CVE-2023-27868, CVE-2023-27869)
DT215550 Integrity Problems (IG) Security: IBM Db2 is vulnerable to remote code execution. (CVE-2023-35012)
DT238702 Incorrect Output (IN) When an SSL error occurs, Db2 might only return an error code in the diagnostic log rather than a message
DT187810 Incorrect Output (IN) SQL1729N is encountered when attempting a CATALOG STORAGE ACCESS command with a KMIP or PKCS11 keystore
DT173780 Integrity Problems (IG) Security: IBM Db2 Connect Server is affected by an HTTPclient vulnerability (CVE-2014-3577)
DT239406 Integrity Problems (IG) Security: Db2 is vulnerable to privilege escalation or denial of service when using a specially crafted statement (CVE-2023-47701)
DT245990 New Function (NF) CHANGE THE DEFAULT TLS VERSION TO TLS 1.2
DT148117 Incorrect Output (IN) IT41276: SUSTAINED TRAP ON HADR STANDBY BLOCKS REPLAY-ONLY WINDOW
DT170023 Abnormal End Of The Program (AB) CF GBP missing detach failure
DT172758 Loop (LP) Backup latches caused system hang on the database where the backup is running.
DT208786 Abnormal End Of The Program (AB) Member may FODC when a RDMA adapter fails.
DT215935 Performance (PR) Host time going backwards causes purge in connections
DT237876 Abnormal End Of The Program (AB) Fix unnecessary wait for DPF partitions starting in a TSA automated environment
DT169658 Abnormal End Of The Program (AB) db2cm -delete -qdevice fails while QDevice host is down
DT170021 Abnormal End Of The Program (AB) SAL Panic, page name mismatch
DT195923 Abnormal End Of The Program (AB) db2cm -enable not working in a two-sites multiple standby cluster with same-site failover automation
DT198297 Integrity Problems (IG) HADR takeover by force fails when standby cannot resolve hostname of primary to IP
DT238214 Integrity Problems (IG) HADR_REMOTE_HOST changed from hostname string to IP address after takeover in HADR with multiple standbys environment
DT172989 Abnormal End Of The Program (AB) Db2 CLP by resource agents fails with SQL0332N error when database is used with locale that are incompatible with LANG C
DT180011 Abnormal End Of The Program (AB) Reduce CF memory by shrink of GBP structure fails with timeout after 5 minutes
DT189581 Title: Query on HADR standby is forced off when DROP TABLE with SESSION as schema name is executed on the HADR primary database
DT195910 Abnormal End Of The Program (AB) db2cluster -verify -req -rdma_ping times out when the cluster is configured to use significant number of RDMA adapters
DT198216 Abnormal End Of The Program (AB) db2start may fail when pacemaker is in the environment with an SQL1345 error
DT209734 Integrity Problems (IG) HADR_REMOTE_HOST changed from hostname string to IP address after takeover
DT221970 New Function (NF) "An unexpected error is encountered" can be observed in db2diag.log on RDMA pureScale clusters that have db2locssh configured for root ssh between hosts when ALM rdma ping running.
DT224539 Abnormal End Of The Program (AB) Primary database hangs while starting HADR on standby in pureScale.
DT147521 Abnormal End Of The Program (AB) IT39502: PRIMARY CF CRASH DUE TO ASSERT DURING MEMBER CRASH RECOVERY
DT180017 Incorrect Output (IN) False positive error in CF cfdiag when reducing container size
DT197154 Unpredictable (UN) Memory leak in db2fmd while monitored db2 instance is stopped.
DT225098 Incorrect Output (IN) userprofile banner causes HADR issues
DT238311 Abnormal End Of The Program (AB) Db2 pureScale members got trapped at libdb2cf_api.so.1 CF library
DT238653 Coded Message (MS) db2cm command returns list of parameters and it includes invalid parameter for Mutual Failover environment.
DT174277 Abnormal End Of The Program (AB) adding -remote_cmd option for db2cm fix to for systems with an ssh banner
DT178933 Incorrect Output (IN) db2cluster -verify -req -rdma_ping : performance statistics are missing into result files
DT223903 Additional Information (AI) Add a functionality to collect additional diagnostic data for a connection purge problem.
DT224776 Abnormal End Of The Program (AB) Setting the CF_MEM_SZ too high (around 1 TB) will cause the CF to crash
DT236712 Abnormal End Of The Program (AB) Starting HADR as primary in pureScale failed with ADM12509E reason code 6
DT237589 Incorrect Output (IN) Pacemaker may issue takeover back to original primary after graceful takeover to standby.
DT238689 Incorrect Output (IN) Incorrect pureScale alert while network interface failure
DT237784 Incorrect Output (IN) Rollback of transaction on event monitor table is not deferred on HADR TAKEOVER

DB2 Version 11.5 Fix Pack m8fp0
Known Issue Sev. Abstract
Fix Pack m8fp0  -   Availability
DT147361 2 IT40335: HADR STANDBY IS SHUTDOWN DUE TO NOT FINDING A LOG FILE RETRIEVED FROM ARCHIVE
DT080075 2 IT34214: STOP HADR ON PRIMARY HANGS WHEN HADR IS IN DISCONNECTED_PEER STATE
DT147360 2 IT40290: DB2FMTLOG TOOL DISPLAYS INTERNAL ERROR WHEN FORMATTING A DB2 LOGFILE.
DT148050 2 IT37338: CPU_UTILIZATION CAN BE SHOWING MORE THAN 100%
DT147341 2 IT39286: TOO MANY LOG FILES IN ACTIVE PATH ON HADR STANDBY
DT147913 1 IT40007: CONFIGURING HADR FOR TLS ON WINDOWS PLATFORM USING MICROSOFT CERTIFICATE STORE FAILS WITH SQL1768N REASON CODE 28
DT148461 2 IT40356: A DROP ROLE STATEMENT MIGHT TRIGGER ERROR TRYING TO WRITE A LOG RECORD EXCEEDING MAXIMUM SIZE
DT148627 3 IT39175: FLUSH BUFFERPOOL IS NOT SUPPORTED ON STANDBY WITH LOG_DDL_STMTS=YES
DT127114 2 IT39973: Frequent activation/deactivation can cause file handle leak and increase in memory on db2 server
DT148449 2 IT40091: DB2CKBKP FAILS TO VALIDATE REMOTE BACKUP
DT147303 2 IT38144: FALSE LOW LOG DISK SPACE WARNINGS IN DB2DIAG.LOG AT DATABASE ACTIVATION
DT148667 2 IT40906: BACKUP USING LIBDB2NX842_ENCR.A MIGHT RETURN SQL2079N WITH RC=1
DT148475 2 IT40877: RETRIEVE LOG FILE FAILED WITH SQLP_LOG_NOT_IN_ARCHIVE ERROR DUE TO SEARCHING WITH WRONG LOGCHAINID IN LOG ARCHIVE
DT148672 2 IT40975: MISLEADING DB2DIAG.LOG MESSAGE WHEN USING ZLIB BASED BACKUP OR LOG FILE COMPRESSION
DT147327 2 IT38859: DB2MOVE COPY FAILS WITH "INVALID OBJECT TYPE SPECIFIED"
DT147532 2 IT39956: ABNORMAL TERMINATION OF DATABASE WITH "ERROR DURING LOG PAGE VALIDATION." FROM SQLPGWLP, PROBE:390.
DT148119 2 TOO MANY LOG FILES IN ACTIVE LOG PATH ON HADR STANDBY AND ALSM ENABLED
DT147905 2 IT39846: HADR LOG SHIPPING MIGHT BE STUCK AFTER DB2 UPDATE ACROSS 11.5.6
DT148611 2 IT38555: DEADLOCK BETWEEN MANUAL RUNSTATS AND AUTO REORG RECLAIM ISSUED BY AUTO MAINTENANCE
DT147681 2 IT38504: ONLINE BACKUP MAY FAIL WHILE PROCESSING TRANSACTION LOG FILE - BAD PAGELSO FOUND FOR LOG FILE
DT148427 2 IT39080: MINBUFFLSN DOES NOT UPDATE FOR A LONG PERIOD OF TIME DURING RECOVERY
DT148430 3 IT39320: STALE VALUE OF LOG_EXTRACTION_DISK_SPACE_USED_TOTAL WITH ADVANCED LOG SPACE MANAGEMENT ENABLED
DT147895 2 IT39287: HADR STANDBY MAY TAKE LONGER THAN NORMAL TO REACH PEER STATE ON ACTIVATION
DT147517 3 IT39359: Db2 hangs with many EDUs waiting on logTailHeartBeatLatch
DT147954 2 IT41265: HADR PRIMARY MIGHT CAUSE A TRAP WHEN PROCESS IS SLOW AND PEER WAIT LIMIT REACHED
DT148118 2 IT41121: GENERATING A REDIRECTED RESTORE SCRIPT MAY CRASH INSTANCE IF STORAGE GROUP FILES BECOME CORRUPTED
DT147757 2 IT41134: IN A DPF, MULTI-NODE ENVIRONMENT, A BACKUP TO PIPE WON'T TERMINATE (CTRL+C OR FORCE APP) UNTIL BOTH ENDS OF THE PIPE ARE IN USE
DT147372 2 IT40758: HANG ON FIRST CONNECT DRIVING CRASH RECOVERY WHEN DB2LOGMGR HANGS DUE TO VENDOR PROBLEM
DT148659 3 IT40544: DATABASE NOT SHUTDOWN WHEN LOAD REPLAY FAILS ON HADR STANDBY WITH DB2_FAIL_RECOVERY_ON_TABLESPACE_ERROR ENABLED
DT147546 2 IT40651: DB2LOGGX PROCESS CONSUMING HIGH CPU
DT147368 2 IT40585: ONLINE BACKUP INCLUDE LOGS MIGHT FAIL WITH ADM8010E
DT147543 2 IT40442: ON AIX GETMAXCOMPRESSEDSIZE MIGHT RETURN A TOO LOW VALUE
DT147733 2 IT40474: DB2 ZLIB BACKUP AND LOG FILE COMPRESSION DOES NOT USE HARDWARE ACCELERATION ON UBUNTU
DT140019 2 IT41420: TABLESPACE ROLLFORWARD IS VERY SLOW DUE TO EXCESSIVE NUMBER OF SQLBAFLSH() CALLS
DT147767 3 IT41547: INSTANCE CRASHED WHEN MULTIPLE CONNECTIONS IMPLICITLY ACTIVATE DATABASE WITH DIFFERENT CODEPAGE SETTING.
DT147768 2 IT41626: CRASH RECOVERY AFTER A DATABASE ROLLFORWARD TO POINT IN TIME THAT INCLUDES AN INDOUBT TRANSACTION FAILS WITH SQL1265 (ADM1532E)
DT147876 2 IT38402: DB2 IS FORCED SHUTDOWN WHEN IT ATTEMPTS TO PROCESS XAEND
DT148308 2 IT41729: TRANSACTION MAY NOT BE RESOLVED COMPLETELY IF A TABLESPACE IO ERROR IS ENCOUNTERED DURING RECOVERY WITH DB2_ONLINERECOVERY.
DT147772 2 IT41873: INCORRECT NUMBER OF LOG RECORDS COPIED FROM EXTRACTION LOG FILES
DT148312 2 IT41907: CRASH RECOVERY OF CIRCULAR LOGGING DATABASE FAILS WITH ADM1601E
DT145587 2 IT41639: EXCESSIVE DB2DIAG ENTRY FROM SQLPGRETRIEVELOOKUP
DT147703 2 IT39298: HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK
DT142794 3 IT40564: DROP STORE PROCEDURE MIHGT CAUSE TRAP
DT148464 3 IT40526: HADR STANDBY FAILS WITH SQLRLC_FIND_LATCH_ANCHOR() PROBE:5 "INVALID ENTRY_TYPE" CALLED BY SQLPRDBREDOROSCATCACHEINV()
DT148300 2 IT41403: CRASH IN SQLPGETLOGTAILHEARTBEAT()
DT148111 2 IT41071: HADR STANDBY LOG REPLAY CANNOT KEEP UP WITH PRIMARY
DT148663 2 IT40735: DB2ICRT ?TBDEV COMMAND COULD OVERRIDE DISK SCSI-3 DISK CONFIGURATION
Fix Pack m8fp0  -   Storage and Compression for Column-Organized Tables
DT147331 2 IT39064: FODC_Trap when printing mVariableBuffer during out-of-memory error
DT147557 2 IT41115: Query fails with SQL0901N and assertion failure "Evolved dictionary TSN cannot be larger than the last used TSN"
DT132779 2 IT40083: WRONG RESULT IS POSSIBLE IN COLUMNAR QUERY WITH REAL, FLOAT, OR DOUBLE COLUMNS AND RANGE PREDICATES WITH NEGATIVE VALUES
DT147723 2 IT40043: MEMORY LEAK IN COLUMNAR PAGE COMPRESSION CODE
DT148075 2 IT38961: HANG WAITING FOR LATCHES INSERTRANGE__MTABLEWRITERLATCH AND INSERTRANGE__MCONCURRENTINSERTLATCH
DT148505 2 IT41465: ADD ASSERTS TO PREVENT TRAP IN PAGEWRITECALLBACK METHODS
DT148500 2 IT41428: ADDITIONAL DIAGNOSTICS FOR SKILLS CASE TS009760113 (TRAP IN COLUMNDICTIONARYVERSIONBASE::GETSIZE)
DT148491 3 IT41301: ADD ASSERT TO RULE OUT POSSIBLE CAUSE OF Known Issue IT41275
DT134109 3 IT41211: A TRAP DUE TO A SIGNAL 11 CAN OCCUR IN THE MEMORY CLEAN UP DAEMON.
DT133462 2 IT40407: SQL0954C, SQL0973N, OR OTHER OUT OF MEMORY ERROR WHEN BUILDING COLUMN DICTIONARY FOR LONG STRING COLUMN
DT147732 2 IT40412: PERFORMANCE DEGRADATION IN MPP SETUP WITH SQLCODE: -391 ERRORS IN DB2DIAG.LOG AFTER TRUNCATE WITHOUT IMMEDIATE ON REPLICATED MQT
DT147958 2 IT41486: CONVERT TRAP IN DATABASETABLEACCESSOR::GETCOLUMNDICTIONARYVERSIONBASE TO SQL0901N MESSAGE
DT147765 2 IT41464: SEVERE ERROR AND POSSIBLE MEMORY CORRUPTION DETECTED WHEN FUNCTION SQLRKRPC_FREEMSG TRIES TO FREE MEMORY
DT147369 2 IT40685: LOAD RESETDICTIONARYONLY IS INCOMPATIBLE WITH BLOCKNONLOGGED
DT168621 2 Assertion failure "FreeExtentMarker::isValid(&page) && ( !page.getPageIsForInsertGroup() || FreeExtentMarker::isWithUncondPastRedoInit(&page))"
DT161029 2 INSERT fails with BAD PAGE error due to Reorg Recompress concurrency issue
Fix Pack m8fp0  -   Client
DT171380 2 IT40596: Driver throws ARRAYINDEXOUTOFBOUNDEXCEPTION in SQLJ heterogeneous batch environment
DT171402 2 IT41198: JCC DRIVER RETURNS -204 DUE TO IMPROPER SCHEMA ORDER REPLAY WHENUSING SYSPLEX WLB
DT143276 2 IT41270: ERRORCODE=-4474 RETURNED FROM JCC DRIVER FOR SET CURRENT PACKAGEPATH WHILE REUSING THE CONNECTION FROM THE POOL
DT143251 2 IT41578: IF XAER_RMFAIL RECEIVED WHILE READING A RESULTSET FROM APPLICATION THEN CONNECTIONEVENT LISTENER NEED TO RAISE XAER_RMFAIL EVENT
DT148122 2 IT41418: FEDERATION ZOS DB2 REPORT SQL0181N THE STRING REPRESENTATION OFA DATETIME VALUE ERROR WHEN QUERY WITH DATE AND TIMESTAMP COMPARED
DT160547 2 Setting QUERYPREFETCH=1 causes a segmentaion violation in DB2 ODBC and CLI driver
DT171400 2 IT38691: DECIMAL PRECISION DIFFERENCE IN JDBC WITH ORA & NON-ORA SETTING
DT171385 2 IT39194: INITIAL CONNECTION ERRORS LIKE -4499 ARE NOT COLLECTED IN DIAGNOSTIC DATA THROUGH DB2.JCC.DIAGLEVELEXCEPTIONCODE SETTING
DT171378 2 IT39628: JDBC ERROR "UNRECOGNIZED JDBC TYPE: 2011 ERRORCODE=-4228, SQLSTATE=NULL " WITH JDBC
DT171377 2 IT39269: NOSQLJSON SERIALIZER CRASHES WHEN NULL IS THE VALUE FOR JSON KEY
DT171415 2 IT39268: JSON WIRE LISTENER FAILS WHEN REGEX IS USED IN FIND COMMAND
DT133003 2 IT40903: MEMORY LEAK WHEN SQLGETCONNECTATTR() IS CALLED WITH THE SQL_ATTR_GET_LATEST_MEMBER ARGUMENT
DT171405 2 IT39267: NOSQL JAVA DRIVER THROWS RUNTIMEEXCEPTION FOR $SAMPLE IN AGGREGATE PIPELINE
DT171389 2 IT34348: .NET DRIVER CRASH DUE TO A TIMING HOLE
DT171394 2 IT39265: WIRE LISTENER FAILS TO ACCEPT NEW COMMAND POST EXCEPTION
DT171410 2 IT39266: WIRE LISTENER DO NOT HONOR THE LIMIT OPTION USED WITH FIND COMMAND
DT171401 2 IT39264: ROBO3T MONGODB TOOL THROWS ERROR POST UPDATE OR DELETE OF A JSONDOC IN A COLLECTION
DT171376 2 IT39058: CLPPLUS FAILS TO FLOW COMMIT FOR WARNING CASE SCENARIOS FROM STACOMMAND WHEN RUN AS A SCRIPT
DT171393 2 IT39263: NOSQLBOOSTER TOOL FAILS TO CONNECT TO WIRE LISTENER DUE TO MISSING SUPPORT FOR GETFREEMONITORINGSTATUS COMMAND
DT168593 1 IT40381: TRACEABILITY FOR LINE# AND FILE NAME IN DB2 .NET FOR FW AS WELL AS CORE RUNTIMES TO BE STAMPED IN MEM DIAGNOSTICS.
DT146491 1 IT36527: DB2 CLI APPLICATION MAY FAIL TO RETRIEVE LOB VIA STREAMING WITH ERROR -902 (RC 9) WHEN DATA_ENCRYPT IS SET
DT168594 3 IT41671: IN ODBC ADMINISTRATOR FIX SSL RELATED KEYWORD GUI OPTIONS AND FIX DBALIAS GETTING SAVED IN DB2CLI.INI FILE
DT141609 2 IT41590: INSERTING DECIMAL DATA VIA SQL_C_NUMERIC -> SQL_DECIMAL BIND-IN THROUGH ARRAY INSERT THROWS CLI0111E
DT127662 3 IT40458: RESULTSET.DELETE() METHOD RETURNS CLI0119E WITH SQLSTATE 58004
Fix Pack m8fp0  -   Catalog Services
DT148083 2 IT39321: SQL0818N CAN OCCUR AFTER A ROLLED BACK REVALIDATION
DT147165 2 IT35294: Authorization errors in accessing CGTTs after a transfer owner of a SQL routine.
DT148072 2 IT38739: MEMORY LEAKS OCCURRING ON COLUMN-ORGANIZED DGTTS
DT142487 2 IT40917: LATCH CONTENTION SQLO_LT_SQLRLC_ANCHOR_COMMON__ANCHOR_LATCH DURING SCHEMA AUTHORITIES CHECKS
DT148677 2 IT41440: DB2 MAY GENERATE FODC TRAP WHILE RUNNING A PROCEDURE
DT147538 3 IT40250: SQLRLC_EXECUTE_EVENT, PROBE:20 IS LOGGED AS ERROR
Fix Pack m8fp0  -   Connectivity
DT148492 2 IT41322: FIXING RCCOPENDUMMYCONNECTION TO USE SQLCC CALLS INSTEAD OF DRDATO ATTEMPT TO OPEN AN SSL CONNECTION WITH TARGET SERVER.
DT147729 2 IT40256: A PREVIOUS SETTING OF CURRENT PACKAGESET MAY BE REUSED WHEN EXECUTING FENCED STORED PROCEDURES WHEN KEEPFENCED IS SET TO YES RES
DT148254 2 IT39347: ERROR ADM7009E AFTER UPGRADING TO 11.5
DT147890 3 IT39092: UNCATALOG ODBC DOESN'T REMOVE ENTRY FROM DB2CLI.INI
DT117148 0 IT38866: INCORRECT LICENSE CHECK FOR INFORMIX DB WITH TRUSTED CONTEXT RELATED VERIFICATION
DT148442 2 IT39763: MORE ROBUST SIGNAL HANDLING ADDED TO COMMAND LINE OPERATIONS.
DT147520 1 IT39488: MULTI ROW FETCH IN DB2 11.5 LUW MAY NOT GIVE EXPECTED RESULTS
DT147556 2 IT41052: DB2 EXTERNAL TABLE CREATED WITH (SELECT.... LIMIT 0) FAILS WHILEINSERTING ROWS WHEN DB2_ENABLE_COS_SDK PARAMETER IS SET TO ON
DT147394 3 IT41518: LOAD FROM EXTERNAL TABLE FAILS AT 18,993 ROWS
DT148306 2 IT41623: REMOTE CLIENTS MAY NOT BE ABLE TO INTERRUPT QUERIES WITH SSL ONLY SERVER CONFIGURATIONS.
DT148124 2 IT41485: PACRALTSRVLST IS NOT NULL SPAMMING THE DB2DIAG.LOG
DT148682 2 IT41604: CLIENTS FAIL TO RECONNECT TO PURESCALE WITH TCP AND SSL SERVER CONFIGURATION
Fix Pack m8fp0  -   Connectivity - External Table
DT148470 2 IT40634: USE OF EXTERNAL TABLE WITH REMOTESOURCE OPTION AND LOAD CURSOR RESULTS IN A CRASH OF THE DATABASE
DT147901 2 IT39616: EXTERNAL TABLE FIXED FORMAT LOAD FAILURE OF REAL DATA
DT148235 3 IT38615: EXTERNAL TABLE FIXED FORMAT LOAD OF VARCHAR WITH REFERENCE COLUMN 0 FAILS
DT147699 2 IT39208: DB2WH IS INTERPRETING A 0X00 BYTE IN THE DATA AS SIGNALING EOF.
DT146617 3 IT36368: SELECT FROM EXTERNAL FILE FAILS WITH SQL0644N WHEN TABLE IS DEFINED IN A NON-DEFAULT TABLESPACE WITH A DIFFERENT DB PARTITION GR
DT147567 2 IT41475: OVERFLOW OCCURRED WHILE PERFORMING CONVERSION FROM CODEPAGE 923 TO CODEPAGE 1208 FOR COLUMN AT INDEX 44"
DT148796 1 Select from external table might hang when escaped field delim is present in data with LFINSTRING TRUE and CRINSTRING TRUE.
DT160131 2 IT42092: EXTERNAL TABLE LOAD WITH COS AND PARTITION (EXPLICITLY DEFINED PARTITION STRING) CAUSES HANG
DT147344 2 IT39487: EXTERNAL TABLE FIXED FORMAT LOAD OF [VAR]BINARY[N], BLOB[N] FAILING
Fix Pack m8fp0  -   Connectivity - Text Search
DT147761 2 IT41219: DB2 MAY TRAP AFTER SUCCESSFULLY UPDATING A TEXT SEARCH INDEX DUETO AN INCORRECT SQLCA
DT148490 3 IT41228: BAD PLAN CAUSED BY TEXT SEARCH CONTAINS() USING THE DEFAULT FILTER FACTOR
DT146331 2 IT35124: CLASS NOT FOUND EXCEPTION: COM.IBM.DB2.INSTALL.CODEGEN.NLPACK INITIALIZER IN DB2SETUP.ERR
DT147942 2 IT40899: SQL0802 ARITHMETIC OVERFLOW ERROR OCCURS DURING TEXT SEARCH INDEX CREATION
Fix Pack m8fp0  -   Data Management
DT148669 2 IT40885: DEADLOCK BETWEEN TWO DROP TABLE STATEMENTS, EACH EXECUTING ABP'SDROPPED-OBJECT CANCELLATION.
DT148476 2 IT40894: DB2PD -LATCHES COMMAND WITH THE "GROUP" SUBOPTION MIGHT NOT REPORT LATCH HOLDERS CORRECTLY
DT147940 2 IT40872: NOT ALL IMAGE SEQUENCES UPLOADED TO REMOTE STORAGE DURING BACKUPWHEN USING SMALL MULTIPARTSIZEMB
DT148486 2 IT41162: SQLOSSIG, PROBE:10 DB2DIAG.LOG MESSAGE IS WRITTEN TO DB2DIAG.LOG REGARDLESS OF DIAGLEVEL SETTING
DT148110 2 IT40858: PURESCALE: Free space search during insert of a record might endprematurely.
DT148093 2 IT39870: CRM STATUS COMMAND REPORTS INCORRECT STATUS OF RESOURCES"
DT148438 2 IT39703: BUFFER POOL EVENT RECORDER LEAKS MEMORY IF CRASH RECOVERY FAILS
DT148439 2 IT39719: DATA SERVER DRIVER LIBDB2.SO.1 MISSING SYMBOLS ON LINUX X86_64
DT148649 2 IT40061: BACKUP WITH DB2_RESOURCE_POLICY ENABLED MAY IMPACT SYSTEM PERFORMANCE MORE THAN WHEN DISABLED
DT172292 2 Running the LOAD command from 11.5.7 client to earlier-level11.5.x server (i.e. 11.5.0 to 11.5.6) fails
DT147902 2 IT39747: AVOID DB2 CRASH IF INSTANCE RUNS OUT OF FILE HANDLES.
DT148063 2 IT38384: DB2 ABENDS WHILE PAGE CLEANER EXECUTING SQLBCLNRGATHERFORHATETHRESH
DT148242 2 IT39050: BUFFER POOL PAGE PINCOUNT LEAKED DURING PAGE P-LOCK ACQUISITION
DT148269 2 IT40222: DB2 CRASH IN DB2PERF!SQLONTPPUTMSG
DT097587 2 IT36242: ADMIN_GET_MSGS() MAY RETURN MIX OF MESSAGE UNDER RARE TIMING HOLE.
DT148228 3 IT38409: NO WARNING MESSAGE WHEN DMS TABLESPACE CANNOT BE IMMEDIATELY EXTENDED WHILE AN ONLINE BACKUP IS IN PROGRESS
DT147661 1 IT37712: SECURITY: IBM DB2 MAY BE VULNERABLE TO AN INFORMATION DISCLOSURE UNDER CERTAIN CIRCUMSTANCES WITH LOAD UTILITY (CVE-2021-20373)
DT147924 2 IT40275: DB2 BACKUPS FAIL WITH SQL2025N AN I/O ERROR OCCURRED. ERROR CODE: "-2029059658" WHEN STREAMING IS ENABLED
DT148495 2 IT41384: DB2 ENTERPRISE SERVER (DB2ESE) COMPLIANCE REPORT SHOW INDEX COMPRESSION LICENSE VIOLATION ON V11.5.6 AND 11.5.7
DT147728 2 IT40226: HANG CAN OCCUR WITH INTRA_PARALLELISM ENABLED WHEN INDEX GETS CREATED
DT148236 2 IT38684: MEMBER CRASH RECOVERY MIGHT FAIL OR TABLE DATA COULD BE BAD IF CRASH OCCURS WHILE ONLINE TABLE REORGANIZATION IS RUNNING
DT147553 2 IT40806: TRUNCATING TABLE SPACE FILES (SQLSPCS.1/2) LARGER THAN 4GB MAY FAIL
DT148657 2 IT40520: SQLO_URL_UNKNOWN_HEADER RETURNED WHEN S3 BUCKET IS USING KMS ENCRYPTION
DT148123 2 IT41429: DB2_RESOURCE_POLICY DOESN'T WORK WITH DB2 ADVANCED EDITION
DT148292 2 IT41038: POSSIBLE DEADLATCH IN SQLOMEMINIT() WHEN IT LOADS CLIENT-SIDE LIBRARY
DT147925 2 IT40291: DB2PD -HELP RETURNS INCORRECT OPTION SYNTAX FOR -TCBSTATS
DT148654 2 IT40293: "GRANT DATAACCESS ON SCHEMA" PREVENTS LOAD WHEN MODIFIED BY "DUMPFILE DUMPFILEACCESSALL"
DT148472 2 IT40804: AUTO TABLE MAINTENANCE DB2ACD PROCESS FAILS TO CONNECT TO DATABASE WHEN DB2CLI.INI CONFIGURED TO ENFORCE TCP CONNECTIONS
DT171404 2 IT39128: CRASH WHILE CREATING ODBC DATA SOURCES FILE DSN ON WINDOWS PLATFORM USING DB2 ODBC CLI DRIVER
Fix Pack m8fp0  -   Data Management: Bufferpool
DT148474 2 IT40819: REORG NOT RECLAIMING EXTENTS FOR ITC TABLES EFFICIENTLY.
DT147918 2 IT40063: DGTT MAY FAIL WITH SQL0289N WHEN UNDERLYING TEMP TABLE SPACE DEFINED IN LARGE FILESYSTEM
DT147536 2 IT40191: BLOCK CREATING BUFFERPOOLS WITH THE SAME NAME AS THE SYSTEM BUFFERPOOLS
Fix Pack m8fp0  -   Data Movement Utilities
DT148078 3 IT39114: ADMIN_MOVE_TABLE ESTIMATE IS INCOMPATIBLE WITH BLOCKNONLOGGED
DT147321 3 IT38560: INGEST RESULT OUTPUT WRONGLY SHOWS "NUMBER OF ROWS INSERTED = 0"INSTEAD OF "NUMBER OF ROWS UPDATED / DELETED = <NUM>"
DT147688 2 IT38790: THE ADMIN_MOVE_TABLE PROCEDURE MAY STUCK IN CANCEL PHASE.
DT147533 2 IT39993: STRIPTNULLS MODIFIER IN LOAD AND IMPORT COMMANDS TRUNCATE NULLS (0X00) FROM GRAPHIC (FIXED-LENGTH) COLUMN, BUT IT SHOULD NOT
DT148238 2 IT38893: ADMIN_MOVE_TABLE WITH COPY_STATS MIGHT INVOKE LONG RUNNING RUNSTATS
DT147390 2 IT41348: DB2MOVE RETURNS SQL0206 WHEN EXECUTE INVALID STATEMENT SELECT OWNERTYPE FROM SYSIBM.SYSROUTINES
DT147929 2 IT40463: ADMIN_MOVE_TABLE RETURNS SQL20491N RC 6 FOR USER MAINTAINED TEMPORAL TABLES
DT147878 2 IT38519: ADMIN_MOVE_TABLE MIGHT FAIL IF TABLE HAS STATISTICS PROFILE CONTAINING COLUMN NAMES WITH SINGLE QUOTES
DT148279 2 IT40604: ADMIN_MOVE_TABLE COPY_STATS MIGHT FAIL IF SYSSTAT.COLDIST CONTAINS NON-PRINTABLE CHARACTERS
Fix Pack m8fp0  -   Deployment
DT054546 4 IT31631: CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT (CREATEINSTANCE)
DT148048 4 IT37187: ADD REQUIRED GPFS PACKAGE NET-TOOLS RPM TO DB2PREREQCHECK
DT148466 4 IT40553: DB2IUPDT -CHECK_COMMIT COMMAND DOES NOT RETURN MEANINGFUL ERROR
DT147224 4 IT28668: THE COMPONENTLIST_SERVER_T.HTM FILE AND DB2LS -Q COMMAND OUTPUT ARE INCONSISTENT
DT147713 4 IT39760: ON AIX WHEN A SCRIPT NEEDS TO EXECUTE DB2PROFILE IN A LOOP, LIBPATH HAS MULTIPLE REFERENCES TO GSKIT
DT148272 4 IT40294: WHEN RUN DB2SETUP OR DB2ICRT ON AIX, THE OUTPUT MAY BE CORRUPTED.
DT072515 2 IT33388: V11.5 DB2IUPGRADE DOES NOT CHANGE SUB DIRECTORIES' PERMISSION UNDER SQLLIB PROPERLY
DT147824 4 IT32790: DB2_DEINSTALL NON-PURESCALE COPY OF DB2 CHANGES CONFIGURATION OFGPFS USER MANAGED CLUSTER
DT146371 2 IT37290: IN-PLACE INSTALLFIXPACK MINOR ERROR WITH DAS
DT147529 2 IT39904: DB2PD -STACK ALL IS NOT WORKING ON WINDOWS
DT148433 1 IT39389: SECURITY: APACHE LOG4J REMOTE CODE EXECUTION - LOG4SHELL (CVE-2021-44228, CVE-2021-4104)
DT147343 2 IT39404: CLIENT CONNECTIONS SLOW TO DATABASE SERVER
DT147275 3 IT36769: DB2FMCD.SERVICES GETS DELETED IF THERE ARE TWO DB2 SETUPS AND ONE GETS REMOVED
DT159579 1 IT31637: SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204)
DT147135 3 IT34243: DB2CLUSTER -CFS -COMMIT FAILS, INSTALL SHOULD GENERATE A WARNING
DT148303 2 IT41487: INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX
DT148092 4 IT39766: DB2PREREQCHECK WITH THE -HL OPTION FAILS IF THE CONTENTS OF THE HOSTS FILE ARE NOT CORRECT
DT147900 3 IT39752: DB2ICRT & DB2IUPDT MAKE USE OF THE /DB2LOG DIRECTORY AND MAY OVERWRITE IT
Fix Pack m8fp0  -   Federation
DT148451 2 IT40161: REMOTE STATEMENT HAS WRONG ORDER BY COLUMN SINCE V11.1
DT147948 2 IT41139: DB2 FEDERATION RETURNS BLANK SQLSTATE FOR SQLCODE=100 THAT WILL CAUSE WRONG ERROR MESSAGE OF NICKNAME IUD
DT148673 2 IT41019: FEDERATION: POSSIBLE -430 ERROR WHEN CONNECTING MYSQL-CE VIA JDBC CONNECTIONWITH JRE VERSION 1.8.0 BUILD 8.0.7.5 (SR7 FP5)
DT147730 2 IT40261: FEDERATION: COLUMN LENGTH AUTO VARIATION (COLUMN_LENGTH_AUTO_VARIATION) CANNOT BE DISABLED WHEN TARGET DATABASE IS ORCALE
DT147927 2 IT40384: FEDERATION: ORACLE DATA SOURCE, CREATE NICKNAME TOO MANY TIMES MIGHT CAUSE "ORA-01000: MAXIMUM OPEN CURSORS EXCEEDED" ERROR
DT148105 2 IT40372: FEDERATION FAILED TO GET ZOS DB2 COBOL PROCEDURE PARAMETERS
DT147523 2 IT39544: GRAPHIC AND CHARACTER CONVERTS WRONG WHEN CODEPAGES OF FEDEDERATION DB AND REMOTE DB ARE DIFFERENT
DT147897 4 IT39474: SECURITY: Multiple vulnerabilities in Apache Log4j affect some features of IBM Db2 (CVE-2021-45046, CVE-2021-45105)
DT147563 2 IT41289: MEMORY LEAK IN SQLQG_MISC_FMP.C WHILE IMPORT DATA INTO NICKNAME WHEN WRAPPER OPTION "DB2_FENCED' TO 'Y'
DT147330 2 IT39055: FEDERATION CREATE SERVER TYPE OPTIMIZATION FOR ODBC WRAPPER
DT148679 2 IT41542: FEDERATION SQL0802N ARITHMETIC OVERFLOW OR OTHER ARITHMETIC EXCEPTION OCCURRED
DT148307 1 IT41637: IN DPF ENVIRONMENT, FEDERATION FMP COULD BE INTERPRETED BY OTHERINTERRUPT REQUEST FROM DB2 ENGINE.
DT148305 2 IT41617: DB2 NICKNAME CREATION FOR TABLE OR VIEW IN REMOTE AWS ATHENA FAILS WITH SQL1822N AFTER UPGRADING JAVA IN AIX
DT147392 2 IT41496: FEDERATION MSSQL SERVER SQL0142N THE SQL STATEMENT IS NOT SUPPORTED
DT148299 2 IT41331: CLI0125E FUNCTION SEQUENCE ERROR DUE TO DRDA_STATEMENT NOT OPEN
DT148087 2 IT39471: DB2V115_START.KSH: FAILS TO FIND SERVICE PORT ON NON-ENGLISH LOCALE
DT148502 2 IT41644: SQL1822 ON FEDERATION SERVER BETWEEN UTF8 AND ISO-1 DATABASE WHEN THE SERVER OPTION IS STRING_UNITS 'S'
Fix Pack m8fp0  -   Process Model
DT147938 2 IT40749: ONLINE BACKUP MAY FAIL WITH SQL5193N IF DATABASE IS CREATED IN RESTRICTIVE MODE
DT148671 2 IT40926: DB2EVMONFMT MAY FAIL WITH SQLCODE=-104 WHEN USING THE -WTT OPTION
DT147384 2 IT41130: INSTANCE CRASH IN SQLMON_STMT::ESTIM_STMT_INFO_SZ
DT147731 2 IT40287: THRESHOLD DOES NOT FIRE WHEN CONCUR_OVERFLOW_ENABLED AND CONCUR_OVERFLOW_MAX ENABLED
DT148460 2 IT40343: DB2 CRASHES IN SQLECHECKBREATHINGPOINTWLMTHRESHOLD DURING SET WRITE RESUME
DT147911 3 IT39981: LIST ACTIVE DATABASE SHOWED DB NAME , EVEN IF DATABASE WAS DEACTIVATED
DT147483 2 IT37396: IN DPF SQL USING EARLY CLOSE MAY INCREASE FCM BUFFERS UNTIL APPLICATION TERMINATION
DT147921 2 IT40154: THE MON_GET_PKG_CACHE_STMT TABLE FUNCTION MAY TRAP WHEN AN SQL STATEMENT HAS COMMENTS > 10K AND STMT_CONC IS SET TO COMM_LIT
DT147917 2 IT40049: THE MAXIMUM NUMBER OF FCM SESSIONS IS NOT SET PROPERLY ON AIX
DT147357 2 IT40122: "FODC PANIC DUE TO STALE POINTER IN SQLEUCBLASTDIAGPOOL"
DT147909 2 IT39957: APPLICATION MAY HANG IN GETFASTWRITERRECORD IF THE INTERNAL POOLFOR EVENT MONITORING IS EXHAUSTED.
DT147907 2 IT39938: POSSIBLE MEMORY CORRUPTION WHEN CALLING PD_GET_DIAG_HIST
DT148635 2 IT39473: ARCHIVING DB2DIAG.LOG AND NOTIFICATION LOG (*.NFY) CAN LEAD TO DOUBLE FREE IN SQLRWCLEANUPWLMSCRATCHPAD WHEN RUNNING PD_GET_DIAG
DT147906 2 IT39877: DB2START IS FAILED WITH -1677 ERROR WHEN EACH MEMBER HAS A CONFIGURED INSTANCE_MEMORY VALUE AND THERE IS A GLOBAL INSTANCE_MEMOR
DT147651 2 IT37104: POSSIBLE TRAP FOLLOWING DB2DIAG.LOG MESSAGE "TRYING TO REGISTER AN INVALID SERVICE CLASS ID OF 0"
DT148255 2 IT39331: STATS_ROWS_MODIFIES REPORTS 4294967295 FROM MON_GET_TABLE AND ADMIN_GET_TAB_INFO
DT147336 1 IT39184: IF MONHEAP IS EXHAUSTED SQL STATEMENTS MAY RECEIVE SQL0973N FOR MON_HEAP_SZ
DT120319 1 IT39148: IPC connection to Db2 11.5 FP6 from a downlevel client might fail with -1224 and SQLO_NOSEG+EACCESS error logged to db2diag.log
DT148263 2 IT39875: LOCKING EVENT MONITOR "DROPPED RECORD" EVENT LEADS TO THE FLOOD OF DB2DIAG.LOG WARNING MESSAGES
DT148489 2 IT41227: WHEN THE ATS FAILS TO RUN A TASK, IN SOME CASES THE TASK MAY REMAIN IN RUNNING STATE
DT147939 2 IT40849: APPLICATION MAY HANG IN WaitSendReady WHEN SENDING AN RPC MESSAGE
DT147937 1 IT40723: DB2STOP MAY TIMEOUT ON A PARTITIONED DATABASE DUE TO A LATCHING PROTOCOL PROBLEM
DT148283 2 IT40670: SQL1611W - NO DATA WAS RETURNED BY DATABASE SYSTEM MONITOR FOR "DB2 LIST ACTIVE DATABASES" DURING SET WRITE SUSPEND.
DT147740 2 IT40614: SQL0952N MIGHT HAPPEN WHEN REAL-TIME STATISTICS IS ENABLED FOR COLUMN-ORGANIZED TABLES
DT147366 2 IT40515: DB2ACD FAILS TO EXECUTE SCHEDULED TASKS WHEN THERE IS A DB2CLI.INI FILE
DT148678 3 IT41503: MONITOR ELEMENTS IN THE ACTIVITY EVENT MONITOR THAT DEPEND ON SNAPSHOT MAY BE INCORRECT FOR CREATE/DECLARE TABLE AS STATEMENTS
DT147959 2 IT41546: PERFORMANCE IS AFFECTED BY LATCH CONTENTION WHEN INPUT DATA VALUE CAPTURE IS ENABLED FOR A LOCKING EVENT MONITOR
DT148310 2 IT41782: CON_LOCAL_DBASES COUNTER IN MON_GET_INSTANCE MAY RETURN AN INCORRECT VALUE IF A DATABASE IS DEACTIVATED WHILE QUIESCED
DT147770 2 IT41807: DB2 TRAPS IN MON_GET_PKG_CACHE_STMT ON WINDOWS
DT147745 1 IT40751: RARE TIMING SCENARIO IN UPGRADE OF PURESCALE CLUSTERS CAN PREVENT CF MEMORY ALLOCATIONS FROM BEING ADJUSTED AUTOMATICALLY
DT147385 2 IT41143: POSSIBLE MEMORY LEAK USING PD_GET_DIAG_HIST()
DT147387 2 IT41259: GW_* METRICS ARE ZERO IN MON_GET_INSTANCE
DT147570 2 IT41556: WHEN USING AUTOSTART WRITE TO TABLE EVENT MONITORS, DATABASE ACTIVATION MAY HANG OR BE DELAYED IF A Z LOCK IS HELD ON ONE OF THE
DT148296 2 IT41222: IMPROVE DIAGNOSTICS FOR FCM DOUBLE FREE OF A CHANNEL
Fix Pack m8fp0  -   Query Compiler
DT171386 2 IT39262: WIRELISTENER THROWS EXCEPTION WHEN AGGREGATE PIPELINE CONTAINS $INDEXSTATS
DT058197 2 IT31963: BAD PERFORMANCE FOR MODIFYING QUERIES DUE TO NO SEMIJOIN REWRITE
DT147943 2 IT40984: PERFORMANCE (HANG) ISSUE WHILE PROCESSING STACK OF NESTED TABLESWITH COMPLEX EXPRESSIONS
DT147738 2 IT40537: A FULL OUTER JOIN QUERY MAY PRODUCE A -901 WITH THE REASON "EMPTY PLAN LIST DETECTED!"
DT146727 2 IT35054: COLUMN-ORGANIZED EARLY UNIQUE AND SEMIJOIN TOGETHER RESULT IN SQLCODE -901
DT148284 2 IT40755: SQLCODE -901 MAY OCCUR WITH MESSAGE "EMPTY PLAN LIST DETECTED" WHEN COMPILING A CDE QUERY
DT133017 2 IT41027: CARDINALITY MIGHT BE OVERESTIMATED WHEN TABLE CARDINALITY BOUND ADJUSTMENTS ARE ENABLED AND JOIN CYCLES ARE PRESENT"
DT147952 2 IT41223: ISSUING A CREATE TABLE QUERY MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY ON AIX
DT147758 2 IT41082: DB2 SERVER TERMINATES ABNORMALLY WHEN STATEMENT CONCENTRATOR ENABLED
DT147756 2 IT41124: POOR PERFORMANCE FOR NLJOIN IN CDE
DT148294 4 IT41132: DB2 QUERY MAY GENERATE 901 WHEN MULTIPLE NOTIN SUBQUERY EXISTS.
DT132815 4 IT41028: ISSUING A SELECT QUERY MAY ENTERS AN INFINITE LOOP
DT148115 4 IT41113: -901 UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP
DT148112 4 IT41083: Possible trap in sqlnq_scalar_aggregate() when using LISTAGG() WITHIN GROUP()
DT147544 4 IT40456: SQL0158 OR SQL0421 QUERYING FROM VIEW OVER TEMPORAL TABLE AFTER ADDING NEW COLUMN
DT147711 4 IT39621: POSSIBLE PERFORMANCE PROBLEMS FOR INSERT STATEMENTS WITH COMMON-TABLE EXPRESSIONS
DT148079 4 IT39136: NON-PUSHDOWNABLE HASH JOIN ELIGIBLE PREDICATES INVOLVING NICKNAMES MAY BE USED SUB-OPTIMALLY
DT147346 4 IT39586: THE OPTIMIZER MIGHT FAVOUR A NON-OPTIMAL PLAN WITH REGISTRY VARIABLE DB2_EXTENDED_OPTIMIZATION=NLJN_OFLOW
DT148437 4 IT39643: GLOBAL/HOST VARIABLE OR PARAMETER MARKER WITHIN XMLQUERY PASSINGCLAUSE MAY RETURN -901
DT148259 4 IT39673: TRAP/901/HANG WHEN DB2 QUERY HAS CORRELATED IN PREDICATE IN SELECT.
DT159650 4 IT31973: DB2 SERVER TERMINATES ABNORMALLY PREPARING DECLARE GLOBAL TEMP TABLE STATEMENT
DT147260 4 IT35986: SELECT WITH GRANT FAILED TO GRANT FOR A VIEW WITH VALUES.
DT147682 4 IT38518: DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES WITH MULTIPLE OUTER JOINS
DT147722 4 IT40040: SPURIOUS ERROR MESSAGE IN DB2DIAG.LOG WHEN RUNNING DB2ADVIS
DT147067 2 IT38191: COMPILED TRIGGER REVALIDATION FAILS WITH SQL0901 "INVALID COMPILE ENV: CATALOG INDEX KEY VIOLATION"
DT147981 2 IT23350: DB2 MAY RETURN SQL0901N: EMPTY PLAN LIST DETECTED
DT068582 2 IT32990: UNQUALIFIED COLUMN REFERENCE WITH USING CLAUSE ON VIEW RETURNS SQLCODE=-206
DT147522 2 IT39520: MERGE STATEMENT REFERENCING MATERIALIZED QUERY TABLES (MQTS) MAYFAIL WITH SQL0407N
DT146510 2 IT37983: POSSIBLE DB2 TRAP IN PSMGETVALIDBREAKPOINTS() WHEN CALLING SYSIBMINTERNAL.ADMIN_GET_VALID_BREAKPOINTS()
DT146902 2 IT37611: DB2 MAY PRODUCE WRONG RESULT ON UPDATE STATEMENT WITH VIEW DEPENDENCY
DT147884 2 IT38797: QUERY FAILS WITH ERROR SQL0901N "NLJN LOJ INNER NOT NULLABLE"
DT148631 2 IT39334: SQL0952N ERROR SHOULD BE RAISED INSTEAD OF PRODUCING FODC_APPERRAND SQL0901N"
DT146220 2 IT37458: SELECT STATEMENT FAILS WITH SQL0901N (REASON "INVALID QNC ASSIGMENT")
DT146377 2 IT38190: TRAP ON SQLNO_COL_WIDTH_INLINE
DT148625 2 IT38996: INSERTING DECIMAL MINUS ZERO INTO COLUMN ORGANIZED TABLE LEADS TO WRONG RESULT ON POWERPC
DT148095 2 IT39883: POOR PERFORMANCE WHEN FEDERATED TABLE JOINED WITH CDE TABLE
DT148648 2 IT40051: DB2 SERVER COULD TERMINATES ABNORMALLY OR GET -301 WHEN RUNNING A PROCEDURE.
DT148099 3 IT40003: DB2 QUERY MAY GENERATE 901 WHEN GROUP BY COLUMNS ARE UNUSED.
DT147298 3 IT37707: INSERT INTO COLUMN-ORGANIZED TABLE WITH SUB-SELECT REFERENCING THE TARGET OF THE INSERT MAY RETURN INCORRECT RESULTS IN DPF SYST
DT147354 2 IT39978: POOR PERFORMANCE OF DB2 QUERY HAVING OR PREDICATE ON AND WITH EXPRESSION.
DT147168 2 IT35538: TRAP WHEN MULTIPLE UNION BRANCHES WITH SAME TABLE
DT159586 2 IT33263: DB2 CREATE TABLE STATEMENT MAY ABEND WHEN DB2_DEFAULT_TABLE_DISTRIBUTION IS RANDOM.
DT148643 2 IT39807: INCORRECT RESULTS MIGHT BE RETURN FOR COUNT/COUNT_BIG OVER() SCALAR AGGREGATE FUNCTION UNDER AN OUTER JOIN
DT146511 2 IT38210: DB2 SERVER TERMINATES ABNORMALLY IN RECURSIVE_QGM
DT148088 2 IT39559: DB2 ENGINE MIGHT HANG WHEN UPDATING STATISTICS FOR INDEXES ON XML COLUMNS
DT147710 3 IT39560: QUERY SUCCCEED BUT GET ERROR MESSAGE WINNING PLAN STILL NEEDS GLUE IN DB2DIAG.LOG
DT147873 3 IT38215: SELECT-STATEMENT WITH WHERE-CLAUSE, FETCH-CLAUSE AND UPDATE-CLAUSE FAILS WITH SQLCODE -511
DT147896 2 IT39337: INSERT statement performs poorly when source fullselect includesUNION ALL and fetch-clause
DT159446 2 IT34007: DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE.
DT148207 2 IT36857: DB2 ALTER TABLE QUERY MAY FAIL WITH SQL0109N ERROR
DT117977 2 IT38967: OPTGUIDELINES ARE NOT SUPPORTED FOR SET INTEGRITY STATEMENTS.
DT148628 3 IT39218: DB2 QUERY MAY GENERATE SQLCODE -901 WHEN LEFT/RIGHT OUTER JOIN PREDICATE ON EXPRESSION.
DT148253 2 IT39344: DB2 QUERY MAY GENERATE 901 WHEN SCALAR SUBQUERY HAS DISTINCT ANDFETHC FIRST 1 ROW.
DT148434 2 TRIM AND STRIP SCALAR FUNCTION RESOLUTION IGNORES CURRENT PATH
DT147378 2 INCORRECT RESULT WHEN DB2 QUERY HAS EQUAL PREDICATES WITH CONSTANTS
DT147754 2 TRAP WHEN UNION AND REFERENCE TO SAME SUBSELECT IN DB2 QUERY
DT147889 2 ABNORMAL TERMINATION OF QUERY WITH COMMON TABLE EXPRESSION
DT147705 3 IT39354: SPECIFIC MQT DEFINITION MAY LEAD TO DB2 ABEND WITH SIG11
DT146378 2 IT38199: INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNSFOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN
DT147696 2 IT38984: SQL0901N ERROR WHEN FETCH-CLAUSE OR OFFSET-CLAUSE INCLUDES A SCALAR FULLSELECT.
DT147676 3 IT38217: QUERY COMPILATION FAILS WITH SQLCODE -421 WHEN OLAP SPECIFICATION USED AS ARGUMENT TO INLINED SQL FUNCTION
DT147309 3 IT38214: MERGE STATEMENT RETURNS SQLCODE -206 WITH EMPTY OR WRONG COLUMN NAME
DT148241 2 IT38992: SEGV IN SQLKBFIX WHEN EXECUTING QUERY INVOLVING XML DATA AND AGGREGATION IN AN MPP CONFIGURATION
DT148245 2 IT39185: OPTIMIZER USES QUANTILE STATS FOR UNIQUE COLUMNS TO COMPUTE THE EQUALITY PREDICATE FILTER FACTOR WHICH LEADS TO OVER-ESTIMATION
DT147524 2 IT39550: DB2 SERVER MAY TERMINATE ABNORMALLY ISSUING ILLEGAL SQL STATEMENT
DT146227 2 IT38184: INCORRECT PROCESSING OF ROWID IS USED IN A SUBSELECT MAY PRODUCEA -901 WITH ERROR MinMaxPartialEvaluator.cpp : 99
DT147393 2 IT41517: QUERY PERFORMANCE MAY VARY WHEN USING OUTER JOIN OPERATOR
DT147382 2 IT41054: POSSIBLE PERFORMANCE ISSUES FOR CORRELATED QUERIES WHEN MIGRATING TO DPF SYSTEMS
DT147551 2 IT40888: LIKE PREDICATES IMPROVEMENTS
DT134914 2 IT41317: -901 WHEN COMMON TABLE EXPRESSION USED IN JOIN.
DT148385 2 IT37178: A COMPLEX XML QUERY INVOLVING XMLTABLE FUNCTION COULD TRAP
DT146335 2 IT35178: DB2 MIGHT ABEND WHEN EXECUTING A QUERY USING FIRST_VALUE AND REFERENCING TABLES ORGANIZED BY COLUMN
DT148114 2 IT41104: POSSIBLE 901 ERROR WHEN RUNNING QUERY WITH TEXT SEARCH FUNCTION
DT147719 2 IT39905: LONG RUNNING QUERY WITH COMPLEX CASE EXPRESSIONS HANGS AT COMPILE TIME
DT146726 2 IT35045: PACKAGE CONTAINING XML FUNCTIONS MAY RESULT IN -901 WHEN REBINDING WITH APREUSE
DT148485 3 IT41140: WRONG RESULT WHEN PREDICATE WITH CONSTANT ON AGGREGATE FUNCTION WITH CASE.
DT147934 1 IT40646: EQUALITY PREDICATES CONTAINING COALESCE EXPRESSIONS COULD HAVE INACCURATE FILTER FACTOR ESTIMATES.
DT148457 2 IT40288: OPTIMIZER USES EMPTY QUANTILE STATS LEADING TO CARDINALITY UNDER-ESTIMATION
DT147936 2 IT40676: OPTIMIZER MAY GENERATE A NEW TYPE OF PLAN BECAUSE OF HOW INDEX ORING PLANS ARE BUILT BETWEEN 9.7 AND 10.5
DT148276 2 IT40414: POSSIBLE TRAP (SEGV) IN PSM_DECLARE_VARIABLE_NODE() OR PSM_GEN_ROW_FIELD_VARIABLE() TRYING TO CREATE A PROCEDURE WITH A COMPLEX
DT146224 2 IT37893: DB2 MAY CRASH WHEN IT REPORTS COORDDB IS NULL
DT147999 3 IT31325: DB2EXFMT MAY HANG WITH SQL LONGER THAN 4096 AND COMMA OCCURS AT POSITION 4096 IN THE FORMATTED ORIGINAL STATEMENT
DT055930 2 IT31761: QUERY WITH STRING CAST FAILS WITH -901 "UNEXPECTED ERROR AT GETJOINPAYLOADEVALUATOR.CPP"
DT148104 1 IT40326: DB2 MAY TRAP WHEN RUNNING UPDATE STATEMENT THAT CONTAINS SPECIALCHARACTERS.
DT142838 2 IT40238: INSTANCE MAY CRASH DURING QUERY COMPILATION
DT147956 3 IT41466: DB2SUPPORT WITH THE -CL 2 OR -CL 3 OPTION CAN UNDER SOME CIRCUMSTANCES RESULT IN A SEGV TRAP
DT146312 1 IT34338: POSSIBLE PERFORMACE REGRESSION DUE TO OUTER JOIN - INNER JOIN REORDERING
DT148506 2 IT41713: INCORRECT RESULT WHEN CORRELATED PREDICATE ON PRIMARY KEY OF A TABLE.
DT148086 2 IT39524: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN USING SUBSTR
DT146899 2 IT37308: DB2 SERVER MAY TERMINATE ABNORMALLY WHEN ISSUING A SELECT QUERY
DT148277 2 IT40464: QUERY MIGHT TRAP IN DATA PARTITION ELIMINATION OF A ZIGZAG JOIN
DT147352 2 IT39906: POTENTIALLY BAD PERFORMANCE WHEN USING PARAMETER MARKERS IN QUERIES CONTAINING JOINS
DT148127 2 IT41735: XMLAGG WITH XMLQUERY INPUT AND GROUP-BY-CLAUSE MAY FAIL WITH -901 "BAD PLAN; UNRESOLVED QNC FOUND"
DT148424 2 IT38952: XML NODE MANAGER THROWS -901 ERROR WHILE RUNNING MANUAL RUNSTATSON XML TABLE."
DT148510 2 IT41821: QUERY WITH "WHERE RID() = <CONSTANT>" PREDICATE MIGHT RETURN INCORRECT RESULTS IN MPP
DT147955 1 IT41312: SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL
DT148501 2 IT41456: SQL0433N ON RETRIEVAL ASSIGNMENT WHEN DBCLOB CAST TO VARCHAR
DT147753 3 IT40953: "EXPLAIN PLAN FOR" DOES NOT WORK FOR TEXT SEARCH QUERY
DT148021 2 IT35030: DB2 MAY RETURN SQL0901N DURING UPDATE/DELETE/INSERT (UDI) ON TABLE CONTAINING INLINE TRIGGER
DT147626 2 IT35043: SQL0901N ERROR MAY OCCUR WHEN COMMON TABLE EXPRESSION HAS "SYSPUBLIC" SCHEMA NAME
DT147675 2 IT38198: COMPILING A SQL QUERY THAT INCLUDES A SQL UDF WITH OLAP INPUT MAY INCORRECTLY RETURN SQLCODE -206
DT146640 3 IT38211: DROP PACKAGE FAILS WITH SQL0553N WHEN "PL/SQL SUPPORT" IS ENABLED
DT148488 2 IT41215: STATICASDYNAMIC OPTION NOT SUPPORTED FOR COMPILED SQL OBJECTS
DT148641 2 IT39702: DB2 MAY COPY SELECTIVITY WHEN A SELECTIVITY CLAUSE IS USED ON A PREDICATE THAT'S COLUMN EQUIVALENT (C1=C2 AND C1=C3)
DT148487 2 IT41205: SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENTWITH CERTAIN CHARACTERISTICS
DT147560 3 IT41220: DB2 MAY ABEND WHEN UNION HAS BOTH PUSHDOWNABLE AND NON PUSHDOWNABLE BRANCH
DT148496 3 IT41386: POOR PERFORMANCE WHEN IN SUBQUERY USES THE SAME TABLE
DT148121 4 IT41415: POOR PERFORMANCE OF DB2 QUERY WITH UNION SUBQUERIES
DT148285 2 IT40829: DB2 QUERY MAY TRAP WHEN DIFFERENT COLUMNS ACCESSED IN MULTIPLE SCALAR SUBQUERIES
DT148662 1 IT40718: DB2 QUERY MAY PERFORM POOR WHEN NOT IN SUBQUERY HAS EXPRESSION.
DT148106 1 IT40752: DB2 QUERY TRAPS WHEN MODIFYING STATEMENT USES SET COLUMN THAT ISNOT USED IN SUBQUERY PREDICATE
DT147549 3 IT40762: INCORRECT RESULT WITH QUERY HAVING UNION
DT148467 2 IT40560: LOCAL PREDICATE PUSHDOWN FAILS WHEN IN SUBQUERY IN SELECT
DT148469 2 IT40626: DB2 QUERY MAY GENERATE 901 FOR QUERIES WITH UNION
DT168674 2 IT42184: IDENTITY_VAL_LOCAL MIGHT NOT RETURN LAST VALUE IF PREVIOUS INSERT-FROM-VALUES STATEMENT CONTAINED SMP-PARALLELIZED SCALAR SUBSEL
Fix Pack m8fp0  -   Query Compiler - ADM/PSM
DT148619 2 IT38951: DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN
DT147726 2 IT40092: DB2 SERVER TERMINATES ABNORMALLY OR RETURNS -901 WHILE PROCESSING JSON DATA
DT147325 2 IT38801: DB2 SERVER TERMINATES ABNORMALLY DURING CREATE/DECLARE TABLE
DT148264 2 IT40064: POSSIBLE WRONG RESULT WHEN PREDICATE INCLUDES CAST OF DBCLOB TO GRAPHIC OR VARGRAPHIC
DT147139 2 IT34443: A COLUMN MASK DEFINED ON A COLUMN WITH STRING LENGTH UNIT CODEUNITS32 MAY RESULT IN SQL20478N
DT148653 2 IT40270: WRONG DEFAULT VALUE FOR CHAR or GRAPHIC COLUMN IN AN EBCDIC TABLE WHEN DEFAULT VALUE IS NOT EXPLICITLY SPECIFIED
Fix Pack m8fp0  -   Query Compiler - Optimizer
DT148656 3 IT40363: -1667 WITH TOKENS TABLE TYPE: "ORGANIZE BY COLUMN". OPERATION: "WITH RR"
DT146873 3 IT35741: SQL1585N is returned when the optimizer does not select a possible plan under some circumstances
Fix Pack m8fp0  -   Query Compiler - QRW
DT148447 2 IT39872: POOR DB2 QUERY PERFORMANCE WHEN EXISTS SUBQUERIES PART OF OR
DT148234 3 IT38599: DB2 QUERY MAY GENERATE 901 WHEN JOIN ON SAME TABLE AND SELECT DISTINCT PRESENT
Fix Pack m8fp0  -   Runtime
DT168627 2 IJ39696: HISTOGRAM PRODUCING BINS WITH ZERO TUPLES
DT132361 2 IT40868: DB2 INSTANCE CRASH ON FUNCTION SQLERGETFMPFROMPOOL()
DT147379 2 IT40966: -901 SECTION LENGTH MISMATCH WHEN EXECUTING STATIC SQL
DT147381 2 IT41020: SQL0901N IN MPP WITH COLUMNAR TABLES IN SQLKQ_STOPWRITE_FLUSH FOR SQLKF_RQST_TIMEOUT
DT146780 2 IT38212: SET INTEGRITY FAILS WITH SQLCODE -668, REASON CODE 1 AFTER ADDING NEW GENERATED COLUMN
DT148261 2 IT39748: WHEN CPU SUPPORTS AVX2 A RARE TRAP IN PACKEDBANKSIMD IS POSSIBLE
DT148443 2 IT39765: A RARE WRONG RESULT IS POSSIBLE AGAINST COLUMNAR TABLES WITH A PSCANCOL PLAN AND MULTIPLE HSJNs ON THE SAME TABLE COLUMNS
DT147687 2 IT38730: POSSIBLE TRAP IN JOINEXPANSIONMULTIPLIEREVALUATOR::EXPANDALLREGULARATTR WHEN RUNNING HSJN QUERIES
DT148446 2 IT39851: RARE DATABASE SHUTDOWN WITH -902 SQLD_PARM "PARAMETER ERROR"
DT131647 2 IT40771: APPLICATION MAY HANG DUE TO THE LOST COMMUNICATION BETWEEN THE AGENT AND FMP CODE
DT147926 2 IT40347: RARE CRASH IN ERROR SCENARIO IN SQLRA_OPEN_PKG FUNCTION
DT147355 2 IT40066: DECREASE DEFAULT MAX NUMBER OF THREAD TO 1023 INSTEAD OF 1024 ON AIX
DT146453 4 IT34719: DECIMAL FUNCTION ON COLUMN-ORGANIZED TABLE MIGHT FAIL WITH SQL0413N
DT132780 2 IT39950: IN RARE JOIN ON COLUMNAR TABLES COULD LOOSE ROWS
DT148098 2 IT39999: FMP MEMORY CORRUPTION DUE TO WRITING TO A FREED IPC
DT123635 2 IT39928: RARE WRONG RESULT IS POSSIBLE FOR QUERIES AGAINST CDE TABLES THAT WERE CREATED WITH EBCDIC CCSID
DT148094 2 IT39873: FLUSH PACKAGE CACHE DYNAMIC FOR EXECUTABLE ID REPORTS SQLP_LCON
DT147337 2 IT39201: INSTANCE CRASHES RUNNING ALTER PACKAGE PACKAGE-NAME OPTIMIZATIONPROFILE OPTIMIZATION-PROFILE-NAME
DT148073 3 IT38861: RELAX OF DIAGLEVEL OF SQLRR_RDS_COMMON_POST, PROBE:870
DT148271 2 IT40274: TRAP IN FUNCTION SQLRA_GET_VAR WITH STMT_CONC SET TO COMM_LIT
DT143619 2 IT40019: DB2 GOT CRASHED WITH SIGINAL #11 AT SQLRILITERALREPLACE()
DT147721 2 IT40020: SQL RETURNING WRONG RESULT AFTER REPEATING SAME SELECT STATEMENT
DT147534 2 IT40028: XA INDOUBT TRANSACTIONS: AFTER DB2STOP QUIESCE IS RUN
DT147718 2 IT39869: SQLCODE -803, PRODUCES DB2DIAG.LOG MESSAGE: SQLRR_PROCESS_EXECUTE_REQUEST, PROBE:800 MESSAGE
DT147708 2 IT39551: DB2 MAY TRAP IN UPRV_TZNAME
DT148428 2 IT39145: INSERT INTO A LOB MAY FAIL WITH ERROR -30020
DT147333 3 IT39081: A RARE TRAP WORKING WITH COLUMNAR TABLES IN A VERY SPECIFIC STACK
DT130540 2 IT40699: INSTANCE CRASH WHEN SQLO_CPSAME ERROR HAPPENS IN SQLRICASTG2C
DT147568 2 IT41514: -901 INVALID POOLID AND OR OBJECTID ERROR IS INCORRECTLY RETURNED AFTER A TEMP TABLESPACE FULL SCENARIO
DT147566 2 IT41469: Sortheap memory leak possible for index-and access on MDC tables
DT148456 2 IT40279: RUNNING BIG SQL RETURN ERROR -901 INSTEAD OF -955
DT148298 2 IT41314: WRONG RESULT WHEN SORT WITH FETCH FIRST N ROWS IS DONE IN COLUMNAR LOGIC
DT148674 2 IT41238: HANGING QUERIES CANNOT BE TERMINATED THROUGH THE NORMAL METHOD OF FORCING THE APPLICATION
DT148281 3 IT40618: WARNING MESSAGE COULD BE LOGGED INCORRECTLY IN DB2DIAG.LOG.
DT147930 2 IT40476: WHEN OLAP IS DONE IN COLUMNAR LOGIC QUERY COULD EXPERIENCE A HANG
DT147933 2 IT40602: RARE TRAP IN RIGHT OUTER HSJN WHEN INTERRUPT IS ISSUED.
DT148683 2 IT41653: ERROR MESSAGES WITH SQLNLSICUCONVERTTODATEFORMAT_CLDR2701
DT148478 2 IT40905: INCORRECT ROW COUNT REPORTED WITH INSERT .. IGNORE DUPLICATES , COLUMNAR TABLES ONLY.
DT147564 2 IT41340: DOUBLE FREE OF UNUSED CHANNEL
DT148421 2 IT38887: ENHANCEMENT OF THE PD MESSAGE WHEN REACH THE LIMIT CONFIGURED BYDB2_MAX_THREADS_PER_FMP
DT148499 2 IT41427: DATA TYPE CONVERSION LEADS TO -SQL0413N OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION
DT147375 2 IT40874: SPIKES IN SQLO_LT_SQLRA_CACHED_ENV__LATCH WAIT, USING STMT_CONC=LITERALS, ON CONCURRENTLY COMPILATION OF A STATEMENT
DT147540 4 IT40328: DB2 MIGHT REPEATEDLY REPORT ISSUES IN SQLSMERGEREC
DT147395 3 IT41571: FODC APP ERR WITH -901 "REACHED RETRYCOUNT LIMIT"
DT147541 4 IT40351: SEVERITY CHANGE OF LOG ENTRY: "FUNCTION: DB2 UDB, ROUTINE_INFRASTRUCTURE, SQLERINITFMPHEAP, PROBE:995* RETCODE : ZRC=0X00000000=
Fix Pack m8fp0  -   SAP Tools
DT147371 2 IT40744: UPDATE SAPTOOLS.UPPER/LOWER TO COMPLY WITH LATEST UNICODE STANDARD
DT148286 2 IT40840: SAPTOOLS.ADMIN_COL_ANALYZE_FRAGMENTATION MIGHT RETURN SQL0802N
Fix Pack m8fp0  -   Security
DT147525 1 IT39584: SECURITY: A VULNERABILITY IN 2.17.0 APACHE LOG4J AFFECTS DB2 (CVE-2021-44832)
DT148609 1 IT38463: SECURITY: ADMINISTRATIVE TASK SCHEDULER IS VULNERABLE TO A PRIVILEGE ESCALATION
DT148247 2 IT39215: UPDATE GSKIT TO 8.0.55.26
DT148637 2 IT39500: UNNECESSARY SQLO_BAD_GROUP LOGGING INTO DB2DIAG.LOG
DT147695 2 IT38958: POSSIBLE SEGMENTATION FAULT ON DB2AUDIT EXTRACT COMMAND
DT147511 2 IT38800: IN CERTAIN SITUATIONS, THE SSL FUNCTION GSK_SECURE_SOC_PEEK MAY FAIL WITH THE RETURN CODE "5" IN SQLCCSSLSOCKETPEEK
DT148452 1 IT40210: SECURITY: IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE (CVE-2022-22389)
DT147923 1 IT40217: SECURITY: IBM DB2 IS VULNERABLE TO UNAUTHORIZED ACCESS (CVE-2022-22390)
DT147365 1 IT40483: EXCESSIVE CALLS TO OPERATING SYSTEM DATETIME FUNCTIONS, FOR EXAMPLE LOCALTIME_R, CAUSES LOCK CONTENTION IN THE OPERATING SYSTEM
DT148125 2 IT41557: IN RARE SCENARIOS, CERTAIN DB2 FUNCTIONS CAN HANG WHEN ATTEMPTING TO RESPAWN A CHECK PASSWORD DAEMON
DT147571 2 IT41576: DB2AUDIT SYNTAX ERROR WRITES AN UNNECESSARY ERROR LEVEL MESSAGE IN DB2DIAG.LOG
DT147539 2 IT40300: CATALOG LDAP DATABASE... AUTHENTICATION TOKEN FAILS WITH ERROR SQL1400N
DT148463 3 IT40509: IMPROVE EFFICIENCY OF CLIENT SIDE TLS CONNECTIONS
DT148670 1 IT40879: SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483)
Fix Pack m8fp0  -   PureScale
DT147348 3 IT39691: WORKAROUND TO AVOID ROOT PASSWORDLESS SSH IN PACEMAKER
DT147949 3 IT41161: OPTION TO DISABLE AUTO FAILOVER AFTER 2 CONSECUTIVE TSA DB MONITOR TIMEOUTS
DT145604 3 IT40835: SETTING HADR_SYNCMODE TO ASYNC/SUPERASYNC AND ACTIVATING DB IS NOT BLOCKED ON PACEMAKER AUTOMATED HADR DATABASE.
DT148477 3 IT40902: DB2CM -ENABLE OR -CREATE -DB MAY NOT RUN AS EXPECTED IF HOSTS HAVE OUTPUTS TO STDOUT IN THEIR LOGIN ENVIRONMENT OF HADR INSTANCE
DT147915 3 IT40026: TOTAL_CF_CMD_TIME_MICRO RETURNS -1
DT147912 2 IT40004: OUTPUT FROM LOADING INSTANCE PROFILE CONFLICTS WITH EXPECTED STDOUT IN PARTS OF DB2CM SCRIPT
DT148647 2 IT40005: HADR_REMOTE_INST SHOULD ALWAYS BE LOWERCASE
DT147714 4 IT39781: DIA8532C IS SOMETIMES LOGGED IN DB2DIAG.LOG WHEN ACTIVATING DB VIA DB2V115_START.KSH
DT147347 2 IT39589: DB2INST RESOURCE AGENT MAY CAUSE HANG DURING META-DATA ACTION INPACEMAKER HADR
DT147944 2 IT41024: HIGH "SQLO_LT_SQLB_BP_AREA_INFO_PAGEAREA__CLOCKLATCH" CONTENTIONS ON DB2 PURESCALE
DT147743 2 IT40711: PRINT SYSTEM DUMP MESSAGES IN DB2DIAG.LOG WHEN DB2 INITIATE SYSDUMPSTART COMMAND DUE TO MEMBER OR CF PROCESS CANNOT BE KILLED
DT148266 2 IT40090: ERRORS UNDER UNDER /VAR/LOG/PACEMAKER
DT124197 2 IT38339: db2instance -list shows CF in ERROR state transiently
DT148265 2 IT40088: DB2CM -LIST ERROR COULD NOT GET PACEMAKERE VERSION - 679
DT147920 2 IT40089: DB2CM -DUMP GENERATING ERRORS
DT147391 2 IT41467: SLOW CF PERFORMANCE AND LOW CF CPU UTILIZATION DURING HIGH RAR OPERATION DUE TO DE/RB LATCH CONTENTIONS
DT129226 2 IT39844: DB2START FAILS WITH SQLE_SAL_MIXED_TRANSPORTS_ERROR WHEN ONE OF THE RDMA ADAPTERS ON THE HOST IS IN UNKNOWN STATE
DT148468 2 IT40590: SETTING UP THE FAULT MONITOR FACILITY TO AUTOMATICALLY RESTART DB2 INSTANCES FAILS ON A NON-ROOT INSTALLATION
DT148507 2 IT41752: DB2SYSC PROCESS WAS NOT RESTARTED ON OLD PRIMARY AFTER TAKEOVER.
DT147744 4 IT40734: CLUSTER MANAGER MAY NOT FUNCTION AS EXPECTED IF /VAR IS FULL
DT147345 4 IT39517: THE DB2PD FUNCTION GETS VALUE FOR CF_GBP_SZ FROM THE DB CONFIG STRUCTURE IN MEMORY WHICH IS INCORRECT.

DB2 Version 11.5 Fix Pack m7fp0
Known Issue Sev. Abstract
IT36682 3 QUERY WITH INDEX SCAN ON A COLUMNAR TABLE WHICH IS UNDER A UNION MAY GET INCORRECT RESULT
IT41864 3 EXTERNAL TABLE INSERT OR SELECT MAY INCORRECTLY RETURN SQL0100
IT33777 3 BUILD IN FUNCTION "DATE_PART" MIGHT RETURN AN INCORRECT RESULT OF WEEK, I.E. DATE_PART('WEEK', '2020-03-09')
IT38609 2 REORG RECLAIM THROWS -901 AS INTERNAL QUERY COMPILATION FOR SYNOPSIS TABLE WAS INTERRUPTED
IT37046 2 DEBUG CODE IN ENGN/SQNG CHANGE FOR A TRAP IN CODEGEN
IT38731 2 CALLING CLR STORED PROCEDURE ON WINDOWS COULD RESULT IN SQL4301N RC=6
Fix Pack m7fp0  -   Abstract Data Types and Spatial Extender
IT37105 2 INTERMITTENT ISSUE IN ST_UNION RESULTING IN WRONG M VALUES
Fix Pack m7fp0  -   Administration Tools
IT38669 2 MON_GET_AUTO_MAINT_QUEUE() MAY FAIL WITH SQL0493N
IT37555 3 AUTOMATIC MAINTENANCE (DB2ACD) PROCESS GENERATES "HMONSQLCONNECT , PROBE:600 SQLCODE-1060" DB2DIAG.LOG ERRORS ON STANDBY DATABASE
Fix Pack m7fp0  -   Buffer Pool Services
IT38002 2 ALTER TABLESPACE REBALANCE HANGS ON DISK FULL ERROR
IT38476 3 YOU MIGHT SEE LOT OF SQLBPROCESSDSTACK MESSAGES IN DB2DIAG.LOG
IT37395 3 DB2PD -BUFFERPOOLS REPORTS INACCURATE HIT RATIO
Fix Pack m7fp0  -   CDE Data
IT37801 1 UPDATE OF A COLUMN-ORGANIZED TABLE WITH A SEARCH PREDICATE ON AN INDEX MIGHT RETURN A SQL901 ERROR DURING EXECUTION.
IT37048 1 COLUMN ORGANIZED TABLES THAT HAVE BEEN MARKED UNAVAILABLE CANNOT BE RENAMED. DOING SO MAY CRASH DB2.
IT37977 1 SELECT OR COMMIT AFTER UPDATE OF A COLUMN-ORGANIZED TABLE IN A PARTITIONED DATABASE ENVIRONMENT MIGHT FAIL WITH SQL901 ERROR
IT37868 2 FODC_APPERR: 'COLUMN.GETISNULLABLE()' ASSERTION DURING REPLICATION FOR COLUMN-ORGANIZED TABLES
IT37579 2 POSSIBLE TRAP IN SQLUMERGETABLEACCESSORZRC() WHEN RUNNING LOAD IN CDE ENVIRONMENT
IT37047 3 HANG DUE TO DEADLATCH BETWEEN VECTORIZEDADC THREAD AND NORMAL APPLICATION THREAD WHICH IS ROLLING BACK
Fix Pack m7fp0  -   CDE Query
IT38155 1 TRAP POSSIBLE WHEN COLUMNAR QUERY RUNNING WITH THE DB2 TRACE ENABLED IF "NOT IN" CLAUSE
IT37179 1 OTF ENCODING FOR THE LARGE COLUMNS LEADS TO QUERY EXECUTION FAILS WITH SQL0954 .
IT37212 1 RARE MEMORY CORRUPTION IN SORTHEAP WHEN CDE HSJN IS IN THE PLAN
IT37045 2 DEBUG CODE FOR CDE/GROUPBY TO ADD ASSERTION TO ENSURE NEXT VECTOR POSITION AND THE PAYLOAD POSITION
IT38286 2 TRAP IN SQLOFASTALLOCATOR::FREEBLOCK
IT37674 2 WRONG RESULTS FROM SELECT COUNT QUERY ON "ORGANIZE BY COLUMN" TABLE
IT36462 2 BLU QUERY CAN TRAP IN EVALUATIONROUTINE::GETQUERYLITERAL
Fix Pack m7fp0  -   Client Interfaces
IT35245 1 PROCESS CRASHES WITH SIGNAL 11 (MEMORY VIOLATIONS) WHEN APPLICATION CALLS SQLCONNECT OR SQLDRIVERCONNECT
IT38240 2 JAVA.LANG.OUTOFMEMORYERROR WITH TIMERLEVELFORQUERYTIMEOUT DEFAULT SETTING
IT37448 2 AFTER TURNING ON CLI PREFETCHING FEATURE, SQL STATEMENT RECEIVES CLI0106E/CLI0108E OR SQL_ERROR WITHOUT DIAGNOSTIC INFO
IT38241 2 ALTERNATE SERVER BECOMES PRIMARY SERVER WHEN BOTH PRIMARY AND ALTERNATE SERVERS ARE DOWN DURING DB2 JCC ACR
IT38541 2 INSERT INTO XML COLUMN OF A DRDA NICKNAME MAY CAUSE A SIGNAL 11 TRAP
IT38055 2 DB2DSDCFGFILL DOES NOT CREATE A DB2DSDRIVER.CFG FILE
IT37407 2 SQLCOLUMNS CLI FUNCTION MAY NOT WORK ON A TABLE NAME THAT INCLUDES MBCS CHARACTERS
IT36721 2 REORGCHK F6 REPORTING INCORRECT VALUES
IT33888 3 NO OPTION TO CONFIGURE CLI KEYWORD SSLSERVERCERTIFICATE VIA MICROSOFT ODBC ADMINISTRATOR
Fix Pack m7fp0  -   Codegen and Runtime
IT38563 2 DATABASE CRASH WHEN ARRAY TYPE VARIABLE USED IN "DGTT AS (SELECT ..) WITH DATA" SQL STATEMENT
IT38313 2 MEMORY LEAK IN RUNTIME ENGINE IF MEMORY POOL IS NOT CACHED
IT37768 2 PACKAGE RESTORE VALIDATION MAY CAUSE -901 AND FODC_APPERR
IT38087 2 SEGV AT SQLV_MIXD_BUILD_LIKE_SUBPAT()
IT36048 2 COMMUNICATION FAILURE BETWEEN DB2AGENT AND DB2FMP FOR SOME COMBINATIONS OF DATA SIZES AND APPLICATION SUPPORT LAYER HEAP SIZES
Fix Pack m7fp0  -   Communication
IT37963 2 MEMORY LEAK IN DB2 11.5 MOD6 FP0 DUE TO A NEW FEATURE IN ESQL.
Fix Pack m7fp0  -   DRDA Services
IT38817 1 SECURITY: CLIENT ENCRYPTION SETTINGS ARE NOT PRESERVED ON A FAIL OVER/RECONNECT RESULTING IN A DATA EXPOSURE. (CVE-2021-39002)
IT36663 2 INCORRECT CONNECTION DETAIL TOKEN STRINGS FOR A CLP CONNECTION USING A DBALIAS GREATER THAN DBNAME
Fix Pack m7fp0  -   Data Management Services
IT37470 1 POSSIBLE SIGSEGV WHEN TURNING ON OR DURING MONITORING OF TABLE EVENTS
IT39109 1 BCD DECIMAL USING 0XF FOR SIGN NIBBLE MIGHT GET CONVERTED TO NEGATIVE VALUE
IT37146 2 SYSTEM TEMP TABLESPACE CAN BE LEFT IN SQLB_REORG_IN_PROGRESS IF REORGS WERE STARTED, BUT NOT COMPLETED BEFORE CRASH RECOVERY
Fix Pack m7fp0  -   Data Management Utilities
IT38564 2 ADMIN_MOVE_TABLE(REPORT) OPERATION FAILS WITH -911 LOCK TIMEOUT DURING ADMIN_MOVE_TABLE(COPY_USE_LOAD)
IT35853 2 AUDIT EVENT LOAD_TABLE EVENT STATUS 3534 FILLING UP AUDIT LOG
IT36654 2 LARGE LOAD WITH LARGE AMOUNT OF LOB (> ~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 <TABLE> AFTER TRUNCATE <TABLE>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 <DSN> 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 <PORT> 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]<DEFUNCT>
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

Document Location

Worldwide

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PknAAE","label":"Install\/Migrate\/Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF055","label":"zLinux"}],"Version":"11.5.0"}]

Document Information

Modified date:
25 January 2024

UID

ibm11102545