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

Select a Fix Pack: | | | | | | | | |

DB2 Version 11.5 Fix Pack m9fp0 Known Issue Symptom Abstract DT148867 Incorrect Output (IN) IT42001: DB2ADUTLUPLOAD MAY WRONGLY UPDATE A HISTFILE ENTRY THAT CORRESPONDS TO A BACKUP SEQUENCE THAT FAILS TO BE UPLOADED DT161058 Abnormal End Of The Program (AB) TRAP IN FUNCTION SQLPDOUPDATELSNVALUESINXHDRS WHEN WRITING A LOGRECORD DT173258 Abnormal End Of The Program (AB) LOGICAL_RESTORE fails with "Unable to find the metadata file info.json for" error when restoring single schema out of multi-schema backup image. DT179023 Incorrect Output (IN) It is not possible to upload images/logs using db2adutl when the attached database partition number is different than the one used in DBPARTITIONNUM DT195969 New Function (NF) LBAR - Fixing the Problem with CREATE EXTERNAL REMOTESOURCE DT196027 New Function (NF) LBAR - Fixing the Problem with Wrong Order of Restoring Dependent Views DT209085 Integrity Problems (IG) LOGICAL_RESTORE - Ignore RCAC Options if No RCAC Tables Present in Backup Image and in Restore Set DT212931 Integrity Problems (IG) INDOUBT TRANSACTIONS NOT RESOLVED AUTOMATICALLY DT222096 Coded Halt (HL) LOGICAL_RESTORE fails when replaying schema DDL statements with syntax errors DT228165 Coded Wait (WS) ROLLFORWARD COMMAND MAY HANG WITH LOW DBHEAP MEMORY DT237799 Abnormal End Of The Program (AB) ROLLFORWARD OF DATABASE RESTORED FROM SNAPSHOT BACKUP MAY FAIL WITH AN UNEXPECTED CONDITION DT149261 Coded Halt (HL) IT42027: PURESCALE MEMBER RESTART HANG DUE TO CIRCULAR DEPENDENCY WITH BACKUP EXECUTING ON A DIFFERENT MEMBER DT149262 Incorrect Output (IN) IT42041: HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED DT196637 Integrity Problems (IG) LOGICAL_RESTORE fails on image check due to unexpected file DT211715 Incorrect Output (IN) Ignore non Critical Errors During Logical_Restore DT212779 Additional Information (AI) Audit records failures to access RCAC table data originating from LOGICAL BACKUP when it is not run DT213313 Performance (PR) Slow performance during database recovery when replaying TRUNCATE TABLE or CREATE/ALTER TABLE NOT LOGGED INITIALLY DT224265 Integrity Problems (IG) When running an online backup with EXCLUDE LOGS option and with DB2_DISABLE_FLUSH_LOG setting enabled, backup gets completed successfully but db2diag.log shows "DIA8414C Logging can not continue due to an error" message. DT173699 Abnormal End Of The Program (AB) SQL1797N with "Directory not empty" errors when calling LOGICAL_RESTORE or LOGICAL_BACKUP_DETAILS DT189208 Incorrect Output (IN) -902 reported by LOGICAL_BACKUP or LOGICAL_RESTORE when provided incorrect cloud URL DT197487 New Function (NF) Using ET or LBAR with an unrecognized production IBM Cloud Object Storage endpoint results in SQL20569N DT208663 Integrity Problems (IG) Remove temporary directories and files as part of LOGICAL_RESTORE cleanup DT209692 Abnormal End Of The Program (AB) DATABASE OUTAGE DUE TO LACK OF LOG SPACE WHEN DB2_CDE _DCC ENABLED DT212699 Coded Halt (HL) SYSPROC.SYSINSTALLOBJECTS('LBAR', 'M' ...) stored procedure unable to migrate IIAS restore history tables DT215662 Incorrect Output (IN) Online BACKUP of SMS table space can fail with deadlock due to concurrent LOAD operation DT225192 Incorrect Output (IN) Unsetting OVERFLOWLOGPATH does not disable OVERFLOWLOGPATH after next activation DT148514 Abnormal End Of The Program (AB) OUT OF LOG SPACE DURING COMMIT OR ROLLBACK WHEN REPLICATION IS ENABLED DT173106 Incorrect Output (IN) Error message from db2logts EDU DT179518 Incorrect Output (IN) Db2diag.log is flooded with message from "sqlpLLMUpdateLockWithGLMResponse, probe:3090" DT189209 New Function (NF) LBAR: Allow -drop-existing with -keep-rcac for LOGICAL_RESTORE and Fixing -keep-rcac and -replace-rcac Pre-checks DT208660 Loop (LP) Hang in LOGICAL_RESTORE Python Script When Restoring from DPF to SMP DT208662 Abnormal End Of The Program (AB) LOGICAL_RESTORE fails to restore INC/DEL backup image DT208667 Incorrect Output (IN) ADMIN_DROP_SCHEMA or LOGICAL_RESTORE fail when RCAC tables exist in schema DT214627 Incorrect Output (IN) LOGICAL_BACKUP (Schema-Level Backup) Produces Corrupted Backup Image If There are RCAC Tables in the Schema DT238513 Unpredictable (UN) Security: Db2 is affected by vulnerabilities in compression routines (zlib) DT148686 Abnormal End Of The Program (AB) IT41856: TRAP/ERROR READING FROM LOG FILES WITH ALSM ENABLED DT170181 New Function (NF) Fixes to productize Logical Backup in Db2 11.5.8 DT188273 Incorrect Output (IN) SYSIBMADM.PRIVILEGES missing SCHEMARCAC privilege DT209817 Abnormal End Of The Program (AB) DATABASE OUTAGE AFTER CRASH RECOVERY when using columnal table with intra-parallelism. DT237077 Integrity Problems (IG) Table space not set to ROLLFORWARD PENDING state when it was not accessible during crash recovery DT237938 Abnormal End Of The Program (AB) logical_backup stored procedure with -tsm option fails with SQL1797N DT130507 Errors when attempting to use UTL_DIR functions DT169944 Abnormal End Of The Program (AB) Assertion Failure "nextTSNOnPage == currTSN". Additional info: Page next TSN inconsistent with table next TSN DT236724 Incorrect Output (IN) SQL0901N 'numCurrentHWMs <= 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 IMMEDI 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 = " 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 REGIS 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 RU 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() = " 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 AFTER TRUNCATE WITHOUT IMMEDIATE CLAUSE Fix Pack m6fp0 - CDE Query IT34991 2 QUERY WITH OLAP MIGHT FAIL WITH SQL0955C IN CDE IT35973 2 NESTED IN PREDICATES CAUSES -901 ERROR IT36924 2 IN A RARE SCENARIO THE ERROR COULD BE LOST AND INSTEAD EITHER NULL OR SQL0901N RETURNED IT36311 2 WHEN RUNNING NLJN AGAINST COLUMNAR TABLES IT IS POSSIBLE TO GET SQL0901N ERROR IT32579 3 VALUE OF STATISTIC COLUMN AVGENCODEDCOLLEN IS INCORRECTLY COLLECTED DURING THE LOAD Fix Pack m6fp0 - Client Interfaces IT36757 2 CLR PROCEDURE ABORTS ABNORMALLY WITH ERROR SQL1024N WHEN IT USES IBM.DATA.DB2 .NET PROVIDER IT35180 2 BOOLEAN DATA TYPE GETS TRANSLATED AS SHORT-TEXT IN MS-ACCESS VIA ODBC IT36275 2 UNCATALOG SYSTEM ODBC DATA COURCE FAILS WITH DB21036E IT33194 2 IN CERTAIN TIMING CONDITIONS, CLI CLIENT ACR CAN FAIL TO REROUTE CONNECTIONS IT36235 2 PRECOMPILER STRIPS C STYLE COMMENTS FROM SQL, CANNOT USE INLINED OPTIMIZATION GUIDELINES IT34587 3 DB2TRC FMT -CLI CRASHES ON WINDOWS FOR SQLFREEHANDLE API Fix Pack m6fp0 - Codegen and Runtime IT33610 2 POSSIBLE FLOODING OF DB2DIAG.LOG FILE WITH MESSAGES FROM 'SQLNLSICUCONVERTTOMERIDIANFORMAT()' IT37253 2 IN SOME CASES, WLM THRESHOLDS FOR TEMP SPACES IS CALCULATING INCORRECTLY IT35994 2 TRAP IN SQLNGREORDERAGGOPS WHEN ATTEMPTING TO COMPILE A JASON ARRAY IT35984 2 A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT IT36245 2 SQL QUERY MAY BE SLOW WHEN USING DBMS_LOB.SUBSTR FUNCTION IN A VIEW IT33282 2 DB2 MIGHT SHUTDOWN WHEN HANDLING A REGULAR EXPRESSION (REGEX) IN SQLRI_REGEXP_LIKE_LONG_BODY() WITH INVALID DATA IT34764 2 SLOW PERFORMANCE IN REGULAR EXPRESSION FUNCTIONS ON BIG ENDIAN PLATFORMS Fix Pack m6fp0 - DB2 Tools IT35061 2 WHEN A USER ID WITH INSUFFICIENT PRIVILEGE ATTEMPTS TO RUN REORG FROM WITHIN A STORED PROCEDURE, THE STORED PROCEDURE RETURNS RC Fix Pack m6fp0 - DRDA Services IT36026 1 SECURITY: IBM DB2 IS VULNERABLE TO A DOS WHEN A TABLE IS DROPPED WHILE BEING ACCESSED IN ANOTHER SESSION (CVE-2021-29777) IT36201 2 A CLIENT MAY ABEND IN FUNCTION SQLXAPREPARECOMMIT Fix Pack m6fp0 - Data Management Services IT34966 1 SECURITY: DB2 EXTERNAL TABLE CREATION IS VULNERABLE TO RACE CONDITION ATTACK IT34964 1 SECURITY: IBM DB2 IS VULNERABLE TO AN ARBITRARY FILE OVERWRITE IT36525 1 TRAP IN FUNCTION SQLPLRL WHEN DROPPING A SYSTEM TEMPORARY TABLE CREATED BY A QUERY RUNNING ON A HADR STANDBY IT34381 2 A DEADLOCK MAY RESULT WHEN MULTIPLE APPLICATIONS CONCURRENTLY INSERT INTO A COLUMN-ORGANIZED TABLE WITH AN IDENTITY COLUMN IT35993 2 ROLLFORWARD RECOVERY COULD FAIL WITH SQLD_REC_DELETED WHEN REDOING A FAILED CLASSIC TABLE REORG IT33456 2 DB2 MIGHT HANG IN PURESCALE SETUP UNDER A MEMORY CONSTRAINED SITUATION IT31723 3 LOB PAGES MAY NOT BE REUSED PROPERLY IN PURESCALE. IT35082 3 HIGH CPU AND DECREASED PERFORMANCE WITH HIGH CONCURRENCY OF INDEX CREATION (ON TEMP TABLES) Fix Pack m6fp0 - Data Management Utilities IT36770 2 IMPORT MAY BE TERMINATED IF SQL0437W IS DETECTED, ALTHOUGH IT CAN BE IGNORED IN MOST SCENARIOS. IT35679 3 UNDER CERTAIN CONDITIONS, THE "NUMBER OF ROWS ..." MESSAGE FROM INGEST UTILITY ARE INCORRECT. IT34197 3 DB2 MIGHT REPEATEDLY REPORT ISSUS IN SQLSMERGEREC Fix Pack m6fp0 - Data Recovery Services IT34889 2 DB2ADUTL DELETE LOGS WITHOUT PROMPTING" DELETES LOGS ONE BY ONE AND THEREFORE SLOWER THAN DELETING LOGS IN BATCH IT36461 2 ACTIVATE DATABASE ON ONE MEMBER IN PURESCALE HUNG WHEN ANOTHER MEMBER IS EXECUTING CREATE INDEX ON HADR PRIMARY DATABASE IT35714 2 PERFORMANCE OF DB2LOGGR MIGHT BE AFFECTED DUE TO UNNECESSARY SYMBOL RESOLUTION IN SQLPGRENAMEFILEDURINGLOGRECLAIM IT36569 2 DB2FLSN TOOL INCORRECTLY DISPLAYS "N/A" AS THE MAXIMUM LSN FOR A LOG FILE INSTEAD OF THE ACTUAL MAXIMUM LSN VALUE. IT35119 2 RESTORE USING "NO ENCRYPT" FROM A DOWNLEVEL ENCRYPTED BACKUP IMAGE WILL RESULT IN DB STILL BEING ENCRYPTED IT36140 2 PERFORMANCE IMPACTS WITH HUGE AMOUNT OF ROW LOCKS IT36820 2 DB2ADUTL FAILS TO READ DB CONFIG ON PURESCALE OR DPF ON NODES OTHER THAN CATALOG NODE IT33960 2 SQL0206N OR SQL0901N ON STANDBY AFTER ALTER TABLE ADD COLUMN ON PRIMARY WHEN HADR IS STOPPED IT36378 2 DB2ADUTL EXTRACT: ERROR UNEXPECTED DATA SEEN AT THE END OF THE SEQUENCE, IMAGE MAYBE CORRUPT. IT31624 3 REDIRECT RESTORE WITH REBUILD OPTION FAILS WITH SQL2025N IT35695 3 INCORRECT HADR_TARGET_LIST CONFIGURATION IN PURESCALE CAN RESULT IN UNEXPECTED SQL1776 RC 6 IT35161 3 DB2CKLOG PASSES BUT RETURNS MESSAGES APPEARING TO BE ERRORS IT37302 3 HADR TAKEOVER FAILED WITH SQL1770 RC 7 DUE TO EVENT MONITOR BLOCKS FORCING OFF ONLINE REORG ON PRIMARY IT34547 4 DIA8550C MESSAGES FILLING UP DB2DIAG.LOG WHEN LOG PATH IS MAPPED TO AN UNC PATH IN WINDOWS ENVIRONMENT Fix Pack m6fp0 - Engine Other IT36334 3 ERROR LOG MAY BE CONTINUE TO GENERATE IN HADR CONFIGURED BY PACEMAKER ON AWS. Fix Pack m6fp0 - Federation IT36252 1 ROLLBACK THE FIX OF MARIADB LENGTH(CHAR) PUSHDOWN IT36413 1 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 IT36279 1 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT (CVE-2020-4739) IT35685 1 QUERY WITH 'ORDER BY' AND REFERENCING A COMMON SUBEXPRESSION OVER COLUMN-ORGANIZED TABLES MAY RETURN ROWS IN THE WRONG ORDER IT34670 2 ACCESSING HIDDEN COLUMNS WITH FEDERATION RECEIVES SQL0206N IT36474 2 WILD POINTER REQUEST->AGT_RUNTIME_OBJ IN SQLQG_SIGNAL_HANDLER LEADS TO DATABASE CRASH IT33184 2 THE MARIADB COLUMN LENGHT IS OVER 32K, BUT THE IMPORT FILE ONLY HAS 32768 CHARACTERS. IT33052 2 WITH FEDERATION FUNCTION, IT IS POSSIBLE THAT INSERT STATEMENT WILL GET SQL1476N. JR63711 2 DV ISSUE: PUSHDOWN ISSUE FOR DB2 AND ORACLE JDBC WRAPPER IT36387 2 A FODC FMP TRAP IS REPORTED IN SQLQG_GET_TOSENDDATALEN WHILE QUERYING FEDERATION NICKNAMES IT34402 2 FEDERATION MARIADB CURRENT TIMESTAMP "GETTING PARAMETER TYPE METADATA ARE NOT SUPPORTED" ERROR SQL1822 IT33183 2 FEDERATION SERVER ODBC WRAPPER FETCHES KOREAN CHARACTERS FROM MARIADB, BUT RETURNS UNREADABLE TEXT. IT36380 2 GET_CODEPAGE IS CALLED FOR EVERY PARAMETER MARKER WHICH CAUSED BAD PERFORMANCE IN DRDA WRAPPER IT36199 2 POSSIBLE DB2FMP TRAP IN SQLQG_FMP_RUNTIME_OBJECT::GET_RSTATE_INF O() WHEN RUNNING FEDERATED QUERY IT35805 2 MULTI-THREADED DB2FMP TRAPPED IN SYBASE CALLS INTERMITTENTLY Fix Pack m6fp0 - Index Manager IT36812 2 INSTANCE MAY CRASH WITH SQLIDUMPINXCURSOR ON THE STACK WHEN DUMPING FODC DIAGNOSTICS (-901 OR TRAP) IT36449 2 DB2 PREP COMMAND FAILS WITH THE ERROR SQL0318N WHEN THE VALUES CLAUSE CONTAINS THE KEYWORD FOR. IT36256 3 DB2 PREP COMMAND FAILS WITH SQL4003N 'THE SQL STATEMENT IS NOT SUPPORTED ...' OR SQL0104N 'UNEXPECTED TOKEN ...' ERROR Fix Pack m6fp0 - Install and Catalog Services IT36454 2 SQL0901N - INVALID FEDERATED THREE PART NAME IJ21543 2 DB2PREREQCHECK SHOULD NOT CHECK MODPROBE FILE WHEN USING MELLANOX CX-4 IB/ROCE CARD ON LINUX PLATFORM IT25907 2 -P PARAMETER IS BEING IGNORED BY DB2ICRT IT34619 2 ENHANCEMENT: SETUP.EXE CHECKS CURRENT DIRECTORY NAME WHETHER IT HAS SPACE(S) OR NOT ON WINDOWS IT35734 2 SYSCODEPROPERTIES CONTINUONSLY INCREMENT THE NUMBER OF INVALID OBJECTS WITHOUT REDUCING IT36376 2 EXPORT RETURNS SQL0204N "SYSTEM.SYSCAT.FUNCTIONS" IS UNDEFINED. IT33815 3 REMOVE/DROP AUDIT ENCOUNTERED UNEXPECTED BEHAVIOR IT34188 3 DB2LOOK CREATEDB OR PRINTDBCFG PARAMETERS DON'T REPORT THE ACURATE VALUE IN DB2LOOK FOR STRING_UNITS . IT36468 3 REPLAY OF REVOKE ON HADR STANDBY WITH READS ON STANDBY ENABLED MAY RESULT IN A SMALL MEMORY LEAK IT31631 3 CREATE .PROFILE IF IT DOESN'T EXIST WHEN RUNNING DB2ICRT (CREATE INSTANCE) IT34384 4 DB2PREREQCHECK CHECKS FOR JAVA, BUT WE BUNDLE JAVA WITH DB2 Fix Pack m6fp0 - Monitoring IT36150 2 ADMIN_MOVE_TABLE CANNOT BE USED TO MOVE TABLE HAVING DOUBLE QUOTES IN NAME IT36521 2 SQL405N REPORTED BY DB_MEMBERS AND DB_PARTITIONS TABLE FUNCTIONS IF NETNAME EXCEEDS 128 CHARACTERS IN DB2NODES.CFG IT34510 3 DB2 INSTANCE CRASHES IN DB2 DEADLOCK EVENT MONITOR IN THE SQLNPMASKPASSWORD FUNCTION Fix Pack m6fp0 - Parsing and SQL PL IT30559 2 DB2 MAY ABEND WHILE COMPILING COMPOUND SQL (COMPILED) STATEMENTS Fix Pack m6fp0 - Platform Specific IT33313 2 "DB2" FRONT END PROCESS DOES AN UNNECESSARY INTERNAL INITIALIZATION WHICH MIGHT CAUSE A PERFORMANCE DEGRADATION IT36041 3 ALTER TABLESPACE WITH NO FILE SYSTEM CACHING OPTION FAILS ON LINUX390 IT35710 3 INTERMITTENT FAST PREALLOCATION FAILURES ON AIX Fix Pack m6fp0 - Problem Determination IT36266 2 INSPECT DATABASE COMMAND SLOW BECAUSE OF EXCESSIVE SLEEP WHILE CHECKING OVERFLOW RECORDS IT34869 2 DB2PD -DBPTNMEM CAN CRASH IF USING USING MEMBER NUMBERS GREATER THAN 9 IT35318 2 LARGE PRIVATE MEMORY LEAK WHEN PD_GET_DIAG_HIST IS INTERRUPTED PROCESSING A LARGE DB2DIAG.LOG OR NOTIFY FILE IT37300 3 NO OUTPUT RETURNED USING PD_GET_LOG_MSGS OR PDLOGMSGS_LAST24HOURS ON WINDOW ENVIRONMENT Fix Pack m6fp0 - Process Model IT36331 1 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND IT36504 2 WHEN THE DBNAME DOES NOT MATCH THE DBALIAS HADR FAILS TO START ON THE PRIMARY IT35376 2 DB2 MIGHT CAUSE EXCESSIVE LOGGING (SQL0952N MESSAGES) WHEN A QUERY IS INTERRUPTED. IT36821 2 SET EVENT MONITOR STATE STATEMENTS MAY BE INCORRECTLY QUEUED BY THE ADAPTIVE WORKLOAD MANAGER IT36833 2 OCCURS ON PARTITIONED DATABASE, DB2 MAY CRASH WHEN TRYING TO UNLATCH A LATCH THAT IS NOT HELD IT33580 2 INCORRECT ESTIMATION OF PARTITIONS WHERE QUERY MAY EXECUTE MAY CAUSE EXCESSIVE QUEUING WITH THE ADAPTIVE WORKLOAD MANAGER IT36862 2 POSSIBLE 15 SECOND DELAY IN SQLEPEEKREQUEST IT33410 2 SQL1041 DB2 NOT FOLLOWING NUMDB SETTING IT34227 3 ADMIN_CMD AND GET_DB_CONFIG CANNOT HANDLE EXTENDED NUMBER RANGE OF LOGBUFSZ IT35832 3 SQLCODE -1229 CONTINOUSLY WRITTEN IN DB2DIAG.LOG AFTER NODE FAILURE IT36113 3 V11.5.5 ONLY: DB2ADUTL COMMAND FAILS WITH SQL1031N IN PURESCALE ON ALL MEMBERS EXCEPT MEMBER 0. Fix Pack m6fp0 - Query Compiler Optimizer IT36104 1 DB2ADVIS WILL THROW A -901 ON A QUERY THAT IS ORDERED BY AN EXPRESSION IT35953 1 INSERT FROM COMPLEX SELECT WITH ORDER BY IN DPF MODE MIGHT LEAD TO SEGV TRAP IT34668 1 INSERT INTO COLUMN-ORGANIZED TABLE FROM COMPLEX SUBSELECT CAN TRAP DURING QUERY OPTIMIZATION IT34102 2 CURSOR-BASED UPDATE OR DELETE OF ROWS ON A TABLE WITH A RCAC DEFINED MAY LEAD TO A TRAP IT35309 2 DYNAMIC QUERY EXECUTION FAILS WITH SQLCODE -901 REASON CODE "CONSTANT OF UNSUPPORTED TYPE" IT35997 2 SQL STATEMENT CONTAINING UNION ALL WITH JOINS ON MISMATCH DATA TYPES MIGHT FAIL IN DPF WITH A SQL0901 ERROR Fix Pack m6fp0 - Query Compiler QGM IT34871 2 USING WRONG DELIMITER MIGHT CAUSE THE INSTANCE CRASH IT35066 2 LPAD OR RPAD BUILTIN FUNCTION FAIL WITH -901 "VALUE IS TOO LARGE FOR THE BUFFER" IT35055 2 DB2 SERVER TERMINATES ABNORMALLY WHEN AUTO_REVAL=DEFERRED_FORCE IT36401 2 901-COLUMN NUMBER OUT OF RANGE DURING QUERY COMPILATION, FORM_CSE CALL STACK IT34347 2 MONTHS_BETWEEN FUNCTION IN NPS MODE RETURN NEGATIVE IT33192 2 DB2 QUERY MAY ABEND WHEN THERE ARE COMMON TABLE EXPRESSION USED IN UNION IT36384 2 UPDATE STATEMENT WITH IN/EXISTS MAY GENERATE SQLCODE -913 IT36742 2 SQL0901N WHEN DB2 QUERY HAS CDE TABLE AND JOIN PREDICATE HAS TYPE MISMATCH IT35085 2 DB2 SERVER MAY TERMINATE ABNORMALLY WITH SQLDCSL_BADPAGE "BAD DATA PAGE" IT36106 2 SQL0901 ON SELECT SAMPLE.TEST FOR SYSTEM_TIME BETWEEN IT35059 2 LPAD, RPAD OR REPLACE MAY RESULT IN SQLCODE -901 WHEN SOURCE-STRING REFERENCES A COLUMN-ORGANIZED TABLE COLUMN IT30018 2 DB2 MAY RUN OUT OF STATEMENT HEAP WHILE COMPILING QUERIES INVOLVING UNIONS AND PREDICATES WITH WEAK UDTS IT36441 3 DB2 QUERY PERFORMS BAD WHEN USING SUBQUERY PREDICATE WITH OR IT36498 3 DB2 MAY RETURN -901 WHEN IMPLICITLY CASTING NON-STRING TO A STRING AND THE ENVIRONMENT DEFAULT STRING UNITS ARE CODEUNITS32. IT35058 3 SUBSTR IN COLUMN ORGANIZED COLUMN COMPARISON RETURN WRONG RESULTS IT36473 3 TRUNCATE TABLE WITHOUT IMMEDIATE ON CDE TABLES WITH DELIMITED IDENTIFIERS FAILS IT36320 3 QUERY EXECUTION MAY FAIL FOR OUTER JOIN QUERIES WITH PREDICATES WITH CAST FUNCTIONS IT35062 3 CREATING AN EXPRESSION-BASED INDEX FAILS WITH -356 AND EMPTY REASON CODE IT36388 3 UNEXPECTED SQL206 WHEN COLUMN NAME OR COLUMN NAME QUALIFIER HAS TRAILING SPACES IT33287 3 WRONG RESULT/901 WHEN IN USED ON SELECT Fix Pack m6fp0 - Relational Data Services IT36046 2 PANIC MAY OCCUR IN HADR TAKEOVER IT36853 2 DB2AGENT REPORTED SQLD_PARM ERROR WHEN TRUYING TO FIND/FIX TCB WITH OBJECTID=0 IT35518 2 DB2 MAY CRASH INTERMITTENTLY IN SQLRA_SQLW_MEM_FREESPACE IT34418 2 QUERY INTERRUPT DOES NOT RETURN SQL0952N WHEN A WLM THRESHOLD WAS CREATED IT32552 2 MULTIPLE SEVERE/INFO MESSAGES WITH -803 COULD BE RECORDED IN DB2DIAG.LOG AND MAY AFFECT PERFORMANCE Fix Pack m6fp0 - Sailfish Operational Compatibility IT36751 1 EXTERNAL TABLES WITH LFINSTRING OPTION MAY FAIL IF DATA CONTAINS A FIELD INCLUDING A NON ESCAPED DELIMITER CHARACTER IT35075 2 SELECTING FROM AN EXTERNAL TABLE THAT USES LFINSTRING ON CAN FAIL WITH SQL5199N Fix Pack m6fp0 - Security IT36475 1 SECURITY: IBM DB2 IS VULNERABLE TO AN INFO. DISC. FOR USERS WHO CREATE AN INLINE SQL FUNC. WHEN AUTO_REVAL SET TO DEFFERED_FORC IT40980 2 Security: IBM Db2 may be impacted by a Denial of Service IT36418 2 LDAP PLUGIN NOW ALLOWS CONFIGURATION TO CHECK LDAP PASSWORDPOLICYRESPONSE IT36177 2 WHEN USING GSSPLUGIN IBMIAMAUTH.SO CRASHES DB2 Fix Pack m6fp0 - pureScale Services IT36431 2 DB2CLUSTER -VERIFY FAILURE DUE LATE SERVER STARTUP IJ27796 2 "LIST INDOUBT TRANSACTIONS" COMMAND PERFORMANCE IMPROVEMENT WITH PURESCALE. IT29557 2 MORE ROBUST CLEANUP STATUS CHECKING IT35801 2 MISMATCH THAT THE OS HOSTNAME VALUE IS LOWER-CASED WHEREAS THE H ADR_LOCAL_HOST/HADR_REMOTE_HOST VALUES ARE UPPER-CASED. THIS SHO IT37103 2 PURESCALE DELETE ROWS PERFORMANCE REGRESSION ON RDMA NETWORKS IT35828 3 "DB2CLUSTER -CFS -SET -OPTION CCRENABLED -VALUE NO" COMMAND TIMES OUT IT36816 3 DB2CLUSTER -CFS -EXIT -MAINTENANCE MAY FAIL WITH RC=2 IT36894 3 "TOO MANY ARGUMENTS" MESSAGE WHEN RUNNING DB2CM -CREATE -DB IN HADR WITH PACEMAKER WITH MULTIPLE STANDBY SETUP IT36393 3 CIB ATTRIBUTE FAILED TO SET DURING PRIMARY REBOOT IT36457 4 AFTER A REBOOT, HADR DATABASE MAY FAIL TO BE ACTIVATED BY AUTOMATION.

DB2 Version 11.5 Fix Pack m5fp1 Known Issue Sev. Abstract IT34838 2 LEFT FUNCTION CAN NOT BE PUSHED DOWN IT35883 3 INDOUBT TRANSACTIONS MAY NOT BE RESOLVED BY XA TRANSACTIONS ON PURESCALE IT34960 3 DATE PRECISION IS LOST WHEN REMOTE SQL SHIPPED TO FEDERATED DB AND RESULTS IN 0 ROWS. IT32664 3 XML INDEXES NOT USED IN DB2 11.5 EXPLAIN PLAN IT35798 3 SLOW PERFORMANCE IN DPF OR CDE WHEN RUNNING A QUERY WITH SCALAR SUBQUERIES AND AN OUTER JOIN IT34748 3 UPDATE STATEMENT SLOW PERFORMANCE CAUSED BY LATCH CONTENTION DURING THE MEMORY ALLOCATIONS. IT35017 3 CDE JOIN MINMAXINFO DUMP: TRAP DUE TO DEREFERRENCING NULL POINTER IT35185 3 DB2 MIGHT TRAP IN SQLRWTABLEMETRICSBUILDER::EXECUTE DURINGEXECUTION OF THE MON_GET TABLE FUNCTION IT35705 3 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE IT35439 3 DB2ADV_VPC.LIC CAN MAKE Q REP FUNCTIONS AVAILABLE, IT IS NOT THE EXPECTED RESULT IT36027 3 IMPROVEMENTS TO CDE JOIN MEMORY USEAGE. REDUCTION OF MEMORY NEEDED AND REDUCTION OF -955 ERRORS. IT33529 3 PRESENCE OF CANDIDATE ACCESS PLAN WITH SINGLE-NODE HASH-DIRECTED PARTITIONING PREVENTS OPTIMAL PLAN WITH REPARTITIONED JOIN IT35680 3 HADR STANDBY WITH DB2_HADR_ROS_AVOID_REPLAY_ONLY_WINDOW FEATURE MAY TRAP OR FAIL WITH ABNORMAL TERMINATION OR INDEX ERROR IT34693 3 DB2UNINS OF DATA SERVER CLIENT REMOVES SHARED C++ REG KEYS IT34396 3 PUSHING DOWN BIT_STRING IS BLOCKED BY NO MAPPING IT34242 3 BAD PERFORMANCE DUE TO DELAYED JOIN PREDICATE PUSHDOWN THROUGH UNION ALL PREVENTS JOIN ELIMINATION IT35833 3 SQL1585N IS INCORRECTLY RETURNED FOR CERTAIN TYPES OF QUERIES IT34658 3 DB2 QUERY MAY GENERATE FODC AND APP_ERR OR WRONG RESULT IN CERTAIN CONDITIONS IT35047 3 MGB:STORED PROCEDURE CALLS PERFORMANCE ARE SIGNIFICANTLY WORSE AFTER MIGRATION IT34559 3 ELEMENT ALLOCATION ISSUE, AND ONE OF THE VECTORS WAS MESSED UP AND CAUSE TRAP/SEGFAULT. IT31536 3 MON_GET_LOCKS FAILS IN DPF WITH SQL1607N BECAUSE OF UNDERLYING RPC MECHANISM BEING LIMITED TO 2 GIGABYTES IT34108 3 NLJN NOT PUSHING DOWN IT35033 3 CUSTOMERS ENCOUNTERING ASN0569E DUE TO OUT-OF-ORDER REPLICATION LOG RECORDS DURING SAVEPOINT ROLLBACK IT35728 3 SQL0407N WHEN COMMON SUBQUERY HAS VALUES IT35548 3 HADR STANDBY FORCE DB SHUTDOWN, DB2DIAG.LOG SHOWS OBJECT IS NOT MARKED PENDDEL IT35739 3 DB2 QUERY MAY NOT GENERATE TRAILING SPACE WHEN MINUS/EXCEPT IS USED IN THE QUERY. JR62967 3 DB2 V11.5 QUERY PLAN WITH "UNION ALL" IS DIFFERENT FROM QUERY PLANS IN V11.1 IT35880 3 DB2 11.5 PERF DEGRADATION ON LINUX: O_SYNC AND NOT O_DSYNC USED IT35992 3 SQL0811N WHEN THERE IS SCALAR SUBQUERY WITH FETCH FIRST 1 ROWS IT36210 3 IN VERY RARE CASE OF CDE RIGHT OUTER JOIN PROCESSING TRAP IS POSSIBLE. IT35399 3 FEDERATED SERVER OPTION CONCURRENT_ACCESS_RESOLUTION='W' CAUSES CLI019E INVALID ATTRIBUTE ERRORS Fix Pack m5fp1 - Abstract Data Types and Spatial Extender IT35444 2 MULTIPLE MEMORY LEAKS IN GEO-SPATIAL CALLS WHEN EXECUTING CERTAIN GEO-SPATIAL FUNCTIONS Fix Pack m5fp1 - Buffer Pool Services IT33994 2 DB2 MAY HANG SHORTLY AFTER COMMITTING A CREATE TABLE WITH AN AGE NT WAITING FOR SQLO_LT_SQLD_TCB__LOADINPROGRESS LATCH IN SQLBFIX IT36108 2 INTERRUPTING ALTER TABLESPACE REDUCE MAY CAUSE A MEMBER SHUTDOWN Fix Pack m5fp1 - CDE Data IT35182 2 CLEANUP OF IN-MEMORY STRUCTURE WHEN LOADING OF THE DICTIONARY FAILS (ADD CODE TO HANDLE EXCEPTIONS GRACEFULLY). IT34037 2 DEADLATCH BETWEEN ONE THREAD WRITING A DICTIONARY TO DISK USING VECTORIZEDADC AND ANOTHER THREAD DOING A NEW EXTENT ALLOCATION Fix Pack m5fp1 - CDE Query IT35163 1 DB_MIGRATE HANGS WHEN USING ORDER BY CLAUSE IT36230 2 DB2 TRAP IN FUNCTION EXTRAPAYLOADITERATOR::COPYPAYLOADSTO IT35211 2 POSSIBLE SIGSEGV IN Q REPLICATION DUE TO INCORRECT LOG RECORDS FOR COLUMN-ORGANIZED DGTT IN DPF ENVIRONMENT IT35158 2 REDUCE LIKELYHOOD OF SQL0954C FOR COLUMNAR ORGANIZED HSJN PLANS Fix Pack m5fp1 - Client Interfaces IT35521 1 CLI DRIVER FAILING TO RETURN -911 ERROR TO APPLICATION WHEN EXECUTING ARRAY INPUT CHAIN OF STATEMENTS IT34606 2 USING CFGREFRESHINTERVAL IN A MULTI-THREADED CLI APPLICATION LEADS TO SEGMENTATION FAULT IT34589 2 ON WINDOWS PLATFORM CLIDRIVER CAN LOG SQL1531N DURING CONNECT EVEN WHEN CONNECTION IS SUCCESSFUL WITH SQL_SUCCESS_WITH_INFO IT35405 3 CAN'T CONNECT TO DB2 VIA EXCEL 2016 USING DATA > ?GET EXTERNAL DATA? WHEN UPGRADING RUNTIME CLIENT TO 11.5 Fix Pack m5fp1 - Codegen and Runtime IT35377 2 WRONG RESULT IN A VERY SPECIFIC PLAN/SPECIFIC DATA FLOW WITH NLJN AND DATKnown IssueT TABLE ON THE INNER AND NULL KEYS. IT35486 2 DB2 ABORTS WITH VARIOUS SYMPTOMS WHEN USING JSON FUNCTIONS - EG. JSON_TO_BSON AND BSON_TO_JSON - IN A DPF ENVIRONMENT. IT34579 3 DB2 BACKUP OPERATIONS USING THE NETBACKUP (NBDB2.S064) LIBRARY FAIL WITH SQL2079N ERROR Fix Pack m5fp1 - Communication IT35289 1 SECURITY: IBM DB2 CLIENT MAY HANG IN THE EXECUTION OF THE TERMINATE COMMAND (CVE-2020-5024) IT34882 2 INTERMITTENT GSKIT ERROR 17 OR GSKIT ERROR 106 FROM DB2 CLIENTS WHEN USING SSL IT34504 2 GSKKM_STORECACERT: GSKIT ERROR = 100 ERRORS IN DB2DIAG.LOG Fix Pack m5fp1 - DRDA Services IT35750 2 THE FUNCTION WHICH TESTS THE 'FAILOVER' MEMBER DOES NOT TAKE SSL INTO ACCOUNT. IT34432 2 FAILBACK PING INCORRECTLY USES TCPIP INSTEAD OF SSL Fix Pack m5fp1 - Data Management Services IT34294 1 SECURITY: IBM® DB2® IS VULNERABLE TO A DENIAL OF SERVICE ON WINDOWS (CVE-2020-4642) Fix Pack m5fp1 - Data Management Utilities IT35936 2 DB2 CAN TRAP DURING AN HPU UNLOAD IN INITIALIZEONEDATKnown IssueT FUNCTION IT35965 3 REMOTE LOAD FROM CURSOR FAILED WITH SQL0902C RC84 WHEN SOURCE TABLE HAS LOB COLUMN Fix Pack m5fp1 - Engine Other IT35987 2 "114 ATTEMPT TO ACCESS ITEM BEYOND BOUNDS OF MEMORY" ERROR OCCURED IN 32 BIT MODE. Fix Pack m5fp1 - Federation IT33598 2 INSERT STATEMENT FAILS WITH -901 ERROR USING FEDERATION IT35968 2 WHILE QUERYING THE WEB SERVICE NICKNAME, FEDERATION SERVER REPORTS ERROR SQL1822N IT34588 2 SQL30090N WHEN WE USE UPDATE WITH PLACEHOLDER (VARIABLE) VIA JDBC IT35226 2 CREATE OR REPLACE NICKNAME ON REMOTE DB2I SERIES (AS400) FAILS WITH SQL0901 AND DUMP FOLDER FODC_APPERR IS CREATED JR62802 2 PROBLEM RUNNING UPDATE ON MARIADB (FEDERATION) IT34941 2 QUERY ON NICKNAME RESULTS WITH VALUES TRUNCATED ON MARIADB IT34862 2 DB2 CRASH DUE TO A -901 WAS RAISED BY MINMAXPARTIALEVALUATOR.CPP WHEN MAX(TO_CHAR()) OR MIN(TO_CHAR()) EXISTS IN THE SELECT LIST Fix Pack m5fp1 - Install and Catalog Services IT35672 2 UPDATING NETNAMES HIT ISSUE SAYING RSCT PEER IN REGISTRY DOES NOT MATCH ACTIVE DOMAIN NAME IT33810 2 INVALID LICENSE ERROR USING DB2 CONNECT LICENSE WITH .NET CLI DRIVER ON OPENSHIFT CONTAINER Fix Pack m5fp1 - Platform Specific IT34929 2 ADD ENVVAR TO OVERRIDE WINDOWS COMMONAPPDATA PATH Fix Pack m5fp1 - Problem Determination IT33783 2 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS) Fix Pack m5fp1 - Process Model IT34261 1 IMPROPER LATCHING WHEN PROCESSING SQLEDIRCACHE DURING CONNECTING TO DATABASES CAN LEAD TO INSTANCE ABEND Fix Pack m5fp1 - Query Compiler Optimizer IT35198 1 A QUERY ON COLUMNAR TABLES MAY RETURN MORE ROWS THAN EXPECTED IT35183 2 POOR QUERY PERFORMANCE WHEN IN SUBQUERY PREDICATE WITH NO DISTINCT. Fix Pack m5fp1 - Query Compiler QGM IT34950 1 DB2 SERVER TERMINATES ABNORMALLY WHEN SELECT FROM INVALID VIEWS IT34758 2 SELECT DISTINCT QUERY FAILS WITH SQL0421 WHEN USED WITH SCROLLABLE CURSOR IT35670 2 REGEXP_REPLACE AND REGEXP_SUBSTR WITH COLUMN-ORGANIZED TABLE MAY RESULT IN -901 IT34613 2 INCORRECT RESULTS WITH DB2_EXTENDED_OPTIMIZATION='MQTENFORCE REPLICATED' IT35925 2 DISTRIBUTION KEY ORDER IS NOT INHERITED FROM THE AS-RESULT-TABLE WHEN COISBAR IS ENABLED IT34311 2 QUERY WITH ALIAS FOR COMPLEX COLUMN USED IN GROUP BY CLAUSE TRAPS AND GENERATES FODC IT34860 2 DB2 QUERY MAY HANG WITH REGISRTY SETTING INJ_DUMMY_PRD4JOIN IT34304 2 SQL0344N ERROR MAY OCCUR IN NON-UNICODE, VARCHAR2 ENABLED DATABASE WHEN QUERY REFERENCES SYSIBM.SYSDUMMY1 OR SYSIBM.DUAL IT34222 3 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE IT34940 3 WRONG RESULT WHEN EQUALITY PREDICATE HAS IS NOT NULL WITH FALSE ON OTHER SIDE. Fix Pack m5fp1 - Relational Data Services IT33355 2 DEADLOCK BETWEEN INVALIDATION OF PACKAGE AND IMPLICIT REBIND OF THE SAME PACKAGE. IT35546 2 -901 SQLCODE DURING REBIND FOR PACKAGES BOUND WITH CERTAIN BIND OPTIONS IT34671 2 MULTIPLE EXPLICIT REBIND OF SAME PACKAGE MAY ENCOUNTER DEADLOCK IT33429 2 SQL1598N MIGHT BE RAISED IF A LICENSE WAS NOT APPLIED BEFORE SIMULTANEOUS ATTEMPTS TO CONNECT THROUGH THE DATA SERVER DRIVER IT35221 2 WLM ADMISSION CONTROL DOES NOT PROPERLY TRACK ACTUAL MEMORY HIST ORY FOR SHORT QUERIES. THIS CAN LEAD TO UNNECESSARY QUEUING OF V Fix Pack m5fp1 - Sailfish Operational Compatibility IT35770 2 OOM HIT WHILE RUNNING ET NZ INTERNAL FORMAT MIGRATION. IT35855 2 MEMORY LEAK ENCOUNTERED WHEN YOU HAVE MORE THEN 1COLUMN OF SAME TYPE FROM TIMESTAMP/TIME/DATE WITH DB2 FORMAT SPECIFIED FOR IT IT35165 2 DB_MIGRATE ISSUE WITH INTERNAL FORMAT WHEN INPUT STRING AFTER CODEPAGE CONVERSION EXCEED THE TARGET COLUMN SIZE. Fix Pack m5fp1 - Security IT35445 1 SECURITY: DB2 CREATES SOME FILES WITH INSECURE PERMISSIONS (CVE-2020-4976) IT36060 2 IN RARE INSTANCES, DB2 11.5.5 MAY CRASH DURING DB2START WHEN JWT AUTHENTICATION IS ENABLED IT36085 2 DB2 11.5.5 MAY ENCOUNTER SQL30082N RC 15 WHEN USING GSS_SERVER_ENCRYPT OR KRB_SERVER_ENCRYPT AUTHENTICATION Fix Pack m5fp1 - pureScale Services IT36088 1 DB2CLUSTER -VERIFY MIGHT FAIL DURING RDMA PING DUE TO SEG FAULT IT36086 1 DB2CLUSTER -VERIFY POTENTIAL HANG IT35303 1 SECURITY: IBM DB2 DB2FM IS VULNERABLE TO A BUFFER OVERFLOW (CVE-2020-5025) IT35552 2 CF CHANGE TO ADD BREATHING POINT FOR DAT_EVD_DEQUEUE IT35558 2 SIGNAL 11 TRAPS DURING CTSNAPS AFTER ROCE CABLE PULLS IT35662 2 CREATE TABLE STATEMENTS ARE HANGING DUE TO RDMA COMMUNICATION TIMEOUTS BETWEEN MEMBER AND CF ON ZLINUX DB2 Version 11.5 Fix Pack m5fp0 Known Issue Sev. Abstract Fix Pack m5fp0 - 1 IT34866 3 IT34866: ADDITIONAL FIX TO Known Issue IT13674, TEST FOR -NOEXEC MOUNT INCORRECTLY FAILS IN DB2SETUP SCRIPT IT33863 3 PURESCALE MEMBER MIGHT HANG WAITING FOR SQLO_LT_SQLB_BPD__BPDLAT CH_SX WHILE IN SQLBGBUPGRADELATCHFROMSHAREDURINGWAR IT33576 3 REDUCE CHANCE OF SQL0289N IT33525 3 INACCURATE RESULT OF DECIMAL DIVISION ON NON-AIX PLATFORM Fix Pack m5fp0 - Administration Tools IT34534 3 DB2 ADMINISTRATIVE TASK SCHEDULER STOPS EXECUTING SCHEDULED TASKS Fix Pack m5fp0 - Buffer Pool Services IT34560 2 DB2 ENGINE ABEND FOLLOWING DROP TABLE AND SQLBPREPARE2FREEEXTONTEMPSMP SEVERE ERROR Fix Pack m5fp0 - CDE Data IT33714 1 RUNNING REPLICATED CDE WORKLOAD WITH INVALID DB2_DCC_FILE_PATH VALUE WILL CAUSE DB2 TO FAIL WITH SQL1224. IT33570 2 A CDE UPDATE STATEMENT MIGHT FAIL WITH SQL0901N '!ISROWLOGBUFFERINITIALIZED()' AND TRAP IN SQERDFSROWSERIALIZER IT34280 2 CREATE TABLE FAILING WITH "NO MEMORY AVAILABLE IN 'APPLICATION HEAP' IT34500 2 REORG RECLAIM CODE CAN LEAD TO DEADLATCH IT33707 2 FODC_FORCEDBSHUTDOWN OCCURS AFTER AN INSERT STATEMENT IS INTERRUPTED AND ATTEMPTS TO ROLL BACK. Fix Pack m5fp0 - CDE Query IT34026 2 INSTANCE COULD GO DOWN WHEN DOING A FULL OUTER JOIN ON TWO COLUMNAR ORGANIZED TABLES WITH NULL COLUMNS IT34235 2 IMPROVE PERFORMANCE BY IMPLEMENTING SCALAR FUNCTIONS DAYOFMONTH, DAYS_TO_END_OF_MONTH IN COLUMNAR ORGANIZED LOGIC. IT34147 2 VARIOUS ERROR POSSIBLE: SQL0901N , SQL0955N IT33467 2 CDE HSJN WITH RESIDUAL PREDICATES THAT HAVE SCALAR FUNCTION APPL IED TO A HOST VARIABLE OR REGISTRY VARIABLE COULD FAIL WITH -901 IT33293 2 QUERY FAILING WITH SQL0901N AND AN ASSERTION FAILURE "UNABLE TO ACCESS TARGET PAGE FROM PAGE MAP" Fix Pack m5fp0 - Client Interfaces IT33902 2 INTERMITTENT FAILURE WITH CLR_EXCEPTION_SYSTEM.OBJECTDISPOSEDEXCEPTION IT31498 3 SQL2731N WHEN AN INPUT FILE SIZE OF ZLOAD IS BIGGER THAN 4GB IT32956 3 DB2 .NET PROVIDER WITH DOUBLE HYPHENS () STYLE COMMENT IN SQL STATEMENT HAVING NAMED PARAMETERS THROWS SQL0206N IT32276 3 NO SQL OVERFLOW ERROR WHEN INSERTING A DECIMAL(20,4) THAT DOES NOT FIT INTO A SMALLINT OR INTEGER COLUMN IT33640 3 IBM DATA SERVER ADD-INS FOR VISUAL STUDIO (VSAI) DOES NOT SHOW NON-TABLE SCHEMAS Fix Pack m5fp0 - Codegen and Runtime IT33578 2 OPTIMIZE THE PERCENTILE_CONT AGGREGATE FUNCTION TO USE MEMORY MORE EFFICIENTLY AND SPILL TO TEMP IF REQUIRED IT33236 2 COMPLEX QUERIES WITH EXISTS CLAUSE ON A COLUMNAR TABLE EXECUTED WITH DEGREE GREATER THAN 1 MAY HANG Fix Pack m5fp0 - Data Recovery Services IT32894 1 DB2 : SET WRITE RESUME COMMAND HANGS IT34022 2 DB2 MIGHT TRAP WHEN EXECUTING MON_GET_UNIT_OF_WORK IT33533 3 SQL0913 RC=80 NOT BEING CAPTURED BY DB2PDCFG -CATCH LOCKTIMEOUT IT32560 3 ILOGS ARE ARCHIVED TO BOTH LOG ARCHIVING METHODS ONLY FROM THE ACTIVE LOG PATH WITH DUAL LOGGING ENABLED Fix Pack m5fp0 - Federation IT32523 1 PRIVATE MEMORY LEAK DURING DDL ON COLUMN-ORGANIZED TABLES IN DPF ENVIRONMENT JR62529 2 QUERIES ON NICKNAMES TO TABLE ON MARIADB RETRIEVES ONLY FIRST CHARACTER OF COLUMN NAMES JR62557 2 FEDEATION MARIADB JDBC: DATA TYPE MAPPING ERROR JR62556 2 INSERT INTO SELECT ERROR ON JDBC Fix Pack m5fp0 - Index Manager IT31287 1 DB2 MAY TRAP WHEN USING SELECT RID_BIT() FUNCTION ON A COLUMN ORGANIZED TABLE Fix Pack m5fp0 - Install and Catalog Services IT33705 1 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES IT32984 1 SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4411) IT32939 1 SECURITY: IBM® DB2® LUW AFFECTED BY A DENIAL OF SERVICE VULNERABILITY IN IBM® SPECTRUM SCALE (CVE-2020-4412) IT34221 1 SECURITY: LOCAL PRIVILEGE ESCALATION IN IBM DB2 WINDOWS CLIENT IT33708 2 DB2ICRT FAILS WHEN CHECKING GPFS ON PURESCALE IT33515 2 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES IT34039 2 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS FOR CDE TABLE MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. IT32679 2 ROUTINE MIGRATION FAILS WITH A SQL0478N WHEN A ROUTINE IS USED AS PART OF A TABLE DEFINITION IT33548 2 AFTER UPGRADING TO DB2 V11.5.4, IT IS POSSIBLE TO SEE SQL901 ERRORS AND ENGINE CRASHES IT33712 3 COMPLETE FIX FOR IT13674 IT33312 3 DB2ICRT AND DB2PREQCHECK FREE SPACE AND HOST FAILURE Fix Pack m5fp0 - JDBC Driver IT32581 3 CLPPLUS 11.5 CLIENT THROWS EXCEPTION SQL20570N WITH EXTERNAL TABLE OPERATION HAVING EMPTY FILE WITH GZIP COMPRESSION IT33041 3 JCC DRIVER NOT SENDING COMMIT AFTER THE LICENSE SP CALL EVEN IF AUTOCOMMIT IS TRUE IT33602 2 INSERT FROM EXTERNAL TABLE FAILS WITH SQLCODE -4499 -T2LUW Fix Pack m5fp0 - Monitoring IT34023 2 FODC_PANIC WITH INVALID LATCH FROM SQLOLATCHCAS64.C WHEN ROUTINE EXECUTION LIST MONITORING IS ENABLED. IT33264 3 CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N Fix Pack m5fp0 - Parsing and SQL PL IT34440 2 ABNORMAL TERMINATION WHEN EXECUTING THE CREATE-STATEMENT OF A NZPLSQL STORED PROCEDURE IT33885 3 DB2 MAY ATTEMPT TO REPEATEDLY OPEN A NON-EXISTENT FILE WHICH MAY IMPACT QUERY COMPILATION PERFORMANCE Fix Pack m5fp0 - Platform Specific IT34140 1 SQL20569N WITH REASON CODE "4" DURING LOADING LZ4 COMPRESSED IT34101 3 FMP PROCESS CAN HANG IN NESTED SIGNAL HANDLER CODE PATH Fix Pack m5fp0 - Problem Determination IT33783 2 DB2DIAG TOOL MAY GENERATE ENDLESS LOOPING OUTPUT WHEN USED WITH -T / -H (TIME PERIOD SPECIFIERS) Fix Pack m5fp0 - Process Model IT33508 1 IN DPF ENV, SORTSHRHEAPUTIL THRESHOLD MAY NOT TRIGGER PREDICTIVELY FOR QUERIES USING SORT MEMORY ON DATA NODES IT34607 2 DB2CFIMP ADDS TRAILING CHARACTERS TO DB ALIAS. IT33186 2 LOCK-WAIT ON DECOUPLED DB2ADCBLD IT34257 2 DB2 WLM MAY CAUSE UNNECESSARY QUEUING AFTER INSERTS TO EXTERNAL TABLES IN A PARTITIONED DATABASE IT34284 2 SORT MEMORY HARD CAPPING AND OVER-ESTIMATION ERROR CORRECTION FIXES IN WLM IT33826 2 LIST STORAGE ACCESS COMMAND GIVES 0 ENTRIES EVEN IF THE CATALOG STORAGE ACCESS COMPLETED SUCCESSFULLY Fix Pack m5fp0 - Quality Assurance IT34614 4 SECURITY: MULTIPLE BUFFER OVERFLOW VULNERABILITIES AFFECT DB2 Fix Pack m5fp0 - Query Compiler Optimizer IT33554 2 SQL0901N PARTITIONED BLU SORT WITH 0 PARTCOLS IS UNEXPECTED IT34007 2 DB2 SERVER TERMINATES ABNORMALLY WHEN GETTING PLAN IN EXPLAIN MODE. IT33338 2 COLUMNAR SEARCHED UPDATE AND DELETE STATEMENTS EXECUTING WITH HS JOIN THAT APPLIES RESIDUAL PREDICATES MIGHT FAIL WITH SQL0901N " Fix Pack m5fp0 - Query Compiler QGM IT32992 1 WRONG RESULT, WHEN OPTIMIZATION LEVEL IS LESS THAN 5 AND NULL EQUALS NULL PREDICATE IT34308 2 REPLICATED MQT MATCH MAY FAIL IN SOME SPECIFIC SITUATIONS IT33171 2 WRONG RESULT WHEN QUERY HAS SCALAR SUBQUERY AND FETCH FIRST 1 ROW IT34382 2 POOR PERFORMANCE WHEN IN-LIST TO JOIN CAUSING EARLY COMPENSATION IT33459 2 FIX ISSUES WITH OPTIMIZER VERSION CONTROL (DB2_OPTIMIZER_VERSION REGISTRY VARIABLE) IT33527 2 POOR PERFORMANCE OF DB2 QUERY HAVING IN SUBQUERY PREDICATE IT34115 2 INCORRECT QUERY OPTIMIZATIONS RESULTING IN POOR PERFORMANCE OCCUR WHEN STATEMENT CONCENTRATION IS ENABLED IT32923 2 DB2 MAY ABEND WHEN COLUMN ALIAS USED IN PREDICATE. IT33870 2 SQL901 WHEN SUBQUERY PREDICATE USED WITH OUTER JOIN IT32640 2 QUERY FAILS WITH SQL0901 "NO CAST FUNCTION" WHEN DB2_ENABLE_MULTIPLE_CCSIDS=TRUE, DATABASE IS UNICODE IT33577 2 PERFORMANCE: NEQN (I.E. NULL EQ NULL) PREDICATES NOT DETECTED BY MAGIC DECORRELATION IT34078 2 DB2 MAY NOT GENERATE TRAILING SPACE AFTER GROUP BY IT33822 2 HANG IN WHERE ALIAS DUE TO CYCLIC REFERENCE. IT34222 3 901 WHEN CDE TABLE JOINED WITH FEDERATED TABLE IT33557 3 USING "ISNOTTRUE" OR "ISNOTFALSE" ROUTINES WITH DECFLOAT DATA TYPE RETURNS SQL0440N IT33871 3 DISTRIBUTION KEY ORDER WAS NOT INHERITED FROM THE AS-RESULT-TABLE Fix Pack m5fp0 - Relational Data Services IT33691 1 ON DPF INSTANCE APPLICATIONS MAY HANG WHILE DOING A COMMIT IT34110 2 -901 SQLCODE (CANNOT FIND CURSOR INFO IN ERT) FOLLOWED BY TRAP Fix Pack m5fp0 - Routine Infrastructure IT34156 2 ALLOW FMP POOLING FOR SPECIFIC USER IDS Fix Pack m5fp0 - Sailfish Operational Compatibility IT34151 2 USING PIPE INTERFACE DURING UNLOAD OPERATION IF PIPE IS USED IT33740 2 CREATE EXTERNAL TABLE USING SAMEAS/LIKE WITH BASE TABLE HAVING HIDDEN COLUMN IS GETTING CREATED WITH HIDDEN COLUMN IT33615 2 SQL20570N WHILE LOADING EMPTY FILE USING OPTION REMOTESOURCE GZIP SAME WORKS FINE WITH LZ4 IT34356 2 FMP TRAP WHILE USING -FORMAT INTERNAL DUE TO SCHEMA MISMATCH Fix Pack m5fp0 - Security IT34107 2 HIGH CPU USAGE WHEN DB2_ALTERNATE_GROUP_LOOKUP REGISTRY VARIABLE AND OS GROUP NAMES DOES NOT MATCH DB2 NAMING RULES Fix Pack m5fp0 - pureScale Services IT33790 3 DB2AUTOSTART DOES NOT WORK ON REBOOT WHEN OS REBOOT IS VERY FAST. IT33851 3 TSA INITIATED TAKEOVER IN AN AUTOMATED HADR ENVIRONMENT MAY FAIL DUE TO PEER WINDOW HAVING EXPIRED. DB2 Version 11.5 Fix Pack m4fp0 Known Issue Sev. Abstract Fix Pack m4fp0 - Buffer Pool Services IT32436 2 HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR Fix Pack m4fp0 - CDE Data IT30387 1 DB2 MIGHT HANG WITH AN EDU WAITING ON SQLO_LT_SQLD_CHAIN__FULLCH AINLATCHNS WHILST HOLDING SQLO_LT_SQELOCALDATABASE__DBLATCH IT33198 2 IN DB2 V11.5 GA, SQL0901N ERROR MAY OCCUR WITH DB2DIAG.LOG SQLER RMC "UNEXPECTED ERROR AT SYNOPSISTABLETUPLEACCUMULATOR.HPP:130" Fix Pack m4fp0 - CDE Query IT32589 1 CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON IT31975 2 SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN IJ24133 2 WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. Fix Pack m4fp0 - CLI IV98044 2 NEW MONGODB CLIENTS ARE UNABLE TO CONNECT TO IBM JSON WIRE LISTENER IT31045 3 BULKCOPY ERROR WHILE CHAIN INITIALIZATION WITH NULL VALUE FOR DECIMAL COLUMNS IT33421 2 SQLGETCONNECTATTR() FUNCTION CALL WITH SQL_ATTR_GET_LATEST_MEMBER_NAME TAKING TIME DUE TO GETADDRINFO TAKING MORE TIME IT30451 2 NOT ABLE TO LOAD AND USE THE DB2CLIO.DLL IT33461 3 ERROR ENCOUNTERED WHILE FETCHING SMALLINT DATA USING IBM DATASERVER PROVIDER FOR ENTITY FRAMEWORK CORE Fix Pack m4fp0 - Codegen and Runtime IT32599 2 QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW IT32367 2 SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB Fix Pack m4fp0 - Communication IT32766 1 SECURITY - DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK IT32357 1 SECURITY: DB2 IS VULNERABLE TO BUFFER OVERFLOW LEADING TO PRIVILEGE ESCALATION Fix Pack m4fp0 - DRDA Services IT32363 2 SECURITY: IBM® DB2® LUW IS VULNERABLE TO A DENIAL OF SERVICE ATTACK Fix Pack m4fp0 - Data Management Services IT33146 1 DB2 SERVER TERMINATES ABNORMALLY DURING ROLLFORWARD RECOVERY IN THE SQLPLRQ FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. IT33218 1 DB2 SERVER TERMINATES ABNORMALLY IN THE SQLDFETCHLARGEROW FUNCTION WITH DB2_4K_DEVICE_SUPPORT=ON SET. IT30494 2 CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY Fix Pack m4fp0 - Data Recovery Services IT33172 3 SLOW DATABASE RECOVERY LOG REPLAY ON A WORKLOAD WITH MANY DDLS SPECIFICALLY CREATE / ALTER / TRUNCATE / DROP TABLE Fix Pack m4fp0 - Federation IT31455 3 CREATE SERVER COMMAND IS FAILED IN SQL1816N WHEN DB2/LUW IS SPECIFIED IN V11.5 Fix Pack m4fp0 - Install and Catalog Services IT31637 1 SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) IT29745 1 IN A PURESCALE ENVIRONMENT, DB2IUPDT COMMAND FAILS ON RHEL 7.6 AS IT CHECKS FOR AN OBSOLETE PACKAGE (LIBIBCM) IT32256 2 DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY IT31741 2 DB2PREREQCHECK FILLS UP / AND /TMP DUE TO SCP TSAMP WITH UNNECES SARY FILES DURING PURESCALE INSTALLATION OR DB2IUPDT COMMAND IT31588 3 WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID IT32751 2 HADR STANDBY FAILS WITH "BAD ENTRY STATE" REPORTED FROM SQLRLC_AUTH_GR_PROCESS_ENTRY_STATE Fix Pack m4fp0 - JDBC Driver IT30972 2 JDBC DRIVER NOT TERMINATING TIMER THREADS WITH VERSION 4.26.14 IT29195 2 CLPPLUS DOES NOT RUN THE LOGIN.SQL SCRIPT DURING STARTUP. IT32580 2 INTRODUCED A NEW PROPERTY USEJDBC4DATATYPE IN JCC DRIVER AS IT IS NOT BACKWARD COMPATIBLE FOR CLOB/CHAR/VARCHAR DATA TYPE. IT31612 3 PIGGYBACK COMMANDS ARE NOT REPLAYED IF FAILURE HAPPENS DURING FIRST SQL EXECUTION IN CASE OF NON-SEAMLESS FAILOVER IT33042 2 DB2STOP MEMBER CAUSED JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION Fix Pack m4fp0 - Monitoring IT31573 2 DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. Fix Pack m4fp0 - Platform Specific IT31007 2 DT159865: MULTIPLE CLP FRONTENDS ISSUED FROM DIFFERENT SHELL SCRIPTS USES THE SAME BACKEND AGENT, CAUSING UNEXPECTED RESULTS OR ERRORS. IT31704 2 MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES IT32507 3 ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() Fix Pack m4fp0 - Problem Determination IT32716 1 SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE AND DENIAL OF SERVICE IT32689 1 SECURITY: IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE IT32714 1 SECURITY: IBM® DB2® IS VULNERABLE TO AN INFORMATION DISCLOSURE Fix Pack m4fp0 - Process Model IT32439 1 INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES IT31679 3 DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH IT31378 2 DB2STOP FAILS WITH SQL6037N, LEAVING [DB2SYSC] Fix Pack m4fp0 - Query Compiler Optimizer IT32195 2 IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS Fix Pack m4fp0 - Query Compiler QGM IT31167 2 SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT IT31557 2 SQL1224N AFTER CERTAIN OUTER JOIN QUERIES IT32731 2 DB2 SERVER TERMINATES ABNORMALLY DURING QUERY COMPILATION IT28109 2 INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? IT32612 2 -901 ERROR IS HAPPENED(BAD PLAN; UNRESOLVED QNC FOUND) WHEN EXECUTING PACKAGE REBIND IN V11.5. IT31862 2 TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE IT31634 2 WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. Fix Pack m4fp0 - Relational Data Services IT31701 1 APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS Fix Pack m4fp0 - Routine Infrastructure IT32126 2 MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO Fix Pack m4fp0 - Sailfish Operational Compatibility IT32568 2 FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH Fix Pack m4fp0 - Text Search IT31755 2 THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 Fix Pack m4fp0 - pureScale Services IT31054 3 EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" IT31454 3 EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" IT40847 2 DT147376: ENDLESS ITERATION OF DB2 CLEANUP AND KILL PROCESSES MAKE DB2 PURESCALE CLUSTER HANG DB2 Version 11.5 Fix Pack m3fp0 Known Issue Sev. Abstract Fix Pack m3fp0 - Buffer Pool Services IT31892 1 CRASH RECOVERY CAN FAIL AFTER INCORRECTLY REPLAYING EXTENT MOVEMENT LOG RECORDS WITH LARGE RECOVERY WINDOW IT32436 2 HADR STANDBY MAY START UP WITH SYSTEM BUFFER POOLS ONLY, INSTEAD OF RETURNING AN SQL1768N ERROR Fix Pack m3fp0 - CDE Data IT31385 3 INCORRECT CALCULATION OF COLUMNAR-ORGANIZED TABLE SPACE CONSUMPTION IN TBPSIZE_ENTITLEMENT_REQ.SQL Fix Pack m3fp0 - CDE Query IT32589 1 CDE JOIN CAUSES CRASH WHEN DB2 TRACE IS TURNED ON IT31975 2 SELECT WITH SUBSTRING() RETURNS SQL0138N FOR TABLE ORGANIZED BY COLUMN IT31628 2 SQL STATEMENT WITH ORDER BY ACCESSING COLUMNAR TABLES MAY BE HUNG IN DPF IJ24133 2 WE MAY FAIL WITH -901 SQL0901N WHEN LENGTH FUNCTION RETURN NEGATIVE OR 0 BUT WE SHOULD RETURN ERROR SQL0138N. IT31619 2 IN DPF AGAINST COLUMNAR TABLES WRONG RESULT IS POSSIBLE FOR SQL WITH LIMIT WHEN OVER(PARTITION BY) AND ORDER BY IS USED IT30770 2 SORTHEAP IS TOO SMALL Fix Pack m3fp0 - Client Interfaces IT31515 1 SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK. (CVE-2020-4200) Fix Pack m3fp0 - Codegen and Runtime IT31163 1 WRONG RESULTS ARE POSSIBLE WITH COMPLEX SQL WHICH USES UDFS AND CONSTANTS AND ENCOUNTER A COMPLEX PLAN. IT31783 2 POSSIBLE TRAP (SEGV) WHEN RUNNING A QUERY ON A NICKNAME POINTING TO A FEDERATED SOURCE AND FEDERATED GOES DOWN. IT32599 2 QUERY THAT WORKED IN 20 SECONDS ON IDAA V5 / NETEZZA TAKES NOW 70 SEC / 120 SEC ON IDAA V7 / DB2 LUW IT32367 2 SQL0302N - DB2CI CLOB/BLOB PROCESSING FOR COLUMNS GREATER 1 MB Fix Pack m3fp0 - Data Management Services IT30494 2 CURRENTLY COMMITTED QUERY IN A PURESCALE ENVIRONMENT MAY RETURN SQL0952N UNEXPECTEDLY Fix Pack m3fp0 - Data Recovery Services IT30259 2 ROLLFORWARD FAILS DURING LOG CHAIN SWITCH WHEN RUN WITH NORETRIEVE AND OVERFLOW PATH IT30816 3 MESSAGE PDRECOVERY, PROBE:10 AND PROBE:20 IS LOGGED WITH EACH DIAGEVEL Fix Pack m3fp0 - Federation IT32121 1 SECURITY: MULTIPLE VULNERABILITIES IN DEPENDENT LIBRARIES AFFECT DB2 LEADING TO DENIAL OF SERVICE OR PRIVILEGE ESCALATION IT32598 2 [FEDERATION]CREATE NICKNAME FAILS WITH -901 WHEN COLUMN IS DECIMAL(P,S) P>31 Fix Pack m3fp0 - Install and Catalog Services IT31637 1 SECURITY: DB2 IS VULNERABLE TO MULTIPLE BUFFER OVERFLOWS (CVE-2020-4204) IT32256 2 DB2CKUPGRADE PERMISSION OBJECT DEPENDENCY IT31588 2 WHEN UPGRADING THE INSTANCE, .FENCEDID FILE SHOULD BELONG TO FENCEDID NOT INSTANCEID IT31924 2 INVOKE SCP WITH THE -T OPTION DUE TO CVE-2019-6111 Fix Pack m3fp0 - Monitoring IT31573 2 DB2_REDUCED_OPTIMIZATION COULD NOT BE APPLIED BY SET CURRENT OPTIMIZATION PROFILE ON BLUDB/DB2WH. IT20712 3 SYSIBMADM.LOG_UTILIZATION IS RETURNING SQL0801N ON STANDBY Fix Pack m3fp0 - Platform Specific IT31704 2 MON_GET_TABLE/MON_GET_INDEX TABLE FUNCTIONS MIGHT RESPOND SLOWER WHEN EXECUTED CONCURRENTLY ON DATABASES WITH MANY TABLES IT31615 2 UNNECESSARY SQLO_BAD_USER LOGGING INTO DB2DIAG.LOG IT22910 3 PDHADDCOUNTER FAILED WITH OSERR -1073738824IN FUNCTION OSSGETPROCESSRAWCPUUSAGE() IT32507 3 ON RARE OCCASIONS, DB2 MAY CRASH/TRAP IN SQLOGETTIDFROMEDUID() Fix Pack m3fp0 - Process Model IT31520 1 SECURITY: DB2 IS VULNERABLE TO A DENIAL OF SERVICE ATTACK (CVE-2020-4135) IT32439 1 INSTANCE CRASH, SQEWLMADMISSIONQUEUE::RELEASERESOURCES IT31679 3 DURING DB2START, "SETTING NON-SHARD SQLLIB" MESSAGE IS STILL ADDED TO DB2DIAG.LOG IN THE DEFAULT DIAGPATH Fix Pack m3fp0 - Query Compiler Optimizer IT31132 2 DB2 OPTIMIZER INCORRECTLY RECOMMENDS AN INDEX AS PREREQUISITE FOR ZIGZAG-JOIN IT32195 2 IF THE ROW WIDTH PROCESSED BY A PARTIAL AGGREGATION OPERATOR IS MORE THEN 32K THEN WE COULD GENERATE INCORRECT RESULTS IT30946 2 DB2 MAY ABEND WHILE USING PARTICULAR EXPLAIN MODES Fix Pack m3fp0 - Query Compiler QGM IT29945 1 10 CHAR VALUE CAN BE INSERTED INTO VARGRAPHIC(5 CODEUNITS32). THIS SHOULD FAIL WITH SQL0433N ERROR. IT31557 2 SQL1224N AFTER CERTAIN OUTER JOIN QUERIES IT30866 2 DB2 SERVER TERMINATES ABNORMALLY IN SQLNQ_UDF_SPECIFIC WITH STMT_CONC=LITERALS IT28109 2 INSERT QUERY FAILS WITH A -901 AND ERROR MESSAGE ?ERROR PUSHING DOWN HEAD EXPRESSION? IT30926 2 TRANSFER OWNERSHIP MAY CAUSE THE DB2 SERVER TO TERMINATE ABNORMALLY IT31862 2 TRAP WHEN COMMON TABLE ACCESSED WITH MULTIPLE COLUMN PREDICATE IT31634 2 WRONG RESULT IN UPDATE STATEMENT HAVING CORRELATION. Fix Pack m3fp0 - Relational Data Services IT31701 1 APPLICATION MEMORY CONTINUALLY GROWS IN DPF ENVIRONMENTS AFTER UPGRADING TO RECENT FIX PACK LEVELS Fix Pack m3fp0 - Routine Infrastructure IT32126 2 MEMORY LEAK IN FMP PROCESS WHEN KEEPFENCED IS NO Fix Pack m3fp0 - Sailfish Operational Compatibility IT32568 2 FIXED FORMAT EXTERNAL TABLES: SQL20570N ERROR WHEN DECIMAL DATATYPE FIELD LENGTH IS SAME AS THE COLUMN LENGTH IT31437 2 EMPTY STRING IS NOT INSERTED AS NULL VALUE WHEN NULLVALUE IS EMPTY STRING Fix Pack m3fp0 - Security IT31969 3 EXTRA PRIVILEGES ON NULLID.ATSO05 PACKAGE ARE ADDED TO PUBLIC AFTER RESTORING OLDER RESTRICTIVE DATABASE IMAGE Fix Pack m3fp0 - Text Search IT31755 2 THE UPPER LIMIT FOR MASKRESOLUTIONLIMIT PARAMETER IS SET TO TOO LOW VALUE - 10000 IT31449 2 INTERMITTENT HANG IN SOCKET SELECT Fix Pack m3fp0 - pureScale Services IT31054 3 EVEN IF RESERVE_POLICY IS RECOMMENDED TO NO_RESERVE, DB2PREREQCH ECK -TB_DEV NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" IT29256 3 DB2INSTANCE -LIST MAY SHOW THE SECONDARY CF IN TRANSIENT ERROR STATE DURING CATCH UP ON BUSY SYSTEMS. IT31454 3 EVEN IF RESERVE_POLICY IS SET TO PR_EXCLUSIVE, "DB2PREREQCHECK -TB_DEV" NOT SUCCEED WITH "WARNING: REQUIREMENT NOT MATCHING" DB2 Version 11.5 Fix Pack m2fp0 Known Issue Sev. Abstract Fix Pack m2fp0 - Buffer Pool Services IT31716 1 ON RARE OCCASION, DATA CORRUPTION MIGHT BE INDUCED BY FAILURE TO PANIC THE DATABASE ON ENCRYPTION ERROR. IT30898 2 TABLESPACE CONTAINERS COULD BE DELETED WHEN A STORAGE GROUP EXIST ON DBPATH IT30326 2 INSTANCE MAY TRAP IN FUNCTION SQLBGETVICTIMFROMBLOCKHATELIST Fix Pack m2fp0 - CDE Data IT31719 2 ADDING A NEW TABLE USE FOR DISABLING VECTORIZED ADC Fix Pack m2fp0 - CDE Query IT31181 2 INSTANCE CAN GO DOWN WHEN COLUMN ORGANIZED TABLES ARE USED Fix Pack m2fp0 - Codegen and Runtime IT29583 2 MEMORY LEAK RELATED TO JSON QUERIES. IT30005 2 DB2 MAY PRODUCE INCORRECT RESULTS FOR HSJN WITH PREDICATE THAT HAS CASE(COALESCE) AND NLJN OR ZZJOIN ON THE OUTER IT30456 2 INSERT INTO ... WITH IGNORE DUPLICATES MIGHT FAIL WITH -901 REASON "SQLRIOPN: TABLE IS NOT CREATED" Fix Pack m2fp0 - Data Management Services IT30965 1 AN ISCAN FETCH USING CURRENTLY COMMITTED IN PURESCALE MAY RETURN UNCOMMITTED RESULTS. IT29634 2 INTERRUPTING ROLLFORWARD OPERATIONS DURING REPLAY CAN CAUSE SUBSEQUENT ROLLFORWARD TO FAIL IT30061 2 DB2 TAKES Z LOCK WHEN ATTACHING PARTITION TO TABLE Fix Pack m2fp0 - Federation IT30251 1 WRONG RESULTS ARE POSSIBLE FOR FEDERATED OR COLUMNAR QUERY WITH AGGREGATION OVER DISTINCT OUTER JOIN Fix Pack m2fp0 - Install and Catalog Services IT31481 1 SECURITY: DB2 IS VULNERABLE TO A PRIVILEGE ESCALATION ATTACK (CVE-2020-4230) IT29832 3 TWO OR MORE CONCURRENT "LOCK TABLE" STATEMENTS MAY RESULT IN DEADLOCK IN DPF ENVIRONMENT. Fix Pack m2fp0 - Parsing and SQL PL IT30157 1 SECURITY: DB2 EXPOSES SENSITIVE INFORMATION WHEN USING ADMIN_CMD WITH LOAD OR UPD Fix Pack m2fp0 - Platform Specific IT30432 1 SECURITY: DB2 IS VULNERABLE TO PRIVILEGE ESCALATION (CVE-2019-4587) Fix Pack m2fp0 - Query Compiler QGM IT31140 1 CDE HSJN NOT PICKED UP FOR NON EQUAL PREDICATES(RANGE AND OR PREDICATES) IT30742 2 QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP" IT31207 2 INCORRECT RESULT WHEN USING TWICE JOIN WITH THE SAME TABLE WITH GROUP BY IT31462 2 SECURITY: DB2 IS VULNERABLE TO DENIAL OF SERVICE ATTACK (CVE-2020-4161) IT30467 2 DB2 MAY PRODUCE INCORRECT RESULTS WHEN EXECUTING QUERIES CONTAINING JOINS WITH DIFFERING FLOATING-POINT PRECISIONS IT29982 2 DB2 MAY RETURN INCORRECT RESULTS WHEN EXECUTING IUD STATEMENTS CONTAINING A SUBQUERY WITH CORRELATION AND AGGREGATION IT30740 2 COMMENT ON UNICODE TABLE IN A NON-UNICODE DATABASE RESULTS IN UNREADABLE COMMENT Fix Pack m2fp0 - pureScale Services IT30143 1 SECURITY: DB2 AFFECTED BY BUFFER OVERFLOW VULNERABILITIES (CVE-2019-4584) DB2 Version 11.5 Fix Pack m3fp0 Known Issue Sev. Abstract Fix Pack m3fp0 - Buffer Pool Services IT30789 2 ROLLFORWARD MAY FAIL WITH SQL1271W AND SQLB_TBSPACE_TOO_SMALL WHEN REPLAYING AN ALTER TABLESPACE OPERATION IT30784 2 DEADLATCH BETWEEN AN ONLINE BACKUP, PREFETCHERS AND AN AGENT DOING A WRITE TO THE SAME TABLE SPACE IT30781 2 FALSE POSITIVE AGAINST BACKUP WITH REGISTRY DB2_BCKP_PAGE_VERIFICATION IT30798 2 TABLE SPACE RESTORE UNABLE TO USE ALL CONTAINER PATHS AND FAILS WITH DISK FULL IT30811 3 DB2PD -TABLESPACE DOES NOT INDICATE LOCAL OFFLINE STATE IT30797 3 EXTENT MOVEMENT RETURNS SQL1523N REASON CODE "15" WHEN EXTENT MOVEMENT NOT RUNNING IT30796 3 RESTORE OF SMS AUTOMATIC STORAGE TABLE SPACE IN DB2 DEVELOPER-C EDITION FAILS WITH SQL1139N Fix Pack m3fp0 - CDE Query IT30231 1 ENGINE MIGHT TRAP IN IBM_CDE::TYPES::BITSTRING::ANDWITHEXPANDEDCPU Fix Pack m3fp0 - Client Interfaces IT30803 3 INCORRECT LENGTH FOR SQL_LOCAL_LEN AND SQL_CODESET_LEN ON AIX Fix Pack m3fp0 - Data Management Services IT29231 2 UNSUSTAINABLE TRAP CAN OCCUR AFTER A SUSTAINED TRAP IF THERETEMP TABLES ARE USED BY TRANSACTIONS Fix Pack m3fp0 - Data Management Utilities IT30793 1 RESTORING A LOADCOPY WHEN THERE IS A MODIFICATION STATE INDEX ON A COLUMN ORGANIZED TABLE MAY CORRUPT THE INDEX. IT30807 2 ROLL FORWARD OR CRASH RECOVERY MAY CRASH WHEN WORKING ON INDEX PAGE. Fix Pack m3fp0 - Data Recovery Services IT30786 2 ABNORMAL SHUTDOWN OF DATABASE WHEN LOAD ENCOUNTERS SQLO_NOTAVAIL ERROR IN SQLPUPDATEGLOBALTIMEINGLFH Fix Pack m3fp0 - Federation IT25058 2 FEDERATION QUERY MAY GET SQL0302N DUE TO STRING TRUNCATION WHEN A HOST VARIABLE IS USED FOR A REMOTE COLUMN IN DIFFERENT CODEPAG IT30799 3 RELAX DB2DIAG.LOG MESSAGE IN SQLSFETCHNEXTTEMPRECORD PROBE 504 Fix Pack m3fp0 - Install and Catalog Services IT30778 2 DB2 CRASH ON FUNCTION SQLRL_GET_FULL_NAME() Fix Pack m3fp0 - Monitoring IT29595 2 ADMIN_MOVE_TABLE CONVERTS AUTO CGS STATISTICS PROFILE INTO USER STATISTICS PROFILE IT30805 2 EM_LIST_LATCH IS GRABBED AND RELEASED FREQUENTLY EVEN THERE IS NO TRANSACTION EVENT MONITOR CREATED/ACTIVE IT30808 3 DB2 LOCK EVENT MONITOR REPORT: LOCK MODE HELD IS NONE IN PURESCALE Fix Pack m3fp0 - Platform Specific IT30792 1 DB2 MIGHT CRASH IN SQLOFMBLKEX->SQLO_MEM_POOL::MEMTREEPUT WITH "CORRUPT POOL FREE TREE NODE" ERROR MESSAGE IN DB2DIAG.LOG IT30794 2 CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK (WINDOWS PLATFORM ONLY) IT30801 3 STMM REPORTS SEVERE ERRORS ABOUT STMMSIMULATESORTMERGE IN DB2DIAG.LOG Fix Pack m3fp0 - Problem Determination IT30810 2 DB2DART DETECTS ERRORS AFTER UPGRADING Fix Pack m3fp0 - Process Model IT30790 2 DB2LOGGP CAN TRAP WITH SIGNAL

11 IN A FEDERATED ENVIRONMENT IT21822 4 THE DESCRIPTION OF MAXFILOP IN GET DATABASE CONFIGURATION OUTPUT IS WRONG Fix Pack m3fp0 - Query Compiler Optimizer IT29048 2 HSJN RESID PREDICATE ISSUE, LEADING TO -901 FOR THE CDE QUERY AT PARSERWRAPPER/JOINREWRITER Fix Pack m3fp0 - Query Compiler QGM IT30000 2 DB2 MAY ABEND WHILE COMPILING A QUERY CONTAINING EXTERNAL ACTIONS AND CORRELATION IT28424 3 UNABLE TO CREATE STORED PROCEDURES WITH SAME NAME BUT DIFFERENT PARAMETERS WHEN SQL_COMPAT ='NPS' Fix Pack m3fp0 - Relational Data Services IT30800 2 SECOND EXECUTION OF A CACHED CDE QUERY IN DPF ENVIRONMENT MIGHT LEAD TO SEGV (FODC TRAP) OR FODC MEMORY FOR ILLEGAL REQUEST SIZE Fix Pack m3fp0 - pureScale Services IT30787 2 DB2CLUSTER SEGFAULT CAUSED BY WRONG ARGUMENTS TO PD_HEXDUMP WHEN RUNNING INSTALLFIXPACK ON PURESCALE IT30788 2 HADR CANNOT BE STARTED DUE TO INSUFFICIENT HADR DATABASE RESOURCE VALIDATION IT30783 3 A SEGMENTATION FAULT (CORE DUMPED) CAN OCCUR WHEN RUNNING DB2HAICU WITH AN XML INPUT FILE. IT30809 3 EXTRANEOUS CODE IN THE MOUNTV111_STOP.KSH SCRIPT IT30806 4 DB2CLUSTER -CM -LIST -TIEBREAKER RETURNS INCORRECT OUTPUT WHEN THE DOMAIN IS STOPPED OR IN MAINTENANCE

Đọc tiếp

mẹo hay

Reply 7 0 Chia sẻ