Troubleshooting
Problem
Db2 12.1 Known Issue Fix list contains list of Known Issues shipped for each Mod Pack, Fix Pack in Db2 Version 12.1 for Linux, UNIX and Windows products.
Resolving The Problem
Tab navigation
************************************************************
Product Name : Db2 Version 12.1
Updated : Nov 05, 2025
************************************************************
Select a Fix Pack: m3fp0 | m2fp0 | m1fp0 | GA
| Db2 12.1.3 Fix Pack m3fp0 | |||||
|---|---|---|---|---|---|
| Known Issue | Symptom | Abstract | Domains | ||
| DT439648 | Performance (PR) | On a DPF environment, slow down may occur due to latch contention during FODCFCMResource data collection. | Process Model | ||
| DT442962 | Coded Wait (WS) | In rare scenarios, Db2 may hang when ingesting a lot of data with a native cloud object storage table space | Cloud Object Storage | ||
| DT443084 | Performance (PR) | Performance optimization of certain Db2 commands in a large DPF environment | Process Model | ||
| DT426643 | Performance (PR) | HADR primary may go into disconnected_peer state right after deactivating the database on standby | Availability | ||
| DT447685 | DECODE gives wrong result with decfloat data type using DB2COMPOPT=NODECODETO_CASE | Runtime | |||
| DT445966 | Coded Halt (HL) | SELECT on an external table fails with SQL20570N and "Error while processing end of record was expected at byte * in data file." when the input file is large. | SQL Compatibility | ||
| DT433254 | Incorrect Output (IN) | Pacemaker HADR: takeover might not be initiated due to no order constraint | Availability | ||
| DT438178 | Abnormal End Of The Program (AB) | Rollforward may fail with SQLUPRGERR when processing a Load Start log record | Data Management | ||
| DT442230 | Abnormal End Of The Program (AB) | Using TRIM function in a query may lead to -302 error | Query Compiler | ||
| DT448243 | Unpredictable (UN) | CURRENT LOCK TIMEOUT special register might be ignored on Database Partitioning Feature (DPF) environment | Runtime | ||
| DT147953 | Loop (LP) | IT41234: INGEST MAY HANG WHEN THE AMOUNT OF SHARED MEMORY IS INSUFFICIENT FOR FORMATTERS AND FLUSHERS | Data Management | ||
| DT438171 | Possible memory corruption running Java functions with multiple schemas | Runtime | |||
| DT438749 | Performance (PR) | Memory leak in db2fmp process when WLMSETCLIENT_INFO procedure is called in a connect procedure | Runtime | ||
| DT447566 | Incorrect Output (IN) | Avoid intermittent -802 in ROUND for DOUBLE and REAL on x Linux | Runtime | ||
| DT444782 | Additional Information (AI) | db2cat may return -901 | Query Compiler | ||
| DT440057 | Abnormal End Of The Program (AB) | Failure in streaming QRep replay of IUD operation into columnar table | Columnar Storage | ||
| DT448221 | Abnormal End Of The Program (AB) | Exporting a large spatial data to a shape file results in error GSE0101N | Client & Connectivity | ||
| DT438045 | Integrity Problems (IG) | db2support cannot be unzipped due to bad zipfile offset | Problem Determination Tooling | ||
| DT439742 | Abnormal End Of The Program (AB) | FODC_PANIC can occur when resource manager is enabled | Operating System Services | ||
| DT259644 | Coded Message (MS) | HADR Standby Database Can Flood db2diag.log with SQL2171N Messages When Replaying a DROP TABLE Statement | Availability | ||
| DT448288 | Incorrect Output (IN) | LOCAL/GLOBAL transaction ID prematurely incremented in audit during commit/rollback | Security | ||
| DT439260 | Coded Message (MS) | SQLCODE -901 when joining a MEMORY_TABLE or an external table with a column-organized table with a "null = null" join predicate | Query Compiler | ||
| DT443394 | Incorrect Output (IN) | QueryTimeout not working properly on AIX | Client & Connectivity | ||
| DT436984 | Incorrect Output (IN) | db2cli.ini created and updated in deprecated path | Client & Connectivity | ||
| DT443706 | Incorrect Output (IN) | Monitoring Functions log 'FCM Interrupt' as Severe in db2diag.log | Process Model | ||
| DT445819 | Abnormal End Of The Program (AB) | Buffer Used for Amazon RDS Token Not Cleared, Causing Unexpected Characters | Operating System Services | ||
| DT446857 | Incorrect Output (IN) | Delete operation with transient external table failed with SQLCODE -644 | SQL Compatibility | ||
| DT448153 | hostCleanupPCMK.ksh: Failed to cleanup all the Db2 pureScale resources with exit code 127 | Availability | |||
| DT439678 | Unpredictable (UN) | Memory leak while using db2look for generating DDL for variables and views | Catalog Services | ||
| DT446123 | Abnormal End Of The Program (AB) | High number of latch waits from SYSUSERAUTH cache causing slowdown | Catalog Services | ||
| DT448298 | Incorrect Output (IN) | Db2 db2flsn utility returns that the log file is unused or blank | Availability | ||
| DT440664 | Unpredictable (UN) | remove printf() from signal handler of ca-server | pureScale | ||
| DT437998 | Abnormal End Of The Program (AB) | DPF HA - Create domain fails with DBT8214E, reason code 3 when the number of partitions is not evenly divisible by the number of cluster hosts. | Availability | ||
| DT444354 | Abnormal End Of The Program (AB) | Replication Center fails to start in Db2 v12 | Data Management | ||
| DT393258 | Incorrect Output (IN) | Unsupported code point values used when JWT sent to Db2 z/OS server by LUW client | Security | ||
| DT436618 | Incorrect Output (IN) | db2support command may hang during db2prereqcheck | Problem Determination Tooling | ||
| DT447957 | Incorrect Output (IN) | Function mapping issue cause error code "907" to be returned from Oracle database to Db2 | Federation | ||
| DT446569 | Incorrect Output (IN) | db2updv121 fails due to "Error updating analytic modules" on module object SYSIBMADM.IDAXMESSPRAISEMESSAGE | Query Compiler | ||
| DT444760 | Coded Halt (HL) | Db2 may hang with waiting on Latch SQLOLTSQLPTENTRY_tranCommitLatch having no holder | Availability | ||
| DT440426 | Integrity Problems (IG) | Incompatibility issues when working with JSON data in Db2 12.1 | Runtime | ||
| DT446369 | Loop (LP) | Connect agents hang if insufficient time passes when audit COS file was last open | Security | ||
| DT439872 | Loop (LP) | Large nested DECODE expressions may result in large statement heap usage and possible out-of-memory condition | Query Compiler | ||
| DT447321 | Abnormal End Of The Program (AB) | RENAME TABLE statement might return sqlcode -901 and FODC_AppErr directory generated | Query Compiler | ||
| DT442116 | Abnormal End Of The Program (AB) | RUNSTATS Command Failure During Upgrade to Db2 12.1.x When a Statistics Profile with the UTILIMPACTPRIORITY Option Exists on a SYSIBM Table | Query Compiler | ||
| DT437270 | Incorrect Output (IN) | SQL0901N for CDE JOIN queries using LIKE as a join-condition | Runtime | ||
| DT439158 | Abnormal End Of The Program (AB) | SQL might fail with SQL0901N "unexpected error at CompactBlockStoreBase.hpp" | Runtime | ||
| DT437847 | Abnormal End Of The Program (AB) | Real-time statistics collection for a temporary table during SQL statement compilation can result in a severe error. | Query Compiler | ||
| DT424216 | Loop (LP) | Improving Performance of db2look with the "-L" Flag: SQL1635N Error Returned | Catalog Services | ||
| DT437138 | Creating an instance resource in db2cm with an FQDN hostname on HADR with Pacemaker may result in a crash or hang | Availability | |||
| DT443098 | Performance (PR) | Performance may be impacted when multiple EDUs dump diagnostics due to communication timeouts. | pureScale | ||
| DT442339 | Coded Halt (HL) | Runstats Memory corruption issue due to corrupt catalog table packed descriptor after upgrade to Db2 v12.1 | Catalog Services | ||
| DT450126 | Incorrect Output (IN) | db2flsn utility to print the logfile from LRI returns that the log file is unused or blank | Availability | ||
| DT437293 | Abnormal End Of The Program (AB) | Pacemaker fatal error while controld attempts to communicate with a non-existing/respawning attrd | Availability | ||
| DT447379 | Incorrect Output (IN) | Problem determination item for unexplained -802 in ROUND for DOUBLE and REAL | Runtime | ||
| DT443667 | Unpredictable (UN) | Procedure with SET CURRENT PACKAGE PATH and Result Set may lead to SQL0501N when closing the cursor of the Result Set | Runtime | ||
| DT447204 | Integrity Problems (IG) | DDL and DML operations are not blocked for the duration of LOGICAL_BACKUP | Availability | ||
| DT438681 | Columnar Group-By query fails with assertion in RegularLPHashTableImpl.hpp | Runtime | |||
| DT442500 | Incorrect Output (IN) | Incorrect result when a Scalar Subquery result is used in a local predicate on the parent operator | Query Compiler | ||
| DT440205 | Abnormal End Of The Program (AB) | INGEST job fails intermittently with DB21018E | Data Management | ||
| DT442874 | Additional Information (AI) | ERROR MESSAGE : ZRC=0x80100024=-2146435036=SQLP_NOTA "Transaction was not found" repeatedly dumps in DB2DIAG.LOG. | Availability | ||
| DT446388 | Performance (PR) | Db2 query may show poor performance when scalar subquery source is also target of data modification of the query | Query Compiler | ||
| DT442273 | Performance (PR) | SQLOLTSQLPLHSH_hshlatch contention with partition table on little endian machine | Availability | ||
| DT439922 | Abnormal End Of The Program (AB) | Native Object Storage Table Space and OS level FIPS support | Cloud Object Storage | ||
| DT445755 | Incorrect Output (IN) | Db2 query may generate -901 when distribution key is in equal predicate | Query Compiler | ||
| DT437996 | Abnormal End Of The Program (AB) | Heavy contention on the SQLOLTSQLEKRCBstopLatch from the sqlkdcleanonclose function. | Process Model | ||
| DT444641 | Incorrect Output (IN) | "No such device or address" error messages can be logged in pacemaker.log on HADR/Pacemaker environment | Availability | ||
| DT444854 | Abnormal End Of The Program (AB) | Upgrading database to Db2 v12.1.0.0+ on PPCLE fails in hook function for new catalog table SYSEXTCATALOGS | Catalog Services | ||
| DT443419 | Coded Message (MS) | In Federated environment distributed XA transactions fail and send xa_end to remote data source | Federation | ||
| DT439573 | db2cfimp segmentation fault when importing DB2 11.5 configuration | Process Model | |||
| DT446657 | Performance (PR) | Performance degradation may occur during sort operation due to extra Flight Recorder log. | Runtime | ||
| DT426000 | Abnormal End Of The Program (AB) | db2start may cause a trap if ulimit is set too low | Operating System Services | ||
| DT438938 | Abnormal End Of The Program (AB) | Possible deadlatch between CF workers after a communication timeout between member and CF using RDMA network. This may cause a CF failover. | pureScale | ||
| DT448537 | Abnormal End Of The Program (AB) | db2support trap in a clustered environment | Process Model | ||
| DT440612 | Incorrect Output (IN) | LOGICAL_BACKUP stored procedure returns success when the schema is not accessible | Availability | ||
| Db2 12.1.2 Fix Pack m2fp0 | |||||
|---|---|---|---|---|---|
| Known Issue | Symptom | Abstract | Domains | ||
| DT179559 | Incorrect Output (IN) | db2licm does not update the products enforcement policy when using the -e option. | Deployment | ||
| DT223744 | Performance (PR) | NOT IN to antijoin conversion does not occur with expression. | Query Compiler | ||
| DT241639 | Q Capture program stops even TERM=N is specified when Db2 is down | IIDR | |||
| DT395300 | Coded Halt (HL) | Replay of extent movement may hang in a deadlatch | Data Management | ||
| DT395376 | Incorrect Output (IN) | Setting TRACEREFRESHINTERVAL attribute to non-zero value in db2cli.ini file leads to memory leak | Client & Connectivity | ||
| DT395714 | Incorrect Output (IN) | SQL0901N (Reason "unexpected error at Table.hpp:2463") when running a CDE Query | Query Compiler | ||
| DT397282 | Incorrect Output (IN) | db2dsdcfgfill fails to create dsn in db2dsdriver.cfg file when dcs catalog is present | Client & Connectivity | ||
| DT398357 | Incorrect Output (IN) | asnmon should send unencrypted emails if asnmon parms TLSKEYDB and TLSLABEL are not set by user | IIDR | ||
| DT398584 | Abnormal End Of The Program (AB) | Member can hang or crash in pureScale/AIX due to RDMA timeouts | Availability | ||
| DT409120 | Additional Information (AI) | Prevention of Index Page Merge from writing beyond the end of the page | Data Management | ||
| DT417525 | Unpredictable (UN) | Excessive lock timeouts caused by db2lused | Process Model | ||
| DT417572 | Integrity Problems (IG) | Memory corruption during DPF roll forward of LOAD COPY image | Availability | ||
| DT419444 | Coded Message (MS) | ALTER TABLE to change the column data type may fail if there are constraints on the table | Query Compiler | ||
| DT419625 | Negative value in IBMQREP_APPLYMON | IIDR | |||
| DT421582 | Performance (PR) | Avoid coordinator bottleneck when processing MERGE statement in DPF environment. | Query Compiler | ||
| DT422037 | Incorrect Output (IN) | DIVISION BY ZERO for DECFLOAT does not return SQLSTATE 0168F but 00000 in some cases | Runtime | ||
| DT422629 | Q Apply may get SQL0428 for a TRUNCATE TABLE when COMMIT_COUNT is used | IIDR | |||
| DT423307 | Incorrect Output (IN) | Table access based on rid_bit() returns no rows if rid()/TSN value is high on Column Organized Tables | Runtime | ||
| DT423473 | Incorrect Output (IN) | Failure to connect when using partially NULL connection string | Client & Connectivity | ||
| DT424104 | Incorrect Output (IN) | STORAGE ACCESS ALIAS commands might fail with SQL1741N or write erroneous error messages to the diagnostic log | Security | ||
| DT424728 | Unpredictable (UN) | db2cm fails to create Overlay IP resource due to improper handling of AWS instance metadata retrieval | Availability | ||
| DT425360 | Coded Halt (HL) | db2exfmt fails with -901 "Inc bind section statement changed!" after migration from 12.1.0 to 12.1.1 | Query Compiler | ||
| DT426007 | Loop (LP) | Interrupt/Force of ADMINMOVETABLE() procedure can leave EDUs hanging on AIX Operating System. | Runtime | ||
| DT433388 | Wrong SQLCODE displays in SQL Apply log. | IIDR | |||
| DT434803 | Abnormal End Of The Program (AB) | FODCAppErr SQLPLERR "Fatal Logic Error" TableAlter::writeLogToUndoRenameColumn, probe:1502 | Columnar Storage | ||
| DT434948 | Abnormal End Of The Program (AB) | A transaction issuing a TRUNCATE IMMEDIATE followed by ROLLBACK causes Q Capture to SIGSEGV | IIDR | ||
| DT435041 | Abnormal End Of The Program (AB) | Restoring from S3 fails with SQL2542N when the backup file is in the root directory | Operating System Services | ||
| DT435528 | Abnormal End Of The Program (AB) | FMP trap with SIGPIPE aborts other parallel ET statements in logical_backup() | SQL Compatibility | ||
| DT147988 | Incorrect Output (IN) | IT27040: AUTOMATIC TABLE MAINTENANCE FAILS WHEN THE FILTERCLAUSE OR FILTERCONDITION SPECIFIED IS TOO LONG | Data Management | ||
| DT198304 | Incorrect Output (IN) | Client Import of boolean values to Db2 server results in all values being true (1) regardless of input values in the .DEL file. | Data Management | ||
| DT395180 | Abnormal End Of The Program (AB) | QApply fails with ASN0569E and SIGSEGV during initial load of a subscription from z/OS to AIX | IIDR | ||
| DT396640 | Incorrect Output (IN) | A system buffer pool may be assigned to a table space added by restore transport | Availability | ||
| DT397374 | Incorrect Output (IN) | SQL0901N error with assertion failure "bad year" (or bad month, day, hour, minute, second, or time) when querying a DATE, TIME, or TIMESTAMP column in a columnar table | Columnar Storage | ||
| DT397896 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to unbounded recursions due to a vulnerability in protobuf-java (CVE-2024-7254) | Federation | ||
| DT398108 | Incorrect Output (IN) | SQL0901N (Reason "unexpected error at Parser.cpp:947".) | Query Compiler | ||
| DT398156 | Incorrect Output (IN) | db2look -createdb needs to print out a warning message when the storage group for SYSCATSPACE is changed | Catalog Services | ||
| DT400694 | db2dart might fail to read a page with error code 0x87020036 | Data Management | |||
| DT407067 | Incorrect Output (IN) | Asnmail failed to send emails due to SMTP server response error | IIDR | ||
| DT416755 | Performance (PR) | SQLONOMEMPCKCACHEH OOM WHEN SMALL PACKAGE CACHE SIZE AND CONSTRAIN MEMORY SET | Process Model | ||
| DT417099 | Performance (PR) | Specific catalog cache entry becomes NOT LOADED and causes high x-lock continuously. | Catalog Services | ||
| DT417614 | Incorrect Output (IN) | A query to a format-fixed external table with a space to the right of the data in the DECIMAL column returns SQL20570N. | SQL Compatibility | ||
| DT417677 | Abnormal End Of The Program (AB) | Incremental backup may fail with SQL2048 rc5 | Availability | ||
| DT419493 | Incorrect Output (IN) | db2cluster -cfs -create -filesystem command fails after installFixPack online upgrade with "mmcrfs: The requested format version for the file system (5.1.8.1 - default) exceeds the current committed function level for the cluster (minReleaseLevel 5.1.2)." | Availability | ||
| DT419943 | Performance (PR) | Slow log replay during database recovery due to excessive page writes to disk | Availability | ||
| DT422068 | Coded Message (MS) | Actual object size is less than computed size error | Data Management | ||
| DT424792 | CREATE QSUB asnclp command on LUW gets SQLCODE=-206, SQLSTATE=42703, SQLERRMC=LAKEHOUSE | IIDR | |||
| DT425502 | Q Apply gets sql206 replicating a transaction with multiple large statements on columnar tables | IIDR | |||
| DT434920 | Incorrect Output (IN) | ListObject requests returns empty result set in REST mode | Operating System Services | ||
| DT435737 | Incorrect Output (IN) | db2support may fail when calling ifconfig as it may not exist on all installations. | Process Model | ||
| DT436277 | Performance (PR) | Lost lock notification during lock connection resync on pureScale. | pureScale | ||
| DT159501 | Incorrect Output (IN) | IT31532: DB2 MAY RETURN INCORRECT RESULT WHEN EXECUTING QUERY WITH PREDICATE WITH CONSTANT AND LEFT OUTER JOIN AND UNION ALL | Query Compiler | ||
| DT239580 | Incorrect Output (IN) | SQL Apply failed SIGIOT during startup | IIDR | ||
| DT259067 | Abnormal End Of The Program (AB) | Issuing a query using REGEXP_EXTRACT/RTRIM in a CTE may lead to -1585 error | Query Compiler | ||
| DT393460 | Incorrect Output (IN) | Replication target table becomes incorrect after TRUNCATE IMMEDIATE is executed on a source database in a DPF environment | Data Management | ||
| DT393789 | Abnormal End Of The Program (AB) | FODC trap when interrupt the query manually | Federation | ||
| DT395723 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-45663) | Query Compiler | ||
| DT397567 | Incorrect Output (IN) | Rare GSKit error 100 from multithreaded Db2 clients when using SSL and an in-memory keystore | Security | ||
| DT399725 | Performance (PR) | When using an XML resource policy, the database memory set is not allocated on the proper nodes. | Operating System Services | ||
| DT400216 | Performance (PR) | Table access based on rid_bit() might be slower than rid() on Column Organized Tables | Runtime | ||
| DT400964 | Incorrect Output (IN) | Incorrect output format of db2pd -appl | Security | ||
| DT407026 | Abnormal End Of The Program (AB) | Improve ossHexDumpLine() resiliency | Operating System Services | ||
| DT409136 | debug code for Q Apply when MRI is on | IIDR | |||
| DT416519 | Performance (PR) | ADMINMOVETABLE dictionary creation for large columnar tables might be slow | Data Management | ||
| DT416787 | Additional Information (AI) | Prevention of underflowing of pendNotExistCnt | Data Management | ||
| DT416907 | Abnormal End Of The Program (AB) | ADMINMOVETABLE in pureScale with FORCE_ALL option might take a long time to complete SWAP phase or even fail when running concurrently with other applications that are in the process of rebinding previously invalidated packages | Data Management | ||
| DT416945 | Performance (PR) | ADMINMOVETABLE REPLAY for columnar tables might be slow | Data Management | ||
| DT417613 | Coded Message (MS) | SQL0901N may be returned instead of the actual sqlcode when a statement with maxerrors is executed to an external table. | SQL Compatibility | ||
| DT417652 | Performance (PR) | Possible performance issue for queries with correlated NOT EXISTS predicate and nested levels of correlation | Query Compiler | ||
| DT418744 | Abnormal End Of The Program (AB) | Preventative approach to a rare trap in sort monitoring code with intra_parallel enabled. | Runtime | ||
| DT419372 | Abnormal End Of The Program (AB) | SYSPROC.ADMINDROPSCHEMA() fails with SQL0443N and reports SQL1131N from CALL SYSPROC.ADMINGETDEPTREE() when dropping large schemas | Data Management | ||
| DT419596 | Incorrect Output (IN) | Incorrect result when query has UNION ALL that reference same sources in multiple branches. | Query Compiler | ||
| DT421381 | Unpredictable (UN) | Change of ADM6073W message to Info level during db2ckupgrade | Data Management | ||
| DT421697 | System/3 Message (MI) | Change db2diag.log message from "LEVEL: Severe" to "LEVEL: Warning" when a non-existing application is forced off (SQL1230W) | Process Model | ||
| DT423953 | Additional Information (AI) | Enhancement to dump diagnostics for corrupted collation ID | Query Compiler | ||
| DT424150 | Integrity Problems (IG) | IBM® Db2® is vulnerable to a denial of service as the server may crash under certain conditions (CVE-2025-2518) | Federation | ||
| DT425677 | Performance (PR) | Queries on several system catalogue views are considerably slower starting with Db2 v12.1 | Query Compiler | ||
| DT425793 | Performance (PR) | SQLOLTSQLPXIDHASHBUCKET_xregHshLatch Latch contention in very high concurrent XA workload | Availability | ||
| DT426586 | Abnormal End Of The Program (AB) | Segmentation fault running XML query | Data Management | ||
| DT433442 | Abnormal End Of The Program (AB) | disable FODCElasticSort generation for instanceusage=dashdb. This is already disabled for everyone but dashdb instance. | Runtime | ||
| DT433474 | Coded Message (MS) | Unexpected SQL0913N error with reason code 80 when running with DB2LOCKTORB set to STATEMENT | Catalog Services | ||
| DT433822 | Coded Message (MS) | Query with "NULL equals NULL" join predicate between two column-organized tables might result in SQL0901N error | Query Compiler | ||
| DT436891 | Q Apply reported sql644 when applying changes to Db2 columnar table on DPF | IIDR | |||
| DT436914 | Performance (PR) | During a CF down, a connection attempt to a down CF can lead to slower CF failover. | pureScale | ||
| DT437545 | Abnormal End Of The Program (AB) | Db2 instance might trap and database put into backup pending state after dropping a member in pureScale | Availability | ||
| DT438139 | Abnormal End Of The Program (AB) | db2scp breaks on AIX due to default behavioral change of scp in openssh | Availability | ||
| DT276305 | Performance (PR) | When ALSM is active, HADR standby still reaches disk full because of huge gap between ALSM extraction scan and HADR log replay | Availability | ||
| DT395155 | Incorrect Output (IN) | Client Communication Protocol Monitor Element in Db2 v11.5.9.0 Fails to Correctly Identify TCPIP and SSL Connections in Event Monitors | Process Model | ||
| DT395617 | Incorrect Output (IN) | DT395617 - Locale setting is not effective for decimal separator on decfloat columns under France locale with cli driver | Client & Connectivity | ||
| DT398854 | Coded Wait (WS) | Enhancement to release row lock on SYSIBM.SYSTABLES | Data Management | ||
| DT400959 | Abnormal End Of The Program (AB) | Rare memory corruption in large columnar join scenario | Runtime | ||
| DT400993 | asntrc flow output contains incorrect function names | IIDR | |||
| DT418806 | Unpredictable (UN) | HADR NAT support not working on Windows error SQL1768N RC=4 | Availability | ||
| DT419242 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to a denial of service under certain conditions.(CVE-2025-1000) | Client & Connectivity | ||
| DT419430 | Incorrect Output (IN) | ADMINMOVETABLE might fail CLEANUP with SQL0205N | Data Management | ||
| DT420520 | Incorrect Output (IN) | SQL1822N Unexpected error code "22001" received from data source | Federation | ||
| DT420536 | Incorrect Output (IN) | On Windows, Db2 Client and Server Instance Upgrade from v11.5 to 12.1 throws an error | Deployment | ||
| DT420578 | PTF (PF) | Index keys misordered for Thai codepage 874 | Data Management | ||
| DT423222 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to a denial of service due to insufficient release of allocated memory after usage.(CVE-2025-1992) | Federation | ||
| DT424706 | Incorrect Output (IN) | ADMINMOVETABLE might fail during SAP Upgrade | Data Management | ||
| DT425868 | In LUW tables with DECFLOAT are not eligible for MultiRowInsert | IIDR | |||
| DT426550 | Incorrect Output (IN) | Wrong values are inserted when anchor rows are re-declared from within a stored procedure | Runtime | ||
| DT435796 | Incorrect Output (IN) | Rebuild synopsis fails with SQL0428N when run using admin_cmd procedure | Columnar Storage | ||
| DT436605 | Performance (PR) | Allow repartitioned joins under some additional circumstances when enabled via registry setting | Query Compiler | ||
| DT436656 | Abnormal End Of The Program (AB) | SQL0802N is possible when querying against MONCURRENTSQL view or the MONCURRENTUOW view in the presence of long running activity or transaction | Process Model | ||
| DT437032 | asnqapp reports SQL100 exception for columnar table when numapplyagents=1 with usestreamtrans=N | IIDR | |||
| DT437045 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to denial of service with a specially crafted query. (CVE-2025-33143) | Query Compiler | ||
| DT437205 | Incorrect Output (IN) | In a rare plan , in DPF only, and with two or more ZZJOINs which are not nested, it is possible, with some sections to get a wrong result. | Runtime | ||
| DT437601 | Upgrade to Db2 12.1 may fail with a trap file | Catalog Services | |||
| DT241215 | Incorrect Output (IN) | Unexpected SQL0998N Reason Code 36 when running distributed transactions in DPF environment | Availability | ||
| DT387190 | Incorrect Output (IN) | *SQLHA.events.bin file is generated periodically after Restart Light event | Availability | ||
| DT390024 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-41762) | Runtime | ||
| DT390629 | Abnormal End Of The Program (AB) | FODCForceDBShutdown due to ADMINGETINDEXINFO sending request to non-catalog partition | Data Management | ||
| DT395068 | Incorrect Output (IN) | With ALSM, db2diag.log file is flooded with informational message related to sqlpLogExtractionScanCB::loggxFlushBufferPool | Availability | ||
| DT395188 | Abnormal End Of The Program (AB) | Db2 Security Plugin loading failed when using ASAN (Address SANitizer) | Operating System Services | ||
| DT395722 | Incorrect Output (IN) | db2cm returns an error "The default profile does not exist" with the -remote_cmd /var/db2/db2ssh/db2locssh parameter specified when trying to configure a Overlay IP resource on AWS | Availability | ||
| DT396594 | Incorrect Output (IN) | TABFILEID is inconsistent between mongettable and mongetlocks | Process Model | ||
| DT397534 | Incorrect Output (IN) | db2pd -hadr is not reporting SSLPROTOCOL when HADRSSL_LABEL is used | Availability | ||
| DT406764 | Abnormal End Of The Program (AB) | db2cluster -cm -exit -maintenance fails on cluster with more than 8 quorum nodes. | Availability | ||
| DT416875 | Abnormal End Of The Program (AB) | Possible segmentation fault during database rollforward or crash recovery in SQLP_TENTRY::sqlpReserveLogSpaceForUndo() | Availability | ||
| DT418246 | Incorrect Output (IN) | ACTIVATE or CONNECT to a database on a newly added member in pureScale can fail or return SQL1497W / SQL1648N | Availability | ||
| DT422521 | Integrity Problems (IG) | Rows missing after successful INGEST INSERT RESTART NEW | Data Management | ||
| DT425372 | Abnormal End Of The Program (AB) | Fix filesystem error handling for GPFS and EXT4 | Operating System Services | ||
| DT425663 | Memory leak when running Federated queries with the 'PASSTHRU' option | Federation | |||
| DT425933 | PTF (PF) | In a rare and complex plan using columnar tables we could get odd errors, like -811 or -901 . | Runtime | ||
| DT426652 | Poor Q Apply performance for Non-Condensed CCD targets because of high number of KEY_DEPENDENCIES | IIDR | |||
| DT426790 | Incorrect Output (IN) | Post adding CLI parameters Patch2=15,25 and Querytimeoutinterval=0 through Windows ODBC Interface SQL30081N is thrown while establishing a connection. | Client & Connectivity | ||
| DT431959 | Performance (PR) | LOGICAL_BACKUP stored procedure does not generate compressed backup image on S3/COS when called with -compress option | Availability | ||
| DT434402 | Coded Message (MS) | Oracle NET8 Wrapper Federated Stored Procedure Support for TIMESTAMP WITH LOCAL TIME ZONE | Federation | ||
| DT434608 | Log files in the target ET log directory are not removed when streaming is off | IIDR | |||
| DT434668 | Incorrect Output (IN) | ADMINMOVETABLE reports zero COPYTOTALROWS for COPYUSEOTA | Data Management | ||
| DT434690 | Incorrect Output (IN) | Overlay IP Resource Created with db2cm Fails to Start on AWS When Network Interface Is Not 'eth0' | Availability | ||
| DT435387 | Loop (LP) | Db2 may hang indefinitely holding a latch | Runtime | ||
| DT188249 | Incorrect Output (IN) | Fix ALTER TABLE ALTER COLUMN DROP/SET DEFAULT in v1158 | IIDR | ||
| DT381283 | Abnormal End Of The Program (AB) | db2scp binary not updated after installFixPack | Deployment | ||
| DT389572 | Incorrect Output (IN) | db2prereqcheck tool is showing AIX requirement for both 11.5.9.0 and 11.5.8.0 as 7.2 TL3 SP3 instead of 7.2 TL5 | Deployment | ||
| DT392298 | Coded Halt (HL) | db2hmon waiting in Pending remote request | Data Management | ||
| DT393578 | Abnormal End Of The Program (AB) | Db2 operation requests to S3 fails on FIPS-enabled environments | Operating System Services | ||
| DT394926 | Abnormal End Of The Program (AB) | Modify db2pd -hadr so that it no longer obtains a latch | Availability | ||
| DT396517 | Unpredictable (UN) | After encountering severe error the database might hang during generating FODC dump. | Availability | ||
| DT396820 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-49350) | Runtime | ||
| DT397218 | Coded Wait (WS) | Potential FCM buffer leak on DPF systems when receiving SQL0803N | Process Model | ||
| DT397544 | Incorrect Output (IN) | Possible replicated dataloss on DPF when a streamed transaction contains a savepoint rollback because of a statement-level SQL error | IIDR | ||
| DT398417 | Incorrect Output (IN) | ADMINMOVETABLE might change schema of SYSIBM indexes | Data Management | ||
| DT398498 | Abnormal End Of The Program (AB) | Db2 crash due to memory allocation hit an address outside segment | Runtime | ||
| DT400143 | Abnormal End Of The Program (AB) | LOAD from an IXF file, with LOB data in multiple, separate files, may reject records with SQL3229W RC 1 | Data Management | ||
| DT400510 | Incorrect Output (IN) | db2prereqcheck does not complete on some locales | Deployment | ||
| DT406899 | Incorrect Output (IN) | Query against VARGRAPHIC may be incorrect on CDE table. | Runtime | ||
| DT416559 | Performance (PR) | Online backup stalls while temporary pages are flushed to disk | Availability | ||
| DT416963 | Incorrect Output (IN) | Incorrect "Library is not loaded" diaglog entry from cryptGetSSLApiAddress | Security | ||
| DT417102 | A database Rollforward command to a point in time or to end of backup in a DPF environment may fail with SQL4973N | Availability | |||
| DT417537 | Abnormal End Of The Program (AB) | Windows 32-bit DSDRIVER crashes during connect to z/OS data source when installed at non-default path | Deployment | ||
| DT417647 | Performance (PR) | Automated HADR failover does not work when searching for highest log chain in a VENDOR log archive takes too long | Availability | ||
| DT419926 | Abnormal End Of The Program (AB) | db2 get db cfg + show detail returned wrong value for DECFLT_ROUNDING | Client & Connectivity | ||
| DT420531 | Abnormal End Of The Program (AB) | On Windows Data Server Driver update from 12.1 is aborting with out updating the product | Deployment | ||
| DT422213 | Incorrect Output (IN) | TRANSFER OWNERSHIP on check constraints doesn't update SYSCAT.CHECKS OWNER column | Catalog Services | ||
| DT423458 | Unpredictable (UN) | The ALTER SERVER statement is failing when the host, port, and SSL parameters are provided together in a single statement | Federation | ||
| DT424762 | Incorrect Output (IN) | Replication target table returns incorrect results after TRUNCATE IMMEDIATE is executed on a source columnar table in a DPF environment | Data Management | ||
| DT425966 | Incorrect Output (IN) | Select from administrative view might fail with SQL1042C when AUDIT and VALIDATE are enabled for instance level auditing and KERBEROS or GSSPLUGIN authentication plugins are in use | Security | ||
| DT433451 | Q Capture can fail with openScan -601 when replicating columnar tables on a NON-DPF configuration | IIDR | |||
| DT436499 | Abnormal End Of The Program (AB) | Failing to mark indexes bad on nickname causes SQL0902C during upgrade of ICU collated database to version 12.1.1 | Runtime | ||
| DT124197 | Incorrect Output (IN) | db2instance -list shows CF in ERROR state transiently | pureScale | ||
| DT148615 | Performance (PR) | IT38785: SQL STATEMENTS WITH MANY LIKE PREDICATES COULD RUN SLOWER ON V10.5 FP7 AND LATER | Runtime | ||
| DT223226 | Abnormal End Of The Program (AB) | Hang and 901 are possible when complex insert from select into a Columnar table is done. | Runtime | ||
| DT386248 | Performance (PR) | NOT IN Subquery predicate with UNION does not convert to Antijoin. | Query Compiler | ||
| DT396293 | System/3 Message (MI) | Db2 Pacemaker Corosync QDevice - Delete Cluster Domain and Read, but crm cluster status still shows old name | Availability | ||
| DT396320 | Abnormal End Of The Program (AB) | Db2 may encounter a severe error when issuing a query with IN predicate and guideline | Query Compiler | ||
| DT396843 | Coded Halt (HL) | Application may hang when running the SELECT * FROM SYSIBMADM.DB2INSTANCEALERTS statement in a pureScale environment | Availability | ||
| DT397334 | Performance (PR) | LOGICAL_BACKUP stored procedure can be very slow when there are RCAC rules on SYSIBM.SYSTABLES | Availability | ||
| DT397421 | Incorrect Output (IN) | Q Apply re-applies some transactions on restart after coming down for a MQ Client connection error | IIDR | ||
| DT398397 | Abnormal End Of The Program (AB) | RESTORE OR CREATE DATABASE MAY FAIL WITH ERROR ECFINVALIDINVOCATION_SEQUENCE | Operating System Services | ||
| DT400406 | Incorrect Output (IN) | Some built-in string functions used in querying XML data can produce incorrect results. | Data Management | ||
| DT406482 | Incorrect Output (IN) | SQL0413N while casting Character datatype values more than 15 characters to Decimal from Column-organized tables | Runtime | ||
| DT416456 | Abnormal End Of The Program (AB) | SQL using upper or lower scalar function fails with SQL0001N for CCSID 420 | Runtime | ||
| DT416491 | Incorrect Output (IN) | ADMINMOVETABLE SWAP might take long due to active background processes | Data Management | ||
| DT416761 | Loop (LP) | db2diag.log flooded with messages from sqlplDrainOldReadAndWriteAccess and sqlrrrpcrouter | Availability | ||
| DT417413 | Integrity Problems (IG) | IBM® Db2® is affected by a vulnerability in the netty-common library.(CVE-2024-47535) | Federation | ||
| DT417455 | Incorrect Output (IN) | Incorrect CACHINGTIER values not indicating whether table space is NativeCOS or not | Cloud Object Storage | ||
| DT417977 | Reverting - db2prereqcheck tool is showing AIX requirement for both 11.5.9.0 and 11.5.8.0 as 7.2 TL3 SP3 instead of 7.2 TL5 | Deployment | |||
| DT418452 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to denial of service under certain conditions (CVE-2025-1493). | Data Management | ||
| DT420324 | Incorrect Output (IN) | Access to a remote Db2 iSeries table by querying federated three-part name from non-catalog partition in a DPF server failed with SQL0204N | Federation | ||
| DT421871 | Incorrect Output (IN) | Client special registers are not replayed when using WLM if CONDBAT limit is reached on Z/OS. | Client & Connectivity | ||
| DT422722 | Incorrect Output (IN) | When attempting to bind a file or list of files using a different ID than the default NULLID, the files may be bound using the default ID NULLID instead | Client & Connectivity | ||
| DT422733 | Incorrect Output (IN) | DB2PD MAY FAIL WITH "FAILURE: MAX RESIZE THRESHOLD EXCEEDED | Problem Determination Tooling | ||
| DT423223 | Performance (PR) | Improve interruptibility of queries with very large HSJN inner leg in rowstore. | Runtime | ||
| DT424272 | Incorrect Output (IN) | Python3 version check fails on sles15sp6 for pureScale | Deployment | ||
| DT425730 | Coded Halt (HL) | Concurrent db2pd -memblocks on windows may bring Db2 down. | Operating System Services | ||
| DT431950 | Additional Information (AI) | pstack output empty in FODC_Member output when there are multiple active databases | Problem Determination Tooling | ||
| DT433927 | Q Apply "LOAD from CURSOR (REMOTE FETCH)" fails with ASN7530E "RC: 0, SQLCODE: -1001" | IIDR | |||
| DT434446 | Abnormal End Of The Program (AB) | Trap occurs in sqlrwGetPDDiagHist when calling PDGETDIAG_HIST. | Process Model | ||
| DT434928 | Abnormal End Of The Program (AB) | Crash recovery might fail when searching for a log despite the log exists | Availability | ||
| DT436492 | Incorrect Output (IN) | Capture cannot replicate TRUNCATE IMMEDIATE in a rolled back transaction after Capture restart if nothing has been replicated yet | IIDR | ||
| DT436493 | Incorrect Output (IN) | A truncate Immediate in a ROLLED BACK transaction failed to replicate in DPF for a table defined in a nodegroup that did not include the coordinator node | IIDR | ||
| DT148685 | Incorrect Output (IN) | IT41834: QUERYING A MASKED TABLE COLUMN MAY RETURN -901 "COULD NOT FIND HXP TO MATCH TUPLE" | Query Compiler | ||
| DT389552 | DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES REFERENCING VERY LARGE CASE EXPRESSIONS IN PREDICATES | Query Compiler | |||
| DT398851 | Abnormal End Of The Program (AB) | ADMINMOVETABLE in pureScale with FORCE_ALL option might take a long time to complete SWAP phase or even fail when running concurrent applications that access the same table using static SQL | Data Management | ||
| DT399999 | Incorrect Output (IN) | Unnecessary port binding retry although bind might have returned success return code | Process Model | ||
| DT400073 | Incorrect Output (IN) | Altering a table adding check or foreign key constraints do not block uncommitted incompatible transactions | Catalog Services | ||
| DT407071 | Loop (LP) | ROLLBACK HANGS WHEN REQUIRED DATA IS ON A BAD/CORRUPTED LOG PAGE | Availability | ||
| DT409145 | Incorrect Output (IN) | Incorrect result when query has subquery predicate with correlation. | Query Compiler | ||
| DT416594 | Incorrect Output (IN) | Corrupted value for IBMQREPFILERECVMON may cause incorrect usage billing for Db2WoC clients. | IIDR | ||
| DT418322 | Extraction hits SQLPNONSEVEREPRGERR during recovery | Availability | |||
| DT418459 | Incorrect Output (IN) | 901 or incorrect result when the registry variable REDSCANELIM_UCP is enabled | Query Compiler | ||
| DT419066 | Abnormal End Of The Program (AB) | Table space rollforward to a point in time in DPF fails with SQL1034C | Availability | ||
| DT419142 | Incorrect Output (IN) | A bad file might not contain whole field (zone) data in case an external table found bad data in fixed format. | SQL Compatibility | ||
| DT421466 | Loop (LP) | Fresh Installation of Db2 Server through GUI from a non-administrator account fails on Windows | Deployment | ||
| DT421709 | Abnormal End Of The Program (AB) | In Linux platform, stored procedure call failed with SQL0902 error when stored procedure used scrollable cursor to fetch data | Client & Connectivity | ||
| DT422315 | System/3 Message (MI) | A warning notifying a potential SQLOSSEMEXCEEDEDMAX when ipcmniextend is not enabled is incorrectly logged to db2diag.log at the Severe level. | Operating System Services | ||
| DT422365 | Incorrect Output (IN) | Incorrect Result when Db2 query has Outer Join and predicate with Boolean value TRUE | Query Compiler | ||
| DT423097 | Abnormal End Of The Program (AB) | External Table FODC_FmpTrap occurs when reading a bad data record having large number of characters against NVARCHAR column | SQL Compatibility | ||
| DT424393 | Coded Message (MS) | Insert, update or delete operation could get error allocating an index page. | Data Management | ||
| DT424900 | Incorrect Output (IN) | db2support command suddenly stops during execution | Problem Determination Tooling | ||
| DT425584 | Performance (PR) | REVERT CHANGES TO ALTER BUFFERPOOL MEMORY AFFINITY BEHAVIOUR | Operating System Services | ||
| DT425654 | Enable referential integrity(RI) dependency through control tables | IIDR | |||
| DT425705 | Performance (PR) | Optimize Query Performance for SAP HANA Data Source | Federation | ||
| DT426704 | Column CCDKEYUPDASDELINS and CCDALLUPDASDELINS are missing in LUW(1140) migration script | IIDR | |||
| DT433168 | Integrity Problems (IG) | Adding license using db2licm -a command may fail with LIC1407N intermittently | Deployment | ||
| DT434830 | Abnormal End Of The Program (AB) | Query of columnar table after ALTER TABLE DROP COLUMN or ADMIN MOVE TABLE fails with -901 | Columnar Storage | ||
| DT435517 | Capture comes down with 6005 when a transaction is aborted in a Non-DPF system with usestreamtrans=y | IIDR | |||
| DT435852 | Abnormal End Of The Program (AB) | db2fmp process might trap when dumping thread information | Runtime | ||
| DT436326 | Incorrect Output (IN) | db2exmig and SYSPROC.SYSINSTALLOBJECTS with action 'M' fail granting privilege when the schema has special characters | Query Compiler | ||
| DT436692 | Integrity Problems (IG) | Security: IBM® Db2® is affected by a vulnerability in Apache Parquet (CVE:2025-30065) | Federation | ||
| DT437317 | Abnormal End Of The Program (AB) | HADR standby database might crash with SIGSEGV on function sqlpAddEntryToTransTable with Reads on Standby enabled | Availability | ||
| DT437506 | Additional Information (AI) | Improve diagnostic information for investigation of failing AWS S3 requests | Operating System Services | ||
| DT394980 | Incorrect Output (IN) | db2exmig and SYSPROC.SYSINSTALLOBJECTS fail for explain table migration when the schema has blanks, lower case letters or special characters | Query Compiler | ||
| DT398441 | Incorrect Output (IN) | SQL error SQL0901N with reason "unexpected error at TimeStamp.cpp:3395" | Columnar Storage | ||
| DT406783 | Incorrect Output (IN) | CLI does not mark the connection as broken after mapping -30108 to -30081 when enableSeamlessFailoverErrorCodes is false and ACR is enabled | Client & Connectivity | ||
| DT409052 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service with a specially crafted query (CVE-2024-52903) | Federation | ||
| DT416742 | Incorrect Output (IN) | Filter option of db2fmtlog tool does not handle component correctly. | Availability | ||
| DT416751 | Loop (LP) | Capture may hang when replicating columnar tables with USESTREAMTRANS=N | IIDR | ||
| DT417579 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to a denial of service due to insufficient release of allocated memory resources. (CVE-2025-0915) | Federation | ||
| DT418725 | Incorrect Output (IN) | CLI Driver: Planned failover intercepted by affinityFailbackInterval | Client & Connectivity | ||
| DT421900 | Incorrect Output (IN) | db2look -o option does not add ".sql" extension | Catalog Services | ||
| DT422677 | db2mscs "NETNAMEVALUE" maximum length 14 bytes instead of 15 which is MAXCOMPUTERNAME_LENGTH | Availability | |||
| DT424299 | Incorrect Output (IN) | db2prereqcheck fails as KSH 93u version and release undetermined in SLES 15sp6 | Deployment | ||
| DT424610 | Integrity Problems (IG) | DB2LKGENERATEDDL fails to execute in BigSQL/DV v12.1 environments | Big SQL | ||
| DT425986 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to a denial of service under certain conditions (CVE-2025-3050) | Columnar Storage | ||
| DT436671 | Abnormal End Of The Program (AB) | db2cm -verify -resources or db2start may fail with a segmentation fault when database(s) are mounted on the shared instance mount and other database(s) are mounted on database mounts | Availability | ||
| Db2 12.1.1 Fix Pack m1fp0 | |||||
| Known Issue | Symptom | Abstract | |||
| DT392298 | Coded Halt (HL) | db2hmon waiting in Pending remote request | |||
| DT396756 | Abnormal End Of The Program (AB) | db2prereqcheck is missing a dependency check | |||
| DT147866 | Incorrect Output (IN) | IT37708: WHEN NUMBER OF TABLE PARTITIONS IS HUGE(EXAMPLE : 21000), DB2LOOK FAILS TO RECREATE TABLE DDL | |||
| DT393460 | Incorrect Output (IN) | Replication target table becomes incorrect after TRUNCATE IMMEDIATE is executed on a source database in a DPF environment | |||
| DT398854 | Coded Wait (WS) | Enhancement to release row lock on SYSIBM.SYSTABLES | |||
| DT418246 | Incorrect Output (IN) | ACTIVATE or CONNECT to a database on a newly added member in pureScale can fail or return SQL1497W / SQL1648N | |||
| DT416491 | Incorrect Output (IN) | ADMINMOVETABLE SWAP might take long due to active background processes | |||
| DT416519 | Performance (PR) | ADMINMOVETABLE dictionary creation for large columnar tables might be slow | |||
| DT397218 | Coded Wait (WS) | Potential FCM buffer leak on DPF systems when receiving SQL0803N | |||
| DT399999 | Incorrect Output (IN) | Unnecessary port binding retry although bind might have returned success return code | |||
| DT396320 | Abnormal End Of The Program (AB) | Db2 may encounter a severe error when issuing a query with IN predicate and guideline | |||
| DT389552 | DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES REFERENCING VERY LARGE CASE EXPRESSIONS IN PREDICATES | ||||
| DT409145 | Incorrect Output (IN) | Incorrect result when query has subuqery predicate with correlation. | |||
| DT223744 | Performance (PR) | NOT IN to antijoin conversion does not occur with expression. | |||
| DT418459 | Incorrect Output (IN) | 901 or incorrect result when the registry variable REDSCANELIM_UCP is enabled | |||
| DT417614 | Incorrect Output (IN) | A query to a format-fixed external table with a space to the right of the data in the DECIMAL column returns SQL20570N. | |||
| DT389572 | Incorrect Output (IN) | db2prereqcheck tool is showing AIX requirement for both 11.5.9.0 and 11.5.8.0 as 7.2 TL3 SP3 instead of 7.2 TL5 | |||
| DT417977 | Reverting - db2prereqcheck tool is showing AIX requirement for both 11.5.9.0 and 11.5.8.0 as 7.2 TL3 SP3 instead of 7.2 TL5 | ||||
| DT417537 | Abnormal End Of The Program (AB) | Windows 32-bit DSDRIVER crashes during connect to z/OS data source when installed at non-default path | |||
| DT394926 | Abnormal End Of The Program (AB) | Modify db2pd -hadr so that it no longer obtains a latch | |||
| DT396843 | Coded Halt (HL) | Application may hang when running the SELECT * FROM SYSIBMADM.DB2INSTANCEALERTS statement in a pureScale environment | |||
| DT396293 | System/3 Message (MI) | Db2 Pacemaker Corosync QDevice - Delete Cluster Domain and Read, but crm cluster status still shows old name | |||
| DT416761 | Loop (LP) | db2diag.log flooded with messages from sqlplDrainOldReadAndWriteAccess and sqlrrrpcrouter | |||
| DT397334 | Performance (PR) | LOGICAL_BACKUP stored procedure can be very slow when there are RCAC rules on SYSIBM.SYSTABLES | |||
| DT398397 | Abnormal End Of The Program (AB) | RESTORE OR CREATE DATABASE MAY FAIL WITH ERROR ECFINVALIDINVOCATION_SEQUENCE | |||
| DT395188 | Abnormal End Of The Program (AB) | Db2 Security Plugin loading failed when using ASAN (Address SANitizer) | |||
| DT393578 | Abnormal End Of The Program (AB) | Db2 operation requests to S3 fails on FIPS-enabled environments | |||
| DT416963 | Incorrect Output (IN) | Incorrect "Library is not loaded" diaglog entry from cryptGetSSLApiAddress | |||
| DT391670 | New Function (NF) | GSKit Enhancements | |||
| DT239580 | Incorrect Output (IN) | SQL Apply failed SIGIOT during startup | |||
| DT397421 | Incorrect Output (IN) | Q Apply re-applies some transactions on restart after coming down for a MQ Client connection error | |||
| Db2 12.1 GA | |||||
|---|---|---|---|---|---|
| Known Issue | Symptom | Abstract | |||
| DT213797 | Incorrect Output (IN) | Runtime rollback progress monitor in application snapshot is not correct | |||
| DT245947 | Incorrect Output (IN) | "Node" field in db2cm -list incorrectly shows primary VIP online on standby node after takeover. | |||
| DT391437 | Incorrect Output (IN) | The current value of MAXLOG is not displayed correctly in db2diag.log message when the MAXLOG limit is reached | |||
| DT242860 | Incorrect Output (IN) | Incorrect Output When Running db2level as Non-instance Owner Id in pureScale | |||
| DT247473 | Integrity Problems (IG) | SYSINSTALLOBJECTS('LBAR, 'M',...) can Fail with SQL0601N | |||
| DT179542 | Incorrect Output (IN) | Running db2iupdt when members are in restart light mode may write incorrect registry entries | |||
| DT260869 | Abnormal End Of The Program (AB) | LOGICAL_BACKUP stored procedure fails due to file system full error (SQL0968C) on a temporary table space when taking an incremental or delta backup. | |||
| DT189771 | Incorrect Output (IN) | db2pd -dbcfg does not display the current in-effect LOGFILSIZ configuration value | |||
| DT244994 | Abnormal End Of The Program (AB) | Multiple instances in mutual failover pacemaker environment, unexpectedly fail back after move | |||
| DT225193 | Incorrect Output (IN) | db2ckbkp may report false info when verifying DMS index data in the loadcopy image | |||
| DT220163 | Loop (LP) | With Advanced Log Space Management (ALSM) configured, if the database encounters transaction log full (SQL0964N) while performing a snapshot backup or rollback, operations may take a long time and look like a hang | |||
| DT258270 | Loop (LP) | Database is not activated on one of pureScale cluster after another member has successfully executed START HADR | |||
| DT386697 | Abnormal End Of The Program (AB) | db2cm -import fails on Mutual Failover instance on Pacemaker cluster environment that uses a qdevice | |||
| DT365993 | Abnormal End Of The Program (AB) | Restore rebuild may fail when the member topology in the target image is a subset of one or more intermediate images | |||
| DT260136 | Abnormal End Of The Program (AB) | db2start fails when run as SYSADM user after updating SSH on Db2 pureScale | |||
| DT381277 | Incorrect Output (IN) | Rollforward using overflowlogpath fails due to read only access to overflowlogpath. | |||
| DT179314 | Incorrect Output (IN) | History file size could not exceed 4GB | |||
| DT245317 | Abnormal End Of The Program (AB) | LOGICAL_BACKUP stored procedure for FULL backup with -tsm/-s3/-cos option on empty schema fails with SQL1797N | |||
| DT383079 | Abnormal End Of The Program (AB) | Running db2cm commands such as 'db2cm -create -cluster' with db2locssh fail | |||
| DT390383 | Integrity Problems (IG) | Security: IBM® Db2® is vulnerable to an information disclosure under specific conditions (CVE-2024-40679) | |||
| DT259070 | Incorrect Output (IN) | Db2 Restore fails with SQL2530N because size of history file included in backup image is larger than 4G | |||
| DT241215 | Incorrect Output (IN) | Unexpected SQL0998N Reason Code 36 when running distributed transactions in DPF environment | |||
| DT130654 | Incorrect Output (IN) | IT40742: DB2READLOG API FAILED WITH SQL2038N DUE TO CHANGING OVERFLOWLOGPATH ONLINE | |||
| DT244454 | Incorrect Output (IN) | Not able form HADR connection after renew certificate on the same SSL label | |||
| DT209087 | Abnormal End Of The Program (AB) | HADR standby can fail after encountering disk full during log retrieval from archive | |||
| DT258379 | Abnormal End Of The Program (AB) | db2cm -list fails to determine active state of HADR database resources on RHEL 9 | |||
| DT394761 | Abnormal End Of The Program (AB) | Execute 'db2cluster -verify -req -rdma_ping' repeatedly may get core dump at sqlhaAddRoutesAndArpsBasedOnSysFile() | |||
| DT225430 | Loop (LP) | Application hangs when generating a new SEQUENCE value. | |||
| DT215525 | Loop (LP) | Load copy restore may hang when the load copy image is corrupt | |||
| DT258934 | Abnormal End Of The Program (AB) | LOGICALBACKUP/LOGICALRESTORE fails on single database partition system with SQL1797N if db2nodes.cfg file exits | |||
| DT258086 | Abnormal End Of The Program (AB) | db2scp breaks due to default behavioral change of scp in openssh | |||
| DT236714 | Abnormal End Of The Program (AB) | Old HADR primary database hung after receiving forced takeover request | |||
| DT245323 | Abnormal End Of The Program (AB) | LOGICAL_BACKUP stored procedure for incremental multi-schema backup with -tsm/-s3/-cos option fails with SQL1797N | |||
| DT244789 | Incorrect Output (IN) | When DB2_ONLINERECOVERY enabled, database forced to shutdown during online recovery processing. | |||
| DT225730 | Incorrect Output (IN) | Incorrect db2diag.log message about non-consecutive LFH counters from db2agent | |||
| DT386990 | Abnormal End Of The Program (AB) | ForceDBShutdown due to "Invalid backlso, it should be 0 for the first log record of a new transaction." | |||
| DT246349 | Unpredictable (UN) | Orphaned transaction on DPF subordinator node after communication failure during COMMIT processing | |||
| DT260131 | Unpredictable (UN) | Db2 not able to archive transaction log files from the FAILARCHPATH directory after a database crash. | |||
| DT271473 | Coded Halt (HL) | Diag Mount resource not extended to new host for add/drop CF | |||
| DT247162 | Abnormal End Of The Program (AB) | HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK | |||
| DT174696 | Incorrect Output (IN) | RECOVER DATABASE or ROLLFORWARD DATABASE command fails with SQL10003C. | |||
| DT147892 | Incorrect Output (IN) | IT39142: "PRUNE LOGFILE PRIOR TO | |||
| DT259213 | Integrity Problems (IG) | HADR SSL support is not picking up SSL_CIPHERSPECS setting to restrict to TLS 1.3 | |||
| DT379096 | Performance (PR) | HADR standby log replay is slow when retrieving log files from archive | |||
| DT260706 | Abnormal End Of The Program (AB) | db2start segfaults on AIX when registry variable to skip TSA license check is set | |||
| DT247093 | Abnormal End Of The Program (AB) | LOGICALBACKUP/LOGICALRESTORE Stored Procedures can Hit -1224 SQLCODE | |||
| DT378855 | Incorrect Output (IN) | CF communication may time out when FODC diagnostics are dumped | |||
| DT258947 | Abnormal End Of The Program (AB) | LOGICAL_RESTORE fails with SQL1797N/SQL0644N when restoring a backup image that was taken on a system with different DPF topology or the restored table is not defined for all database partitions | |||
| DT241626 | db2cm reports instance does not exist during db2 -create -instance for the remote host when using db2locssh | ||||
| DT243562 | Performance (PR) | Database recovery is slow while multiple edus are waiting on transsem latch | |||
| DT392504 | Incorrect Output (IN) | dump.bin file is generated when ReadLog API receives interrupt with -1044 | |||
| DT387031 | Abnormal End Of The Program (AB) | db2cm -copy_resources is not copy db2fs and db2partition | |||
| DT260428 | Incorrect Output (IN) | Tablespace rollforward command with OVERFLOW LOG PATH option fails with SQL1273N when log files in overflow log path are compressed | |||
| DT237982 | Incorrect Output (IN) | DELETE from ORC ACID Hadoop table fails to delete all matching rows | |||
| DT157062 | Incorrect Output (IN) | IT00327: DB2FMP MAY LEFT FOREVER WHEN "CONNECT RESET" HAPPENED AND THE DB2FMP IS IN THE HEADER OF THE FED FMP PRCOCESS LIST | |||
| DT224629 | Incorrect Output (IN) | SYSIBMADM.ADMINTEMPTABLES AND SYSIBMADM.ADMINTEMPCOLUMNS MAY RETURN DUPLICATED ENTRIES | |||
| DT258452 | Loop (LP) | Hang during query compilation | |||
| DT258325 | Performance (PR) | db2cat not generating Packed descriptors related with timestamp scale/precision properly | |||
| DT253663 | Incorrect Output (IN) | db2updv115 returns Error cleaning up object with sqlcode -204 is ignored | |||
| DT212944 | Incorrect Output (IN) | db2look -printcfg missing MEMBER X in case of DPF/Purescale environments | |||
| DT245442 | Abnormal End Of The Program (AB) | FODC_AppErr error with segmentation fault when Packed Descriptor is NULL | |||
| DT241262 | Coded Halt (HL) | Lock wait/Latch wait from concurrent Drop Tablespace and Declare Global Temporary Table | |||
| DT259092 | Incorrect Output (IN) | Db2look missing SET CURRENT SCHEMA statements for variable DDL in output | |||
| DT260618 | Unpredictable (UN) | db2cat not generating Packed descriptors with correct codepages properly | |||
| DT222975 | Incorrect Output (IN) | UNBLOCK CREATE TABLE AND ALTER TABLE TO CREATE PARTITION EVEN WHEN BOTH IN CLAUSE AND LONG IN CLAUSE ARE REMOTE AND LOCAL AT SAME TIME | |||
| DT189371 | Incorrect Output (IN) | db2cleancat fails with SQL0100W even though orphan rows are reported | |||
| DT394248 | Abnormal End Of The Program (AB) | db2cat cannot cleanup sysibm.sysrel orphan rows | |||
| DT391371 | Unpredictable (UN) | Altering column data type from CHAR to VARCHAR may corrupt default insert length/value. | |||
| DT394782 | Incorrect Output (IN) | THE EVMONUPGRADETABLES PROCEDURE LEADS TO A NON-RECOVERABLE LOAD | |||
| DT392845 | Integrity Problems (IG) | Table columns may contain bad default which will cause SQL0901N | |||
| DT381031 | Incorrect Output (IN) | db2cleancat not checking orphaned rows | |||
| DT147908 | Incorrect Output (IN) | IT39950: IN RARE JOIN ON COLUMNAR TABLES COULD LOOSE ROWS | |||
| DT395574 | Incorrect Output (IN) | -901 error is received when SQLATTRROWARRAYSIZE set to 8 when the receiving data from a Lob column with data size > 64 k. | |||
| DT259752 | 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) | |||
| DT269614 | Abnormal End Of The Program (AB) | Support Db2 .Net provider for Linux on IBM Z | |||
| DT196087 | Incorrect Output (IN) | SQL104 when running EXPORT EXTERNAL command in CLPPLUS | |||
| DT255114 | Integrity Problems (IG) | Security: Db2 JDBC driver is vulnerable to an insecure cryptographic algorithm and to information disclosure in stack trace under exceptional conditions. (CVE-2023-47152) | |||
| DT147527 | Incorrect Output (IN) | IT39783: CIE00756E IS LOGGED WHILE STARTING TEXT SEARCH | |||
| DT364439 | Incorrect Output (IN) | When retrieving rows with decfloat values as -NaN and -SNaN using ODBC in a C or C++ program, the sign is lost. | |||
| DT202835 | Incorrect Output (IN) | NIC Binding fails without newline character in nicbinding.cfg file | |||
| DT256842 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service when querying a specific UDF built-in function concurrently (CVE-2023-52296) | |||
| DT244554 | Incorrect Output (IN) | Catalog DCS directory command allows db name to be more than 8 characters but fails to uncatalog the same. | |||
| DT392626 | Incorrect Output (IN) | Schema filter might not work properly while performing EDMX wizard operation(Updating or Creating Entity Framework Model) through Visual Studio 2019. | |||
| DT257417 | Abnormal End Of The Program (AB) | Two Phase Commit is not working as expected with the Db2 V1159 Restricted TCP/IP listener mode enhancement | |||
| DT241481 | Windows only, type2 LUW connection fails with com/ibm/db2/jcc/uw/UWConnection.DBForceDisconnect(JIZZ) | ||||
| DT241645 | Abnormal End Of The Program (AB) | FODC_Trap happened when running XA transaction in purescale unfenced DRDA wrapper | |||
| DT228852 | Abnormal End Of The Program (AB) | Security: Db2 federated server is vulnerable to a denial of service when executing LOAD under certain conditions (CVE-2024-27254) | |||
| DT196972 | Abnormal End Of The Program (AB) | DB2DataReader.GetValue() returns System.Int16 type value for the boolean column instead of System.Boolean type value. | |||
| DT366161 | Update outdated apache-mime4j-core jar. | ||||
| DT386318 | Incorrect Output (IN) | BLOB data returned in different order incorrectly when BLOB data size is > 64k and SQLATTRROWARRAYSIZE is set to 8. | |||
| DT383007 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service when querying certain tables using a specially crafted statement (CVE-2024-35152) | |||
| DT269809 | Abnormal End Of The Program (AB) | db2dsdcfgfill causing Segmentation fault | |||
| DT255163 | Incorrect Output (IN) | REMOTETIER metrics not reported correctly. All COS read/write activity monitored in COMPACTIONTIER metrics. | |||
| DT246809 | Abnormal End Of The Program (AB) | FODC_Panic with ASSERTION FAILED!!! on kvStorageImpl.cpp line 5831 | |||
| DT394370 | Abnormal End Of The Program (AB) | Marking DB bad on timeout error while draining writers for Set Write Suspend | |||
| DT394036 | Abnormal End Of The Program (AB) | Database will go down unexpectedly during set write suspend when there is bulk IO running against NOCS tables | |||
| DT381033 | Abnormal End Of The Program (AB) | Instance traps while attempting to use Native COS tablespaces on a platform where they are not supported | |||
| DT148610 | Incorrect Output (IN) | IT38534: DB2ICRT CREATES / CHANGES .PROFILE OF THE INSTANCE OWNER TO HAVEA GROUP OF THE FENCED USER SPECIFIED WITH IT. | |||
| DT208386 | Incorrect Output (IN) | db2idrop remove DB2INSTDEF when it match instance beeing dropped | |||
| DT147712 | Incorrect Output (IN) | IT39750: ALTERS TO LBAC SECURITY POLICIES ARE NOT INCLUDED IN THE DB2LOOKOUTPUT | |||
| DT147910 | Abnormal End Of The Program (AB) | IT39973: Frequent activationdeactivation can cause file handle leak and increase in memory on db2 server | |||
| DT147957 | Incorrect Output (IN) | IT41481: RUNSTATS CALCULATES PCTINLINED INCORRECTLY WHEN USING TABLE SAMPLING | |||
| DT245544 | New Function (NF) | Replay of an ALTER BUFFERPOOL operation may cause OOM | |||
| DT247235 | Incorrect Output (IN) | ADMINMOVETABLE SWAP might fail with SQL2105N RC=11 | |||
| DT381010 | Coded Message (MS) | Write suspend can fail timing out waiting due to contention on latch suspendIOCBLatch | |||
| DT270146 | Abnormal End Of The Program (AB) | SQL0901N when an XML column has been dropped from a table | |||
| DT378207 | Additional Information (AI) | Error message in db2diag.log can be ignored (sqldProcessIxmSettingsRegVar, probe:5495) | |||
| DT209421 | Performance (PR) | System temporary tablespaces are not chosen in a round-robin fashion when a temporary object is created | |||
| DT208314 | Incorrect Output (IN) | In rare cases CREATE DB XXX AT DBPARTITIONUM can fail with SQL0902C due to an invalid flavour error | |||
| DT270239 | Coded Message (MS) | ADM5530W (COMMIT processing of table that used NOT LOGGED INITIALLY) messages reported in db2diag.log | |||
| DT259443 | Performance (PR) | Using DB2USEALTERNATEPAGECLEANING might, over time, clean dirty pages more aggressively than expected | |||
| DT387637 | Abnormal End Of The Program (AB) | Incompatibility between Db2 11.5.5+ client and Db2 11.1.4.7 server for INGEST command | |||
| DT246182 | Abnormal End Of The Program (AB) | A bad page error might be encountered when inserting data into a table with a clustering index after a REORG shrunk the table size. | |||
| DT385994 | Memory leak running LOAD with STATISTICS USE PROFILE after RUNSTATS with distribution set profile only | ||||
| DT276217 | Incorrect Output (IN) | after ADMINMOVETABLE NOT ENFORCED constraints might be missing | |||
| DT245652 | Performance (PR) | EDUs can hang while unlatching a page with DB2USEPAGELATCH_TRACKING enabled | |||
| DT258165 | Incorrect Output (IN) | ADMINGETTABINFO reports LOB/XML sizes as zero while ADMINMOVE_TABLE is in progress | |||
| DT213452 | Incorrect Output (IN) | db2pd -pages with "summary" option reports information that should not be in summary output | |||
| DT259276 | Incorrect Output (IN) | LOAD and IMPORT with lob filename of 1 character only, rejects row with SQL3229W | |||
| DT394671 | Abnormal End Of The Program (AB) | ADMINMOVETABLE in pureScale with FORCE_ALL option might take a long time to complete SWAP phase or even fail when running concurrent applications accessing the same table using dynamic SQL | |||
| DT257083 | Abnormal End Of The Program (AB) | Certain database activation failures can leak memory | |||
| DT224833 | Integrity Problems (IG) | Security: Unauthorized access to data vulnerability in ADMIN_CMD. (CVE-2023-38729) | |||
| DT258500 | Abnormal End Of The Program (AB) | ADMINMOVETABLE option MESSAGES ON SERVER might cause SQL0104N | |||
| DT364320 | Performance (PR) | Excessive latch contention on SQLOLTSQLBDIRTYLISTSET_walkLatch when DGTTs/CGTTs have indexes | |||
| DT246439 | Incorrect Output (IN) | Incorrect units listed in Performance Metrics of Extent Movement in DB2DIAG | |||
| DT379179 | Abnormal End Of The Program (AB) | Possible memory corruption in some rare situations when space is freed on a page by a delete or update operation | |||
| DT365906 | Abnormal End Of The Program (AB) | Replication program may fail due to some information only log records being written incorrectly with the propagate flag | |||
| DT246121 | Incorrect Output (IN) | SQL2048N might wrongly be raised on a backup operation when registry DB2BCKPPAGE_VERIFICATION=TRUE | |||
| DT364325 | Abnormal End Of The Program (AB) | db2fmtlog not formatting "Delete LOB data" and "Non-update LOB data" log records | |||
| DT270487 | Abnormal End Of The Program (AB) | LOAD into column based tables may crash | |||
| DT260764 | Incorrect Output (IN) | Page Cleaner may lose track of outstanding IOs after transient IO error | |||
| DT246538 | Abnormal End Of The Program (AB) | Replay of extent movement may result in abnormal tablespace state | |||
| DT393022 | Incorrect Output (IN) | Fix XML query missing closing bracket ">" on DPF settings | |||
| DT247759 | Abnormal End Of The Program (AB) | DB2 MAY TRAP DURING LOCK ESCALATION | |||
| DT394113 | Abnormal End Of The Program (AB) | pureScale instance may panic when unfixing a page due to an invalid page latch | |||
| DT246746 | Incorrect Output (IN) | Invalid XML from MONGETPKGCACHESTMT with FOR BIT DATA | |||
| DT365991 | Incorrect Output (IN) | Possible SQL0901N when adding a new key to an index | |||
| DT381034 | Abnormal End Of The Program (AB) | Possible memory corruption when the amount of free space changes on the a page in a table with a clustering index. This memory corruption could potentially lead to corruption of table data. | |||
| DT381196 | Abnormal End Of The Program (AB) | -902 returned by db2ReadLog API when attempting to decompress the compressed row image in the log record | |||
| DT381265 | Incorrect Output (IN) | Indexes on tables created by ALTER TABLE ... DETACH PARTITION ... are not owned by the Authorization ID that executed the ALTER TABLE statement. | |||
| DT144806 | Incorrect Output (IN) | IT38496: DB2ICRT CREATES / CHANGES .PROFILE OF THE INSTANCE OWNER TO HAVEA GROUP OF THE FENCED USER SPECIFIED WITH IT. | |||
| DT244342 | Unpredictable (UN) | db2profile and db2cshec tries to add missing antlr-3.2.jar into CLASSPATH. | |||
| DT261574 | Abnormal End Of The Program (AB) | Security: Db2 is affected by a vulnerability in an open source library zlib (CVE-2023-45853) | |||
| DT208323 | Incorrect Output (IN) | InstallFixPack succeeds with the install log file pointing to incorrect directory in optional step message points to -b | |||
| DT197596 | Incorrect Output (IN) | Group id was returning overflow int value during creation of fencedid file | |||
| DT159733 | Incorrect Output (IN) | IT31301: DB2RSPGN DOES NOT CREATE DB2COMMONAPPDATATOP_PATH | |||
| DT257627 | Incorrect Output (IN) | installFixPack -showlevelinfo for Db2 11.5.9 shows incorrect "Minimum committed code level required for online install" | |||
| DT160540 | Machine Check (MC) | Password Confirm field does not accept more than 14 characters in Db2 Installation Wizard on Windows OS | |||
| DT147685 | Abnormal End Of The Program (AB) | IT38755: DB2PREREQCHECK RETURNS SYNTAX ERRORS WHEN YOU DON'T USE OPTIONS | |||
| DT258954 | Abnormal End Of The Program (AB) | db2installPCMK fails when updating from db2 image with pcmk-docs to one without | |||
| DT041374 | Unpredictable (UN) | IT30122: INSTALLFIXPACK DELETES /ETC/SYSTEMD/SYSTEM/DB2FMCD.SERVICE FILE ON LINUX | |||
| DT196425 | Abnormal End Of The Program (AB) | Installing Db2 connect server as a non-root user fails with a minor error | |||
| DT208933 | Incorrect Output (IN) | installFixPack -b | |||
| DT178438 | Performance (PR) | Performance Issue for Windows NT Db2 DSDriver | |||
| DT172984 | Additional Information (AI) | installFixpack without hastandbyignore option may not fail even though there is an instance where the sqllib directory is not mounted | |||
| DT270356 | Integrity Problems (IG) | Db2 tools permissions read only after being moved to a new folder location | |||
| DT258225 | Integrity Problems (IG) | Disable message queue creation in db2licd which has been discontinued | |||
| DT256803 | Integrity Problems (IG) | Security: Db2 is vulnerable to a privilege escalation due to improper file permissions on Windows (CVE-2023-47145) | |||
| DT258875 | Abnormal End Of The Program (AB) | Interrupt Federation NOSQL queries returns error code SQL1476N | |||
| DT276378 | Abnormal End Of The Program (AB) | Security: Db2 federation is affected by vulnerabilities in an open source library commons-compress (CVE-2023-25710, CVE-2024-26308) | |||
| DT245187 | Abnormal End Of The Program (AB) | Db2 federation reports SQL0901N The SQL statement failed (Reason "Unhandled data type".) when querying nickname decimal values with single quote. | |||
| DT382287 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-37071) | |||
| DT257398 | Performance (PR) | Federation: Performance is bad due to query not pushed down for "no support correlation cse" | |||
| DT393712 | Incorrect Output (IN) | SQL Update on Column-Organized Remote Table on Federated Database might fail with SQL1667N | |||
| DT253559 | Abnormal End Of The Program (AB) | Rollback of operations on nickname cause database hang | |||
| DT253570 | Performance (PR) | IN DB2 FEDERATED CERTAIN PREDICATE OPTIMIZATION DO NOT APPLY IN PRESENCE OF NICKNAMES. | |||
| DT256815 | Integrity Problems (IG) | Security: Db2 is affected by multiple vulnerabilities in the open source presto library. | |||
| DT254946 | Incorrect Output (IN) | Federated queries against Db2 for z/OS experience truncation issues with character columns | |||
| DT237800 | Abnormal End Of The Program (AB) | Federation returns SQL0901N “Bad Data type” when remote PostgreSQL has unique index on BYTEA column | |||
| DT253655 | Incorrect Output (IN) | Permit distinct is added in wrong place in remote statement for outjoin | |||
| DT276243 | Incorrect Output (IN) | Some Federation db2fmp thread cannot be reused if user mapping plugin is enabled | |||
| DT276372 | Update outdated json-path jar. | ||||
| DT396121 | Incorrect Output (IN) | Invalid characters are inserted into the GRAPHIC column instead of blank padding when the length of the inserted String is less than the column length. | |||
| DT246476 | Incorrect Output (IN) | COLUMN LENGTH OF A NICKNAME UNEXPECTEDLY EXTENDS BY A FACTOR OF 4 WHEN THE REMOTE COLUMN IS CODEUNIT32. | |||
| DT247610 | Abnormal End Of The Program (AB) | CREATE NICKNAME might cause SQL1822N Unexpected error code Error with ODBC Wrapper | |||
| DT245747 | Incorrect Output (IN) | An update on nickname set column = null, might report a DB21034E message with an embedded SQL604 indicating “CHAR(0 OCTETS)” is not valid | |||
| DT257775 | Performance (PR) | Db2 federation YEAR() function not pushdown to SQL Server caused low query performance | |||
| DT269538 | Incorrect Output (IN) | Enabling two phase commit on DRDA datasource wrong results returned | |||
| DT260513 | Abnormal End Of The Program (AB) | CSE TEMP from remote causing codegen to execute a subsection twice | |||
| DT241777 | Abnormal End Of The Program (AB) | IMPORT on Db2 Federation nickname might cause SQL0440N Error. | |||
| DT258536 | Coded Message (MS) | Undefined user tenant receives SQL0270N Function not supported (Reason code = "125") when federating to Db2 for z/OS | |||
| DT380381 | Incorrect Output (IN) | Federation: SQL0901N error "bad outer compare" | |||
| DT247476 | Incorrect Output (IN) | Db2diag.log fills with lost of warning messages that relate to drop_server | |||
| DT257776 | CD4D Inline view query fails - SQL1822N - Schema must be specified when session schema is not set | ||||
| DT257584 | Incorrect Output (IN) | NNSTAT reports SQL20274W error | |||
| DT364021 | Incorrect Output (IN) | SELECT ... UNION SELECT DIGITS(c1) ... ORDER BY MAY RETURN AN INCORRECT ORDER | |||
| DT260107 | Unpredictable (UN) | The SQL statement or command failed with SQL901 and reason lock not owned by caller | |||
| DT380983 | Integrity Problems (IG) | Security: Db2 is affected by vulnerabilities in the open source commons-configuration2 library. (CVE-2024-29131, CVE-2024-29133) | |||
| DT257503 | Defect fix MS SQL Server rand() in a query predicate not working in CP4D v4.7 | ||||
| DT261886 | Abnormal End Of The Program (AB) | SYSPROC.NNSTAT traps in IOvfprintf function call | |||
| DT381851 | Integrity Problems (IG) | Security: Db2 federated server is affected by a vulnerability in an open source library bcprov-jdk18on (CVE-2024-30171, CVE-2024-30172) | |||
| DT386586 | Integrity Problems (IG) | Security: Db2 is affected by a vulnerability in the open source netty-codec library. (CVE-2024-29025) | |||
| DT381804 | Abnormal End Of The Program (AB) | Federation create nickname for Informix failed with SQL3324N Column has a type of "BIGINT()" which is not recognized | |||
| DT389938 | Q Apply should support External Table Load (LOAD_TYPE 7) when the source table is row organized | ||||
| DT261299 | Incorrect Output (IN) | SQL Apply ASNLOAD.exe crashes | |||
| DT245324 | Incorrect Output (IN) | Q Apply internal load for columnar table fails with SQL-303 when there are FOR BIT DATA columns | |||
| DT255120 | Incorrect Output (IN) | Set PRUNEBYCORRELID default to N when Q Apply is using MQ Client to access local queue on z/OS | |||
| DT393441 | Incorrect Output (IN) | Capture should deactivate subscriptions if drop column statement is detected on LUW | |||
| DT247445 | Incorrect Output (IN) | For SQL Replication, we should keep column options "NOT NULL WITH DEFAULT" when altering CD table | |||
| DT245558 | Incorrect Output (IN) | Asnmail program crashed on Windows platform | |||
| DT245411 | Unpredictable (UN) | SEARCH_CONDITION does not filter data properly | |||
| DT245070 | Incorrect Output (IN) | ASN2100E occurs when CREATE QSUB with source column name length exceed 30 chars for Oracle target. | |||
| DT246371 | Incorrect Output (IN) | QREP need to generate ctl file for SQLLOADER with EXPRESSION parameter after a column name to set that column to the value returned by a SQL operator or specially written PL/SQL function | |||
| DT247984 | Abnormal End Of The Program (AB) | QApply fails with SQL0193N when processing an ADDCOL on a table with a user defined-type column, because QCapture sends a bad message. | |||
| DT394030 | Incorrect Output (IN) | Fix for truncate immediate being rolled back | |||
| DT257883 | Incorrect Output (IN) | Update migration script for Oracle capture and support options for new control tables on SQLRep | |||
| DT380061 | Apply RECVQ gets stuck on ADDCOL when there is an open streaming transaction | ||||
| DT237964 | Incorrect Output (IN) | Q Apply Initial Load fails on Generated Always Row Organized tables with ASN7597E and SQL3107 rows rejected | |||
| DT365587 | Incorrect Output (IN) | Q Capture with LOGREAD_PREFETCH=Y loops and repeatedly issues ASN0193W if error during startup, even if TERM=Y, instead of coming down. | |||
| DT393610 | Incorrect Output (IN) | INCLUDE column in UNIQUE INDEX is picked up as a replication key wrongly | |||
| DT393194 | Incorrect Output (IN) | Oracle Capture should not terminate if a new column is added into a source table | |||
| DT255449 | Incorrect Output (IN) | In ASNCLP, we needn't check each Db2 version 10,11...just need to check if the version number is bigger than 10 | |||
| DT258156 | Incorrect Output (IN) | SQL Apply exposes error ASN1001E if we specify COMMIT COUNT value when creating subscription set | |||
| DT261339 | Incorrect Output (IN) | Q Apply TOLERATEPARTIALTRANS=Y should tolerate not 1st trans seq -> TXS error | |||
| DT390507 | Incorrect Output (IN) | Q Apply does not generate data file correctly for Oracle sqlldr with expressions | |||
| DT245447 | Incorrect Output (IN) | Add SQLRep missing columns for upgrade scenarios. | |||
| DT244881 | Incorrect Output (IN) | Keep Capture_truncate default value as 'W' . | |||
| DT365075 | Incorrect Output (IN) | Replication Center(RC) makes a garbled character for value of IBMQREPSUBS table's HASPARTS column in UPDATE statement, when adding a column for replication. | |||
| DT259072 | The Replication Alert Monitor only generated the ASN5157W alert when one Q subscription is in inactive and STATE_INFO is not NULL | ||||
| DT260640 | Incorrect Output (IN) | Spill to file code fix in Q Capture when transaction has rollback to savepoint | |||
| DT381798 | Q Capture should deactivate the associated subscriptions if the external table file size on disk does not match what was logged by db2 | ||||
| DT383101 | Incorrect Output (IN) | Q Capture should allow the use of wildcards for schema/table name in IBMQREP_EXCLSCHEMA | |||
| DT247507 | Incorrect Output (IN) | We need to detect Db2 z/os version in ASNCLP, different version has different behavior. | |||
| DT393166 | Incorrect Output (IN) | SQL Capture should ignore row Opcode 6 | |||
| DT238210 | Incorrect Output (IN) | STALE and WARNTXSZ value set in IBMSNAP_CAPPARMS are not picked up even after a restart of SQL Capture | |||
| DT378635 | Incorrect Output (IN) | ASNCLP with "INCLUDE HISTORY" option for temporal tables is resulting in the error of SQLCODE=-20490. | |||
| DT394335 | Integrity Problems (IG) | Q Capture incorrectly replicates a row that is rolled back because of duplicate key violation | |||
| DT382046 | Incorrect Output (IN) | Deactivate subscription if DCC is turned off while Capture is running for an active subscription | |||
| DT247802 | Incorrect Output (IN) | Finding transaction ID for QApply to use in skip trans | |||
| DT245039 | Abnormal End Of The Program (AB) | Q Capture crashes when run with debug in a dpf environment during publishing of streamed transactions | |||
| DT390155 | Abnormal End Of The Program (AB) | Q Apply crashes in conflict retry logic on a spilled row | |||
| DT380453 | Incorrect Output (IN) | Add the SQLRep migration scripts into 1140 | |||
| DT261352 | Abnormal End Of The Program (AB) | Files libdb2CosApiS3.so and db2RemStgManager are missing on Linux for zSeries | |||
| DT247384 | Abnormal End Of The Program (AB) | Db2 might crash due a failed semaphore operation (semop OSERR: EIDRM/EINVAL) after accessing a remote storage object (DB2REMOTE) | |||
| DT259128 | Incorrect Output (IN) | A SQL1646N error returns and the number of threads used by the db2fmp increases. | |||
| DT259936 | Incorrect Output (IN) | Avoid "cannot open file" errors while using rah or db2_all concurrently | |||
| DT379919 | Incorrect Output (IN) | Incorrect diagnostics in case tree that reports memory corruption. | |||
| DT147898 | Unpredictable (UN) | IT39477: DB2 MIGHT UPDATE KERNEL.MSGMNI AND KERNEL.SHMMNI TO 32K IN CASE IPCMNI_EXTEND IS DISABLED. | |||
| DT270233 | Performance (PR) | DIO with NFS should be restricted to READWRITE/WRITEONLY | |||
| DT393449 | Incorrect Output (IN) | Backup/Restore operations may abort due to SQLOADDRCONFLICT error of db2vend process. | |||
| DT394111 | Abnormal End Of The Program (AB) | Administration notification log records written by a WSE instance on 11.5.9 Windows corrupts Event log data. | |||
| DT261306 | Coded Halt (HL) | SQL1652N File I/O error occurred returned on db2start or db2stop in DPF | |||
| DT382026 | Abnormal End Of The Program (AB) | Trap in dlopen() causes deadlatch with loadquery() called by Db2 signal handler | |||
| DT382989 | Incorrect Output (IN) | db2 admin task failing with SQL0100W message can return a misleading message "DIA8111C Authorization failure" in db2diag.log | |||
| DT258849 | Abnormal End Of The Program (AB) | db2support debug information enhancement for db2look output generation failure | |||
| DT214893 | Incorrect Output (IN) | FODC_AppErr doesn't use the path configured by "db2pdcfg -fodc FODCPATH= | |||
| DT223345 | Additional Information (AI) | Incomplete or empty db2look file from optimizer db2support diagnostic data collection | |||
| DT365492 | Performance (PR) | db2support collection get stuck at prerequisite check information step | |||
| DT258712 | Incorrect Output (IN) | Windows only: db2pd -intwlmadmission generates a binary file under C:\ regardless of DIAGPATH setting and fails to dump intwlmadmission data with either queue or detail option | |||
| DT395088 | Incorrect Output (IN) | "warning: direct reference to protected function" messages may appear when running Db2 executables on zLinux SUSE 15 SP6 | |||
| DT247203 | Abnormal End Of The Program (AB) | Db2 Trap in sqleWLDContinueSpin() | |||
| DT247998 | Incorrect Output (IN) | Cannot add new member in PureScale due to memory address conflict error | |||
| DT386158 | Incorrect Output (IN) | Monitoring LBPPAGESFOUND element does not take CACHING_TIER into account. | |||
| DT381925 | Abnormal End Of The Program (AB) | Connection retry logic should be avoided for down members in pureScale | |||
| DT148624 | Incorrect Output (IN) | IT38982: FODCWLMQUEUE GENERATION CAN TAKE TOO LONG | |||
| DT259129 | Coded Halt (HL) | Deadlatch on SQLOLTSQLPDBCBaddlogspace_sem is possible when using threshold violation event monitors and wlm thresholds | |||
| DT215999 | Performance (PR) | Contention on dbMgrLatch with many client connection termination | |||
| DT270063 | Incorrect Output (IN) | IN PURESCALE WHEN AN APP RECEIVES SQL0997W MESSAGES ARE LOGGED WITH LEVEL SEVERE/ERROR THAT SHOULD BE INFORMATIONAL | |||
| DT378285 | Abnormal End Of The Program (AB) | UPDATE DBM CFG IN A CLIENT INSTANCE FAILS WITH SQL5126N AFTER UPGRADING FROM LOWER VERSION. | |||
| DT172757 | Abnormal End Of The Program (AB) | SQL1428N from SQLDropDB() if SQLDriverConnect() connection-string has local hostname | |||
| DT245132 | Coded Halt (HL) | Db2 thread may hang when a signal handler is called during the invocation of localtime_r function | |||
| DT260491 | Abnormal End Of The Program (AB) | Possible trap in pdCreateDirFODC | |||
| DT394169 | Abnormal End Of The Program (AB) | An instance crash may occur during event monitor activation if there is insufficient memory in the Database Monitor Heap (MONHEAPSZ) | |||
| DT387593 | Incorrect Output (IN) | Write to Table event monitors disappear on non-catalog nodes | |||
| DT260289 | Incorrect Output (IN) | UPDATE DB CFG command might fail with SQL5124N in DPF or pureScale environment | |||
| DT392571 | Coded Halt (HL) | Event Monitor application handle may be stuck in Pending remote request on pureScale or DPF systems. | |||
| DT247624 | Incorrect Output (IN) | Caching Tier Hit Ratio is incorrect | |||
| DT387634 | Incorrect Output (IN) | Calling the EVMONFORMATUETOTABLES procedure may take time and it cannot be forced | |||
| DT269842 | Incorrect Output (IN) | AUTOMATIC FCM_PARALLISM computation can set a value greater than the maximum allowed configuration value | |||
| DT380116 | New Function (NF) | On Db2 pureScale Force DB Shutdown Does Not Stop the Database Quickly Enough | |||
| DT247649 | Incorrect Output (IN) | COMPACTION column names in MONGETBUFFERPOOL, MONGETDATABASE and MONGETTABLESPACE are wrong | |||
| DT246510 | Performance (PR) | SQLOLTsqmcontrolmeslatch Contention in Heavy Workloads with System Temp Tables | |||
| DT380557 | Coded Halt (HL) | Rolling updates installfixpack -commit_level can fail if upgrading from before/on v1157 to versions after/on v1157 with SQL1648 | |||
| DT382327 | Incorrect Output (IN) | Update database manager configuration can succeed for MULTIPARTSIZEMB configuration parameter outside the allowable range on pureScale | |||
| DT148803 | Abnormal End Of The Program (AB) | db2pkgrb terminates abonrmally with concurrent call to SYSPROC.ADMINREVALIDATEDB_OBJECTS() | |||
| DT247890 | Abnormal End Of The Program (AB) | DB2 may wrongly report -901 instead of -551 when package compilation fails due to -551 | |||
| DT147904 | Incorrect Output (IN) | IT39769: DB2 MIGHT REPORT AN ERROR FOR COMPLEX UNION REFERENCED IN COMMONTABLE EXPRESSIONS | |||
| DT237759 | Coded Message (MS) | A Db2 query may generate a SQL 901 when using an aggregate function on an expression | |||
| DT246499 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service when a specially crafted query is used (CVE-2023-47746) | |||
| DT148509 | Abnormal End Of The Program (AB) | IT41779: ISSUING A QUERY WITH TABLESAMPLE MAY FAIL BY SQL0901N. | |||
| DT169848 | Performance (PR) | Poor performance of Db2 query with correlated scalar subquery | |||
| DT246413 | Incorrect Output (IN) | External procedure invocation may fail with SQL0204N after dropping and recreating dependent table and auto_reval=disabled | |||
| DT149263 | Abnormal End Of The Program (AB) | IT42026: DB2 MIGHT RETURN -901 WHEN EXTERNAL TABLE FUNCTIONS ARE USED IN INSERT STATEMENTS WITH COLUMN ORGANIZED TABLES | |||
| DT258141 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service with a specially crafted query on certain columnar tables (CVE-2024-22360) | |||
| DT271456 | Abnormal End Of The Program (AB) | FODC_Trap with Signal 11 (SIGSEGV) when executing a complex query with a mix of replicated and non-replicated tables and an IN list predicate | |||
| DT224146 | Abnormal End Of The Program (AB) | -901 error might be thrown when there are AVG functions inside complex CSEs (Common Subquery Expressions) | |||
| DT245211 | Incorrect Output (IN) | A SORT plan may fail with -901 and error message "Order columns removed from the sort output columns" | |||
| DT393612 | Abnormal End Of The Program (AB) | Db2 Query may Trap when MQT has aggregation | |||
| DT255442 | Abnormal End Of The Program (AB) | Db2 may generate 901 when table with generated column participate in join | |||
| DT270076 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service with a specially crafted query under certain conditions (CVE-2024-28762) | |||
| DT269553 | Abnormal End Of The Program (AB) | Db2 COMPLEX QUERY WITH IN LIST PREDICATE FAILS WITH SQL0901N | |||
| DT254942 | Performance (PR) | Poor performance due to unexpected filter factor | |||
| DT381784 | Integrity Problems (IG) | Db2 may terminate abnormally after upgrade to a new fixpack. | |||
| DT197356 | Incorrect Output (IN) | Possible wrong result when comparing DBCLOB in column-organized table and string contains surrogate characters | |||
| DT221786 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service when using a specially crafted query (CVE-2023-47747) | |||
| DT391472 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-41761) | |||
| DT259574 | Performance (PR) | -901 "Inc bind section statement changed!" and FODC_AppErr after applying Cumulative Special Build | |||
| DT395960 | Abnormal End Of The Program (AB) | SQL0901N when UNION has more than 64 branches | |||
| DT394272 | Performance (PR) | Scalar Subquery joined with Base Table participating in Outer Join may cause poor performance | |||
| DT270507 | Incorrect Output (IN) | Cast of non-string to VARCHAR FOR BIT DATA with NLSSTRINGUNITS=CODEUNITS32 has wrong result type string unit | |||
| DT365596 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted statement (CVE-2024-31880) | |||
| DT257192 | Performance (PR) | Db2 CLI and ODBC function SQLColumns might require a long time to compile if FUNCTION PATH doesn't start with SYSIBM schema | |||
| DT269502 | Performance (PR) | Db2 query may show poor performance when Group By is applied before joining on Group by Columns | |||
| DT365623 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted query on certain columnar tables (CVE-2024-31881) | |||
| DT378893 | Coded Message (MS) | SUBSTR expression on column-organized table fails with -901 "unexpected error at MinMaxPartialEvaluator.cpp" | |||
| DT221739 | Incorrect Output (IN) | Incorrect result with IN/EXISTS subquery predicate and table function | |||
| DT364145 | Performance (PR) | Performance issue for queries with Left Outer join referencing a correlated scalar sub-query in the ON clause | |||
| DT392170 | Abnormal End Of The Program (AB) | Memory overwrite when compiling a query that joins multiple column-organized tables with complex join predicates | |||
| DT256943 | BDInsights workload query simple-23 fails with SQL0901N against DATALAKE/Iceberg TPC-DS tables accelerated by MQTs stored in Db2 Native format on Cloud Object Storage (NCOS) | ||||
| DT390381 | Incorrect Output (IN) | Wrong results due to Incorrect SMP parallelization strategy using UNIQUE and NLJOIN operators | |||
| DT179938 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service as a trap may occur when selecting from certain types of tables (CVE-2023-29267) | |||
| DT210965 | Abnormal End Of The Program (AB) | A SELECT WITH CASE EXPRESSION MAY FAIL WITH ERROR SQL0901N ( REASON "INVALID QNC ASSIGNMENT") | |||
| DT243869 | Abnormal End Of The Program (AB) | Compilation of complex query might result in segv trap with sqlnoallochash_table | |||
| DT246037 | Incorrect Output (IN) | A merge query with rownum may fail with -901 error | |||
| DT364003 | Abnormal End Of The Program (AB) | FODC_AppErr will be generated for an Update statement when a column from the target of the Update is referenced in the ORDER BY clause of a scalar sub-query in the SET clause | |||
| DT173611 | Abnormal End Of The Program (AB) | Db2 server may return -901 when using REGEXP_LIKE FUNCTION in the query | |||
| DT393202 | Performance (PR) | low selectivity estimate of IS NULL predicates results in less optimal plan execution | |||
| DT259695 | Abnormal End Of The Program (AB) | db2exmig moving to Db2LUW v11.5.9.0 fails on Windows platform | |||
| DT386007 | Performance (PR) | Poor performance of internal procedure SYSIBM.SQLPROCEDURECOLS resulting in high CPU usage | |||
| DT383082 | Integrity Problems (IG) | CREATE OR REPLACE SQL routine fails with SQLCODE -901 "No procedure package found in sysdepencies" | |||
| DT381749 | Incorrect Output (IN) | Trap when subquery predicate used with OR | |||
| DT380947 | Poor performance due to missing user selectivity marking | ||||
| DT261460 | Performance (PR) | A query referencing column-organized tables may perform sub-optimally when selecting from a scalar subquery within a common-table-expression | |||
| DT387181 | Incorrect Output (IN) | Incorrect result when query has UNION ALL and reference to same table. | |||
| DT276289 | Incorrect Output (IN) | In DPF, XML queries may return incorrect result if tables are repositioned prior to navigation | |||
| DT386996 | Performance (PR) | Poor performance when UNION has Scalar Aggregate | |||
| DT147985 | Performance (PR) | IT26459: SLOW PERFORMANCE MIGHT BE OBSERVED WHEN RUNNING AN IUD STATEMENTWITH CERTAIN CHARACTERISTICS | |||
| DT363631 | Performance (PR) | Poor performance during inserts into columnar tables due to high contention on database heap latch | |||
| DT147400 | Abnormal End Of The Program (AB) | IT41688: Return SQL0901N instead of SQL0902N which takes Database down when we failed to get latch in DPF. | |||
| DT261311 | Abnormal End Of The Program (AB) | FMP Trap due to wrong pd macro | |||
| DT276989 | Incorrect Output (IN) | VARCHAR_FORMAT() support for DECFLOAT | |||
| DT244336 | Incorrect Output (IN) | Execution of static package fails with 'cdeStaticSettings != __null' AssertionFailedException | |||
| DT146845 | Incorrect Output (IN) | IT34397: A MERGE STATEMENT CAN FAIL WITH AN SQL0901N: REASON (UNEXPECTEDERROR AT TSNRANGEITERATOR.CPP:841) | |||
| DT255196 | Incorrect Output (IN) | SQL0901N error with assertion failure "bad year" (or bad month, day, hour, minute, second, or time) when querying a DATE, TIME, or TIMESTAMP column in a columnar table | |||
| DT197214 | Abnormal End Of The Program (AB) | Trap with sigsegv in CDE Join in crash recovery scenario | |||
| DT246563 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to a denial of service when a statement is run on columnar tables under specific conditions (CVE-2023-50308) | |||
| DT260222 | Abnormal End Of The Program (AB) | CAST from BINARY type to DECIMAL fails with -901 error sqlerrmc: unexpected error at DecimalCore.hpp:308 | |||
| DT270401 | Abnormal End Of The Program (AB) | Db2 11.5.8. CDE query fails with AssertionFailedException Thrown at JoinSpillInfo.cpp : 4342 | |||
| DT255491 | Incorrect Output (IN) | varchar_format prefixing with 0 when the number is passed in exponential format resulting in inconsistent output | |||
| DT391953 | Abnormal End Of The Program (AB) | Potential memory leak in java heap if SP/UDF implemented by java | |||
| DT246565 | Incorrect Output (IN) | Message SQL0913N with reason code 80 and message "Unable to get insert range for table" in db2diag.log | |||
| DT246502 | Abnormal End Of The Program (AB) | The fix for DT245096 introduced a different problem | |||
| DT244628 | Coded Halt (HL) | Rare 901 with SORT using FETCH FIRST N ROWS or LIMIT in columnar engine | |||
| DT221961 | Assertion tableInTCB == &table fails during table index rebuild | ||||
| DT258155 | Abnormal End Of The Program (AB) | Db2 server may report -902 and database marked bad | |||
| DT212556 | Coded Message (MS) | -901 in sqlkbptn - with message, unexpected src len > can_len | |||
| DT259530 | Abnormal End Of The Program (AB) | SQL0954C error code returned when access plan has a HSJN with BTQ | |||
| DT257175 | Coded Message (MS) | Return code get can overwritten in message from sqlerCallDL in db2diag.log | |||
| DT243538 | Abnormal End Of The Program (AB) | SQLOSLATCHCAS64::getConflictComplex reports corrupt latch when releasing extended insert range as part of truncate table | |||
| DT247559 | Incorrect Output (IN) | Incorrect result possible with OLAP done in rowstore when sql has EXISTS clause. | |||
| DT390024 | Abnormal End Of The Program (AB) | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-41762) | |||
| DT260342 | Incorrect Output (IN) | SQLCODE -901 "invalid compile env: catalog index key violation" during PREP or BIND | |||
| DT259502 | Abnormal End Of The Program (AB) | Memory leak or high memory usage in Db2 Server when using "CURRENT TIMEZONE" syntax with monitor functions (MON_xxx) | |||
| DT377867 | Incorrect Output (IN) | Assertion "'mInitializedForRowLogging' failed: Row logging must be initialized before starting" in columnar table using replication | |||
| DT380744 | Abnormal End Of The Program (AB) | Rare sigsegv when HSJN is done in Columnar logic on Columnar Tables | |||
| DT390433 | Abnormal End Of The Program (AB) | db2trc fmt SEGV in pdSQRAFormattokenlist() | |||
| DT257996 | Incorrect Output (IN) | SQL0180N WHEN USING CASE EXPRESSION WITH COLUMNAR TABLE | |||
| DT259814 | Abnormal End Of The Program (AB) | Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2024-25046) | |||
| DT148274 | Integrity Problems (IG) | Security: IBM DB2 for Linux, UNIX and Windows (includes Db2 Connect Server) is vulnerable to denial of service with a specially crafted query (CVE-2023-47158) | |||
| DT197041 | Performance (PR) | Revoking DBADM privilege binder invalidates package with no dependencies unnecessarily | |||
| DT245279 | Abnormal End Of The Program (AB) | POSSIBLE CORE FILE, TRAP WITH CORRUPTED STACK GENERATED BY DB2FMP WHEN QUERY IS INTERRUPTED | |||
| DT244709 | Incorrect Output (IN) | Specifying a value outside the column range for the SUBSTR scalar function in CDE query may result in a SQL0901N | |||
| DT148482 | Incorrect Output (IN) | IT40937: BOOLEAN EXPRESSION EVALUATION RETURNS WRONG RESULT WITH NULLS | |||
| DT256910 | Coded Wait (WS) | An assertion hit by running runstats might cause the runstats command to hang | |||
| DT246556 | the fix for DT245096 introduced a different second problem | ||||
| DT260082 | Loop (LP) | Query a nickname may get hang when DB2MAXTHREADSPERFMP is set | |||
| DT246562 | Abnormal End Of The Program (AB) | Assertion failure "Offset into table accessors list is bad" when truncating a columnar table | |||
| DT178408 | Incorrect Output (IN) | ROUND unable to provide correct result for double at precision value of 4 | |||
| DT212319 | Abnormal End Of The Program (AB) | REFRESH TABLE of a column organized MQT in a DPF system can result in a -901 sqlcode and a database shutdown | |||
| DT256966 | Abnormal End Of The Program (AB) | Queries on Columnar tables may fail with -901, "Unable to access target page from page map" reported in db2diag.log | |||
| DT212894 | Incorrect Output (IN) | Running select statement with LISTAGG(...) WITHIN GROUP(ORDER BY ...) returns error -901 | |||
| DT174067 | Incorrect Output (IN) | Command "db2set -lr" does not list the registry variables used to control replication of columnar tables | |||
| DT269600 | Incorrect Output (IN) | varchar_format support for decfloat | |||
| DT363633 | Abnormal End Of The Program (AB) | FODCAppErr on LeafPredicateEvaluator::processTSNRange then FODCTrap on PackedBankSIMD caused instance to crash | |||
| DT258264 | Loop (LP) | PSM Procedures fails interpreting with external interrupts, results in endless cycle of rollback | |||
| DT261226 | Additional Information (AI) | Slow performance due to excessive db2diag.log function TableInserter::handleTailPageZero entry | |||
| DT245904 | Abnormal End Of The Program (AB) | SQL1042C error reported with SQLJ.RECOVERJAR and SQLJ.INSTALL_JAR for WINDOWS | |||
| DT391657 | Loop (LP) | In rare condition sort queries in BLU with FETCH FIRST n ROWS ONLY can hang | |||
| DT245068 | Integrity Problems (IG) | Asynchronous partition detach task reports deadlock with ALTER TABLE | |||
| DT380446 | Abnormal End Of The Program (AB) | Panic when freeing TableAccessor during TRUNCATE TABLE | |||
| DT242525 | System/3 Message (MI) | Interrupt to fmp may generate many harmless error message in db2diag.log | |||
| DT223226 | Abnormal End Of The Program (AB) | Hang and 901 are possible when complex insert from select into a Columnar table is done. | |||
| DT245096 | Abnormal End Of The Program (AB) | Rare trap when columnar organized tables are in use and DB2CDESTMTCACHING reg variable is set. | |||
| DT319206 | A way to block calling of calling of UTLMAIL, UTLSMTP, UTL_TCP by any and all users. | ||||
| DT147755 | Abnormal End Of The Program (AB) | IT41057: SQL0407N RETURNED WHEN RUNNING AN INSERT FROM RTABLE | |||
| DT269735 | Incorrect Output (IN) | db2expln command returns a huge optimizer estimate when queries have a IXAND access plan | |||
| DT245712 | Abnormal End Of The Program (AB) | app heap OOM due to huge runtime section allocations | |||
| DT365905 | Performance (PR) | Large systems doing complex queries on columnar tables might experience performance impact. | |||
| DT389420 | Incorrect Output (IN) | Inserting a big clob from a java/JDBC program corrupts it when using CODESET IBM-850 TERRITORY AT | |||
| DT243612 | Abnormal End Of The Program (AB) | SQL0901N during Columnar HSJN with Additional info: Hash Table cannot accomodate any more keys | |||
| DT209769 | Performance (PR) | Db2 instance stucks reporting SQL1226N The maximum number of client connections are already started. | |||
| DT147951 | Abnormal End Of The Program (AB) | IT41213: QUERY WHICH USES ANY SCALAR FUNCTION AND INVOLVING MQT LEADS TO -901 BAD PLAN UNRESOLVED QNC FOUND. | |||
| DT381542 | Performance (PR) | Poor performance when doing a high number of inserts to column organized tables | |||
| DT386079 | Incorrect Output (IN) | -901 error and FODC_AppErr dump when a datetime result exceeds the valid range of dates | |||
| DT380591 | Abnormal End Of The Program (AB) | INSPECT command on a corrupted column-organized table results brings down the database with error code SQL1224N and FODC_Trap | |||
| DT382454 | Abnormal End Of The Program (AB) | STATEMENTS ON TABLE WITH LOB COLUMNS WITH LARGE NUMBER OF ROWS MIGHT DUMP AND RETURN SQL0901N | |||
| DT381815 | Incorrect Output (IN) | SQL0901N error when selecting from, updating, or deleting from an empty columnar table using the SQL RID(table) function | |||
| DT386505 | Incorrect Output (IN) | Input JSON to JSONTOBSON function not validated for uniqueness before conversion to JSON | |||
| DT387010 | Performance (PR) | Performance issue is possible with extra Flight Recorder information being logged. | |||
| DT386729 | Coded Wait (WS) | Hang due to deadlock between SQLB_BPDbpdLatch and InsertRangemConcurrentInsertLatch when updating a columnar table with LOBs | |||
| DT245948 | Abnormal End Of The Program (AB) | Db2 does not support PKCS#11 OASIS Standard 2.40 version | |||
| DT364123 | Incorrect Output (IN) | Replay of a LOAD COPY image stored in Cloud Object Storage may fail with SQL1092N. | |||
| DT396187 | Incorrect Output (IN) | Intermittent GSKit error 106 from multithreaded Db2 clients when using SSL and an in-memory keystore | |||
| DT366049 | Incorrect Output (IN) | Alter trusted context drop attribute fails with SQL0644N | |||
| DT246813 | Abnormal End Of The Program (AB) | Trusted context DDL hangs in pureScale environment if a trusted context is dropped with audit association before on another connection | |||
| DT247400 | Incorrect Output (IN) | UPDATE DB CFG might return SQL5124N on DPF or PureScale due to an SQL1092N error on a remote node | |||
| DT244530 | Incorrect Output (IN) | Connections using a certificate bundle with simplified SSL might return GSKit error 414 | |||
| DT255389 | Integrity Problems (IG) | GIM Installer is no longer bundled with Db2 | |||
| DT385946 | Loop (LP) | Agent may hang after an abnormal shutdown of Db2 leaving audit file in the middle of audit archive process | |||
| DT247104 | Additional Information (AI) | In Db2 pureScale environment, db2support -db command should automatically collect CAPD.*.thrstk folders | |||
| DT381941 | Incorrect Output (IN) | "db2stop instance on host-name" command could fail with inappropriate error code | |||
| DT246758 | Performance (PR) | Using 'db2support -db | |||
| DT261258 | Performance (PR) | Under RHEL 8.6 operating system, pureScale users may see high CPU usage on their system. | |||
| DT396218 | Abnormal End Of The Program (AB) | CF asserts during member shutdown can cause crash of CF | |||
| DT247105 | Performance (PR) | Db2 pureScale CF hang due to unreleased latch in CF list structure resize causes member FODC | |||
| DT391848 | A CF hang can occur during a gbp page dump from a FODC_INDEX | ||||
| DT354341 | Abnormal End Of The Program (AB) | Database upgrade in a pureScale environment might fail with "SQL0973N Not enough storage is available in the "CFSCASZ" heap or stack to process the statement" | |||
| DT245599 | Abnormal End Of The Program (AB) | Purescale CF may hang while dumping db2cos script information | |||
| DT382117 | Abnormal End Of The Program (AB) | In a pureScale Cluster, database recovery failure can lead to a member panic due to CF timing issue. | |||
| DT270290 | Abnormal End Of The Program (AB) | After an abnormal termination access to database always fails with SQL1042C. | |||
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PknAAE","label":"Install\/Migrate\/Upgrade"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"},{"code":"PF055","label":"zLinux"}],"Version":"12.1"}]
Was this topic helpful?
Document Information
Modified date:
23 June 2025
UID
ibm17175589