Download
Downloadable File
| File link | File size | File description |
|---|---|---|
Abstract
===== Announcement =====
Per the Db2 Update Policy, effective November 2024, updates will only be built on the latest Mod Pack of each code stream.
As a result, the Db2 11.5.8 Update stream has been discontinued.
Published Update 49307 is the final published update for Db2 v11.5.8.
For more information, please review the Db2 documentation page, "Mod packs, fix packs, and updates."
======================
Download the Db2 v11.5.8 Published Update for Db2® for Linux®, UNIX®, and Windows® and Db2® Connect™ products.
Use this page to download a Db2 Update for your installed Db2 product. Db2 Update images are delivered through Fix Central. Updates are cumulative and include all fixes from previous updates.
Links are provided for Db2 Universal, Db2 Server, Db2 Connect, Net Search Extender, Spatial Extender, Query Patroller, Db2 Client, Db2 Run-Time Client, Db2 Wrappers, and all drivers (ODBC, CLI, JDBC, and .NET). Click the Update to view it.
Updates are cumulative. Each update contains all fixes delivered in previous updates.
Updates are listed from most recent to oldest. Therefore, updates listed higher on the page contain all fixes included in the updates listed below them.
Update numbers should not be used to determine chronological order.
Note:
- Updates and the associated KIs (Known Issues) may be revised retroactively.
- Not every update is included in this list.
- Security-related KIs are added only after they have been officially announced.
For more information on Security KIs, please refer to the Published Security Vulnerabilities page.
Download Description
Current Published Update - 49307
Current Security Update - 49307
Update 49307*
2024-10-16
*This is the last Published Update
Linux x86 PTF: DYN2410161516AMD64_49307
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT396293 | Db2 Pacemaker Corosync QDevice - Delete Cluster Domain and Read, but crm cluster status still shows old name | Availability | |
| DT397534 | db2pd -hadr is not reporting SSL_PROTOCOL when HADR_SSL_LABEL is used | Availability | |
| DT396517 | After encountering severe error the database might hang during generating FODC dump. | Availability | |
| DT397334 | LOGICAL_BACKUP stored procedure can be very slow when there are RCAC rules on SYSIBM.SYSTABLES | Availability | |
| DT395068 | With ALSM, db2diag.log file is flooded with informational message related to sqlpLogExtractionScanCB::loggxFlushBufferPool | Availability | |
| DT395722 | 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 | |
| DT394926 | Modify db2pd -hadr so that it no longer obtains a latch | Availability | |
| DT381277 | Rollforward using overflowlogpath fails due to read only access to overflowlogpath. | Availability | |
| DT395376 | Setting TRACEREFRESHINTERVAL attribute to non-zero value in db2cli.ini file leads to memory leak | Client & Connectivity | |
| DT393460 | Replication target table becomes incorrect after TRUNCATE IMMEDIATE is executed on a source database in a DPF environment | Data Management | |
| DT392298 | db2hmon waiting in Pending remote request | Data Management | |
| DT395876 | ADMIN_MOVE_TABLE might fail with SQL0668N RC 10 on pureScale | Data Management | |
| DT393022 | Fix XML query missing closing bracket ">" on DPF settings | Data Management | |
| DT396121 | 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. | Federation | |
| DT397544 | Possible replicated dataloss on DPF when a streamed transaction contains a savepoint rollback because of a statement-level SQL error | IIDR | |
| DT394335 | Q Capture incorrectly replicates a row that is rolled back because of duplicate key violation | IIDR | |
| DT398397 | RESTORE OR CREATE DATABASE MAY FAIL WITH ERROR ECF_INVALID_INVOCATION_SEQUENCE | Operating System Services | |
| DT395088 | "warning: direct reference to protected function" messages may appear when running Db2 executables on zLinux SUSE 15 SP6 | Problem Determination Tooling | |
| DT396594 | TAB_FILE_ID is inconsistent between mon_get_table and mon_get_locks | Process Model | |
| DT394169 | An instance crash may occur during event monitor activation if there is insufficient memory in the Database Monitor Heap (MON_HEAP_SZ) | Process Model | |
| DT395723 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-45663) | Query Compiler | |
| DT391472 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-41761) | Query Compiler | |
| DT390381 | Wrong results due to Incorrect SMP parallelization strategy using UNIQUE and NLJOIN operators | Yes | Query Compiler |
| DT398441 | SQL error SQL0901N with reason "unexpected error at TimeStamp.cpp:3395" | Runtime | |
| DT397374 | 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 | Runtime | |
| DT390024 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-41762) | Runtime | |
| DT380744 | Rare sigsegv when HSJN is done in Columnar logic on Columnar Tables | Runtime | |
| DT391915 | Unable to form HADR connection in STRICT_FIPS when only TLSV12 is specified in SSL_VERSIONS | Security | |
| DT396218 | CF asserts during member shutdown can cause crash of CF | pureScale |
Update 42302
2024-08-21 Linux x86 PTF: DYN2408212059AMD64_42302
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT392504 | dump.bin file is generated when ReadLog API receives interrupt with -1044 | Availability | |
| DT379096 | HADR standby log replay is slow when retrieving log files from archive | Availability | |
| DT391437 | The current value of MAX_LOG is not displayed correctly in db2diag.log message when the MAX_LOG limit is reached | Availability | |
| DT386990 | ForceDBShutdown due to "Invalid backlso, it should be 0 for the first log record of a new transaction." | Availability | |
| DT383079 | Running db2cm commands such as 'db2cm -create -cluster' with db2locssh fail | Availability | |
| DT390383 | Security: IBM® Db2® is vulnerable to an information disclosure under specific conditions (CVE-2024-40679) | Availability | |
| DT394248 | db2cat cannot cleanup sysibm.sysrel orphan rows | Catalog Services | |
| DT389438 | list active database command does not show SQL1611W even if no database is activated | Client & Connectivity | |
| DT381010 | Write suspend can fail timing out waiting due to contention on latch suspendIOCBLatch | Data Management | |
| DT385994 | Memory leak running LOAD with STATISTICS USE PROFILE after RUNSTATS with distribution set profile only | Data Management | |
| DT382287 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-37071) | Federation | |
| DT380061 | Apply RECVQ gets stuck on ADDCOL when there is an open streaming transaction | IIDR | |
| DT393441 | Capture should deactivate subscriptions if drop column statement is detected on LUW | IIDR | |
| DT394030 | Fix for truncate immediate being rolled back | IIDR | |
| DT393194 | Oracle Capture should not terminate if a new column is added into a source table | IIDR | |
| DT389938 | Q Apply should support External Table Load (LOAD_TYPE 7) when the source table is row organized | IIDR | |
| DT381798 | Q Capture should deactivate the associated subscriptions if the external table file size on disk does not match what was logged by db2 | IIDR | |
| DT390507 | Q Apply does not generate data file correctly for Oracle sqlldr with expressions | IIDR | |
| DT390155 | Q Apply crashes in conflict retry logic on a spilled row | IIDR | |
| DT389778 | The Q subscription “STATE” of the source and target is inconsistent after user incorrectly changes SEARCH_CONDITION directly in the IBMQREP_SUBS table | IIDR | |
| DT393449 | Backup/Restore operations may abort due to SQLO_ADDR_CONFLICT error of db2vend process. | Operating System Services | |
| DT392571 | Event Monitor application handle may be stuck in Pending remote request on pureScale or DPF systems. | Process Model | |
| DT387634 | Calling the EVMON_FORMAT_UE_TO_TABLES procedure may take time and it cannot be forced | Process Model | |
| DT393202 | low selectivity estimate of IS NULL predicates results in less optimal plan execution | Query Compiler | |
| DT393612 | Db2 Query may Trap when MQT has aggregation | Query Compiler | |
| DT392170 | Memory overwrite when compiling a query that joins multiple column-organized tables with complex join predicates | Query Compiler | |
| DT261460 | A query referencing column-organized tables may perform sub-optimally when selecting from a scalar subquery within a common-table-expression | Query Compiler | |
| DT178408 | ROUND unable to provide correct result for double at precision value of 4 | Runtime | |
| DT391657 | In rare condition sort queries in BLU with FETCH FIRST n ROWS ONLY can hang | Runtime | |
| DT390433 | db2trc fmt SEGV in pdSQRAFormat_token_list() | Runtime |
Update 43143
2024-06-13 Linux x86 PTF: DYN2406131532AMD64_43143
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT383007 | Security: Db2 is vulnerable to a denial of service when querying certain tables using a specially crafted statement (CVE-2024-35152) | Client & Connectivity | |
| DT381265 | Indexes on tables created by ALTER TABLE ... DETACH PARTITION ... are not owned by the Authorization ID that executed the ALTER TABLE statement. | Data Management | |
| DT382279 | CALLING MON_GET_PKG_CACHE_STMT MAY FAIL WITH ERROR SQLO_BUFF_TOO_SMALL | Data Management | |
| DT380323 | Security: Db2 federated server is vulnerable to denial of service with a specially crafted query under certain conditions (CVE-2024-35136) | Federation | |
| DT386800 | Replication Center can't show unique index for Oracle federation target table when creating Q Subscription | IIDR | |
| DT382046 | Deactivate subscription if DCC is turned off while Capture is running for an active subscription | IIDR | |
| DT387275 | In a pureScale environment, db2diag.log can be flooded with "Received outdated RPC sync CB, resending state info to coordinator" messages | Process Model | |
| DT385986 | FODC_Trap in AppStartUsing() function during database start | Process Model | |
| DT386395 | Security: Db2 is vulnerable to a denial of service with a specially crafted query (CVE-2024-37529) | Query Compiler | |
| DT387288 | FIXPACK UPDATE MAY LEAD TO ERROR SQL901N | Query Compiler | |
| DT260622 | Wrong result might be produced when computing antijoin with shadow tables enabled | Query Compiler | |
| DT365374 | Security: Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted query on columnar tables in a database partitioned environment (CVE-2024-31882) | Query Compiler |
Update 42458
2024-05-22 Linux x86 PTF: DYN2405221658AMD64_42458
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT378347 | "The registry does not exist" error message in db2diag.log for db2instanceinfo.reg file | Availability | |
| DT366161 | Update outdated apache-mime4j-core jar. | Client & Connectivity | |
| DT148397 | IT37721: LOAD INTO SMALL MDC TABLE MAY FAIL IN SQLBPURGEORFLUSHALLPAGESINSMALLRANGE, MAY CAUSE DB SHUTDOWN AND CRASH RECOVERY FAILURE | Data Management | |
| DT365991 | Possible SQL0901N when adding a new key to an index | Data Management | |
| DT381034 | 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. | Yes | Data Management |
| DT379179 | Possible memory corruption in some rare situations when space is freed on a page by a delete or update operation | Data Management | |
| DT378207 | Error message in db2diag.log can be ignored (sqldProcessIxmSettingsRegVar, probe:5495) | Data Management | |
| DT381851 | Security: Db2 federated server is affected by a vulnerability in an open source library bcprov-jdk18on (CVE-2024-30171, CVE-2024-30172) | Federation | |
| DT386586 | Security: Db2 is affected by a vulnerability in the open source netty-codec library. (CVE-2024-29025) | Federation | |
| DT380983 | Security: Db2 is affected by vulnerabilities in the open source commons-configuration2 library. (CVE-2024-29131, CVE-2024-29133) | Federation | |
| DT380381 | Federation: SQL0901N error "bad outer compare" | Federation | |
| DT364021 | SELECT ... UNION SELECT DIGITS(c1) ... ORDER BY MAY RETURN AN INCORRECT ORDER | Federation | |
| DT383101 | Q Capture should allow the use of wildcards for schema/table name in IBMQREP_EXCLSCHEMA | IIDR | |
| DT365075 | Replication Center(RC) makes a garbled character for value of IBMQREP_SUBS table's HAS_PARTS column in UPDATE statement, when adding a column for replication. | IIDR | |
| DT380453 | Add the SQLRep migration scripts into 1140 | IIDR | |
| DT365587 | Q Capture with LOGREAD_PREFETCH=Y loops and repeatedly issues ASN0193W if error during startup, even if TERM=Y, instead of coming down. | IIDR | |
| DT378635 | ASNCLP with "INCLUDE HISTORY" option for temporal tables is resulting in the error of SQLCODE=-20490. | IIDR | |
| DT382327 | Update database manager configuration can succeed for MULTIPARTSIZEMB configuration parameter outside the allowable range on pureScale | Process Model | |
| DT380557 | Rolling updates installfixpack -commit_level can fail if upgrading from before/on v1157 to versions after/on v1157 with SQL1648 | Process Model | |
| DT381749 | Trap when subquery predicate used with OR | Query Compiler | |
| DT365623 | 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) | Query Compiler | |
| DT378893 | SUBSTR expression on column-organized table fails with -901 "unexpected error at MinMaxPartialEvaluator.cpp" | Query Compiler | |
| DT365596 | Security: Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted statement (CVE-2024-31880) | Query Compiler | |
| DT179938 | Security: Db2 is vulnerable to a denial of service as a trap may occur when selecting from certain types of tables (CVE-2023-29267) | Query Compiler | |
| DT269502 | Db2 query may show poor performance when Group By is applied before joining on Group by Columns | Query Compiler | |
| DT363633 | FODC_AppErr on LeafPredicateEvaluator::processTSNRange then FODC_Trap on PackedBankSIMD caused instance to crash | Runtime | |
| DT380591 | INSPECT command on a corrupted column-organized table results brings down the database with error code SQL1224N and FODC_Trap | Runtime | |
| DT380446 | Panic when freeing TableAccessor during TRUNCATE TABLE | Runtime | |
| DT270401 | Db2 11.5.8. CDE query fails with AssertionFailedException Thrown at JoinSpillInfo.cpp : 4342 | Runtime | |
| DT377867 | Assertion "'mInitializedForRowLogging' failed: Row logging must be initialized before starting" in columnar table using replication | Runtime | |
| DT365905 | Large systems doing complex queries on columnar tables might experience performance impact. | Runtime | |
| DT382117 | In a pureScale Cluster, database recovery failure can lead to a member panic due to CF timing issue. | pureScale |
Update 40526
2024-03-28 Linux x86 PTF: DYN2403282145AMD64_40526
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT258947 | 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 | Availability | |
| DT244994 | Multiple instances in mutual failover pacemaker environment, unexpectedly fail back after move | Availability | |
| DT260869 | LOGICAL_BACKUP stored procedure fails due to file system full error (SQL0968C) on a temporary table space when taking an incremental or delta backup. | Availability | |
| DT260706 | db2start segfaults on AIX when registry variable to skip TSA license check is set | Availability | |
| DT260136 | db2start fails when run as SYSADM user after updating SSH on Db2 pureScale | Availability | |
| DT259070 | Db2 Restore fails with SQL2530N because size of history file included in backup image is larger than 4G | Availability | |
| DT259213 | HADR SSL support is not picking up SSL_CIPHERSPECS setting to restrict to TLS 1.3 | Availability | |
| DT258934 | LOGICAL_BACKUP/LOGICAL_RESTORE fails on single database partition system with SQL1797N if db2nodes.cfg file exits | Availability | |
| DT258270 | Database is not activated on one of pureScale cluster after another member has successfully executed START HADR | Availability | |
| DT260618 | db2cat not generating Packed descriptors with correct codepages properly | Catalog Services | |
| DT222975 | 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 | Catalog Services | |
| DT259092 | Db2look missing SET CURRENT SCHEMA statements for variable DDL in output | Catalog Services | |
| DT259752 | Security: Db2 is vulnerable to a denial of service when a specially crafted request is used via CLI (CVE-2023-45178) | Client & Connectivity | |
| DT364325 | db2fmtlog not formatting "Delete LOB data" and "Non-update LOB data" log records | Data Management | |
| DT270239 | ADM5530W (COMMIT processing of table that used NOT LOGGED INITIALLY) messages reported in db2diag.log | Data Management | |
| DT270146 | SQL0901N when an XML column has been dropped from a table | Data Management | |
| DT259276 | LOAD and IMPORT with lob filename of 1 character only, rejects row with SQL3229W | Data Management | |
| DT260764 | Page Cleaner may lose track of outstanding IOs after transient IO error | Data Management | |
| DT246746 | Invalid XML from MON_GET_PKG_CACHE_STMT with FOR BIT DATA | Data Management | |
| DT259443 | Using DB2_USE_ALTERNATE_PAGE_CLEANING might, over time, clean dirty pages more aggressively than expected | Data Management | |
| DT258165 | ADMIN_GET_TAB_INFO reports LOB/XML sizes as zero while ADMIN_MOVE_TABLE is in progress | Data Management | |
| DT258225 | Disable message queue creation in db2licd which has been discontinued | Deployment | |
| DT261574 | Security: Db2 is affected by a vulnerability in an open source library zlib (CVE-2023-45853) | Deployment | |
| DT258954 | db2installPCMK fails when updating from db2 image with pcmk-docs to one without | Deployment | |
| DT276372 | Update outdated json-path jar. | Federation | |
| DT276378 | Security: Db2 federation is affected by vulnerabilities in an open source library commons-compress (CVE-2023-25710, CVE-2024-26308) | Federation | |
| DT276243 | Some Federation db2fmp thread cannot be reused if user mapping plugin is enabled | Federation | |
| DT261886 | SYSPROC.NNSTAT traps in _IO_vfprintf function call | Federation | |
| DT269538 | Enabling two phase commit on DRDA datasource wrong results returned | Federation | |
| DT260107 | The SQL statement or command failed with SQL901 and reason lock not owned by caller | Federation | |
| DT258875 | Interrupt Federation NOSQL queries returns error code SQL1476N | Federation | |
| DT258536 | Undefined user tenant receives SQL0270N Function not supported (Reason code = "125") when federating to Db2 for z/OS | Federation | |
| DT261299 | SQL Apply ASNLOAD.exe crashes | IIDR | |
| DT261339 | Q Apply TOLERATE_PARTIAL_TRANS=Y should tolerate not 1st trans seq -> TXS error | IIDR | |
| DT260640 | Spill to file code fix in Q Capture when transaction has rollback to savepoint | IIDR | |
| DT245411 | SEARCH_CONDITION does not filter data properly | IIDR | |
| DT258156 | SQL Apply exposes error ASN1001E if we specify COMMIT COUNT value when creating subscription set | IIDR | |
| DT259072 | The Replication Alert Monitor only generated the ASN5157W alert when one Q subscription is in inactive and STATE_INFO is not NULL | IIDR | |
| DT255120 | Set PRUNE_BY_CORRELID default to N when Q Apply is using MQ Client to access local queue on z/OS | IIDR | |
| DT270233 | DIO with NFS should be restricted to READWRITE/WRITEONLY | Operating System Services | |
| DT261306 | SQL1652N File I/O error occurred returned on db2start or db2stop in DPF | Operating System Services | |
| DT258849 | db2support debug information enhancement for db2look output generation failure | Problem Determination Tooling | |
| DT246510 | SQLO_LT_sqm_control__mes_latch Contention in Heavy Workloads with System Temp Tables | Process Model | |
| DT270063 | IN PURESCALE WHEN AN APP RECEIVES SQL0997W MESSAGES ARE LOGGED WITH LEVEL SEVERE/ERROR THAT SHOULD BE INFORMATIONAL | Process Model | |
| DT269842 | AUTOMATIC FCM_PARALLISM computation can set a value greater than the maximum allowed configuration value | Process Model | |
| DT260491 | Possible trap in pdCreateDirFODC | Process Model | |
| DT259129 | Deadlatch on SQLO_LT_SQLP_DBCB__add_logspace_sem is possible when using threshold violation event monitors and wlm thresholds | Process Model | |
| DT270076 | Security: Db2 is vulnerable to a denial of service with a specially crafted query under certain conditions (CVE-2024-28762) | Query Compiler | |
| DT271456 | 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 | Query Compiler | |
| DT269553 | Db2 COMPLEX QUERY WITH IN LIST PREDICATE FAILS WITH SQL0901N | Query Compiler | |
| DT224146 | -901 error might be thrown when there are AVG functions inside complex CSEs (Common Subquery Expressions) | Query Compiler | |
| DT259574 | -901 "Inc bind section statement changed!" and FODC_AppErr after applying Update | Query Compiler | |
| DT237759 | A Db2 query may generate a SQL 901 when using an aggregate function on an expression | Query Compiler | |
| DT258141 | Security: Db2 is vulnerable to a denial of service with a specially crafted query on certain columnar tables (CVE-2024-22360) | Query Compiler | |
| DT239365 | Db2 produce FODC Apperr with sql code -901 and SQLNQ_CONVERTNODE 010 when wrong syntax query is run | Query Compiler | |
| DT276989 | VARCHAR_FORMAT() support for DECFLOAT | Runtime | |
| DT269735 | db2expln command returns a huge optimizer estimate when queries have a IXAND access plan | Runtime | |
| DT269600 | varchar_format support for decfloat | Runtime | |
| DT260082 | Query a nickname may get hang when DB2_MAX_THREADS_PER_FMP is set | Runtime | |
| DT257175 | Return code get can overwritten in message from sqlerCallDL in db2diag.log | Runtime | |
| DT261311 | FMP Trap due to wrong pd macro | Runtime | |
| DT259814 | Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2024-25046) | Runtime | |
| DT256910 | An assertion hit by running runstats might cause the runstats command to hang | Runtime | |
| DT259502 | Memory leak or high memory usage in Db2 Server when using "CURRENT TIMEZONE" syntax with monitor functions (MON_xxx) | Runtime | |
| DT259530 | SQL0954C error code returned when access plan has a HSJN with BTQ | Runtime | |
| DT258155 | Db2 server may report -902 and database marked bad | Runtime | |
| DT258264 | PSM Procedures fails interpreting with external interrupts, results in endless cycle of rollback | Runtime |
Update 38086
2024-01-12 Linux x86 PTF: DYN2401122057AMD64_38086
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT236714 | Old HADR primary database hung after receiving forced takeover request | Availability | |
| DT246349 | Orphaned transaction on DPF subordinator node after communication failure during COMMIT processing | Availability | |
| DT247162 | HADR STANDBY ENTERS AN INFINITE LOOP BETWEEN READ FROM MEMORY AND READ FROM DISK | Availability | |
| DT237982 | DELETE from ORC ACID Hadoop table fails to delete all matching rows | Big SQL | |
| DT258452 | Hang during query compilation | Catalog Services | |
| DT245442 | FODC_AppErr error with segmentation fault when Packed Descriptor is NULL | Catalog Services | |
| DT255114 | Security: Db2 JDBC driver is vulnerable to an insecure cryptographic algorithm and to information disclosure in stack trace under exceptional conditions. (CVE-2023-47152) | Client & Connectivity | |
| DT256842 | Security: Db2 is vulnerable to denial of service when querying a specific UDF built-in function concurrently (CVE-2023-52296) | Client & Connectivity | |
| DT256818 | Update outdated xstream jar | Client & Connectivity | |
| DT246121 | SQL2048N might wrongly be raised on a backup operation when registry DB2_BCKP_PAGE_VERIFICATION=TRUE | Data Management | |
| DT247235 | ADMIN_MOVE_TABLE SWAP might fail with SQL2105N RC=11 | Data Management | |
| DT247759 | DB2 MAY TRAP DURING LOCK ESCALATION | Data Management | |
| DT257083 | Certain database activation failures can leak memory | Data Management | |
| DT246538 | Replay of extent movement may result in abnormal tablespace state | Data Management | |
| DT246182 | A bad page error might be encountered when inserting data into a table with a clustering index after a REORG shrunk the table size. | Data Management | |
| DT246439 | Incorrect units listed in Performance Metrics of Extent Movement in DB2DIAG | Data Management | |
| DT256803 | Security: Db2 is vulnerable to a privilege escalation due to improper file permissions on Windows (CVE-2023-47145) | Deployment | |
| DT257584 | NNSTAT reports SQL20274W error | Federation | |
| DT253655 | Permit distinct is added in wrong place in remote statement for outjoin | Federation | |
| DT253570 | IN DB2 FEDERATED CERTAIN PREDICATE OPTIMIZATION DO NOT APPLY IN PRESENCE OF NICKNAMES. | Federation | |
| DT254946 | Federated queries against Db2 for z/OS experience truncation issues with character columns | Federation | |
| DT253559 | Rollback of operations on nickname cause database hang | Federation | |
| DT247476 | Db2diag.log fills with lost of warning messages that relate to drop_server | Federation | |
| DT246476 | COLUMN LENGTH OF A NICKNAME UNEXPECTEDLY EXTENDS BY A FACTOR OF 4 WHEN THE REMOTE COLUMN IS CODEUNIT32. | Federation | |
| DT257883 | Update migration script for Oracle capture and support options for new control tables on SQLRep | IIDR | |
| DT255449 | In ASNCLP, we needn't check each Db2 version 10,11...just need to check if the version number is bigger than 10 | IIDR | |
| DT237964 | Q Apply Initial Load fails on Generated Always Row Organized tables with ASN7597E and SQL3107 rows rejected | IIDR | |
| DT247445 | For SQL Replication, we should keep column options "NOT NULL WITH DEFAULT" when altering CD table | IIDR | |
| DT247507 | We need to detect Db2 z/os version in ASNCLP, different version has different behavior. | IIDR | |
| DT247802 | Finding transaction ID for QApply to use in skip trans | IIDR | |
| DT246371 | 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 | IIDR | |
| DT245070 | ASN2100E occurs when CREATE QSUB with source column name length exceed 30 chars for Oracle target. | IIDR | |
| DT245447 | Add SQLRep missing columns for upgrade scenarios. | IIDR | |
| DT247998 | Cannot add new member in PureScale due to memory address conflict error | Process Model | |
| DT247203 | Db2 Trap in sqleWLDContinueSpin() | Process Model | |
| DT257192 | Db2 CLI and ODBC function SQLColumns might require a long time to compile if FUNCTION PATH doesn't start with SYSIBM schema | Query Compiler | |
| DT246413 | External procedure invocation may fail with SQL0204N after dropping and recreating dependent table and auto_reval=disabled | Query Compiler | |
| DT254942 | Poor performance due to unexpected filter factor | Query Compiler | |
| DT246499 | Security: Db2 is vulnerable to a denial of service when a specially crafted query is used (CVE-2023-47746) | Query Compiler | |
| DT255491 | varchar_format prefixing with 0 when the number is passed in exponential format resulting in inconsistent output | Runtime | |
| DT257996 | SQL0180N WHEN USING CASE EXPRESSION WITH COLUMNAR TABLE | Runtime | |
| DT255196 | 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 | Runtime | |
| DT148274 | 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) | Runtime | |
| DT255389 | GIM Installer is no longer bundled with Db2 | Security | |
| DT245948 | Db2 does not support PKCS#11 OASIS Standard 2.40 version | Security | |
| DT247400 | UPDATE DB CFG might return SQL5124N on DPF or PureScale due to an SQL1092N error on a remote node | Security | |
| DT247105 | Db2 pureScale CF hang due to unreleased latch in CF list structure resize causes member FODC | pureScale | |
| DT247104 | In Db2 pureScale environment, db2support -db command should automatically collect CAPD.*.thrstk folders | pureScale | |
| DT246758 | Using 'db2support -db | pureScale | |
| DT245599 | Purescale CF may hang while dumping db2cos script information | pureScale |
Update 37208
2023-11-17 Linux x86 PTF: DYN2311171420AMD64_37208
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT245323 | LOGICAL_BACKUP stored procedure for incremental multi-schema backup with -tsm/-s3/-cos option fails with SQL1797N | Availability | |
| DT245947 | "Node" field in db2cm -list incorrectly shows primary VIP online on standby node after takeover. | Availability | |
| DT243562 | Database recovery is slow while multiple edus are waiting on transsem latch | Availability | |
| DT242860 | Incorrect Output When Running db2level as Non-instance Owner Id in pureScale | Availability | |
| DT189371 | db2cleancat fails with SQL0100W even though orphan rows are reported | Catalog Services | |
| DT244554 | Catalog DCS directory command allows db name to be more than 8 characters but fails to uncatalog the same. | Client & Connectivity | |
| DT241645 | FODC_Trap happened when running XA transaction in purescale unfenced DRDA wrapper | Client & Connectivity | |
| DT224833 | Security: Unauthorized access to data vulnerability in ADMIN_CMD. (CVE-2023-38729) | Data Management | |
| DT245652 | EDUs can hang while unlatching a page with DB2_USE_PAGELATCH_TRACKING enabled | Data Management | |
| DT236825 | ForceDBShutdown during undo in pureScale after failed CREATE INDEX statement | Data Management | |
| DT244515 | HADR standby in pureScale environment failed with SQLB_NO_MEMORY error when replaying ALTER BUFFERPOOL operation | Data Management | |
| DT241777 | IMPORT on Db2 Federation nickname might cause SQL0440N Error. | Federation | |
| DT245187 | Db2 federation reports SQL0901N The SQL statement failed (Reason "Unhandled data type".) when querying nickname decimal values with single quote. | Federation | |
| DT245747 | An update on nickname set column = null, might report a DB21034E message with an embedded SQL604 indicating “CHAR(0 OCTETS)” is not valid | Federation | |
| DT247610 | CREATE NICKNAME might cause SQL1822N Unexpected error code Error with ODBC Wrapper | Federation | |
| DT239700 | Security: Db2 Federated is affected by vulnerabilities in multiple opensource libraries | Federation | |
| DT244749 | Using bulk insert feature to insert data into nicknames might result in Trap | Federation | |
| DT238103 | Security: Db2 federated server is vulnerable to a denial of service when a specially crafted cursor is used (CVE-2023-45193) | Federation | |
| DT244328 | Query teradata nikcname reports SQL0901N error | Federation | |
| DT239508 | A query fails with SQL0901N (Reason "NULL SAT pointer") | Federation | |
| DT245558 | Asnmail program crashed on Windows platform | IIDR | |
| DT245039 | Q Capture crashes when run with debug in a dpf environment during publishing of streamed transactions | IIDR | |
| DT245324 | Q Apply internal load for columnar table fails with SQL-303 when there are FOR BIT DATA columns | IIDR | |
| DT238210 | STALE and WARNTXSZ value set in IBMSNAP_CAPPARMS are not picked up even after a restart of SQL Capture | IIDR | |
| DT244881 | Keep Capture_truncate default value as 'W' . | IIDR | |
| DT243412 | asntdiff crashes on Windows platform | IIDR | |
| DT245132 | Db2 thread may hang when a signal handler is called during the invocation of localtime_r function | Process Model | |
| DT221786 | Security: Db2 is vulnerable to a denial of service when using a specially crafted query (CVE-2023-47747) | Query Compiler | |
| DT244409 | Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2023-47141) | Query Compiler | |
| DT243869 | Compilation of complex query might result in segv trap with sqlno_alloc_hash_table | Query Compiler | |
| DT246562 | Assertion failure "Offset into table accessors list is bad" when truncating a columnar table | Runtime | |
| DT246563 | Security: Db2 is vulnerable to a denial of service when a statement is run on columnar tables under specific conditions (CVE-2023-50308) | Runtime | |
| DT246565 | Message SQL0913N with reason code 80 and message "Unable to get insert range for table" in db2diag.log | Runtime | |
| DT245904 | SQL1042C error reported with SQLJ.RECOVERJAR and SQLJ.INSTALL_JAR for WINDOWS | Runtime | |
| DT246556 | the fix for DT245096 introduced a different second problem | Runtime | |
| DT245279 | POSSIBLE CORE FILE, TRAP WITH CORRUPTED STACK GENERATED BY DB2FMP WHEN QUERY IS INTERRUPTED | Runtime | |
| DT246502 | The fix for DT245096 introduced a different problem | Runtime | |
| DT245712 | app heap OOM due to huge runtime section allocations | Runtime | |
| DT245096 | Rare trap when columnar organized tables are in use and DB2_CDE_STMTCACHING reg variable is set. | Runtime | |
| DT244709 | Specifying a value outside the column range for the SUBSTR scalar function in CDE query may result in a SQL0901N | Runtime | |
| DT245068 | Asynchronous partition detach task reports deadlock with ALTER TABLE | Runtime | |
| DT244628 | Rare 901 with SORT using FETCH FIRST N ROWS or LIMIT in columnar engine | Runtime | |
| DT238876 | MPP instance might crash with SIGFPE (signal 8) - FODC_Trap is generated | Runtime | |
| DT243538 | SQLO_SLATCH_CAS64::getConflictComplex reports corrupt latch when releasing extended insert range as part of truncate table | Runtime | |
| DT243612 | SQL0901N during Columnar HSJN with Additional info: Hash Table cannot accomodate any more keys | Runtime | |
| DT245990 | CHANGE THE DEFAULT TLS VERSION TO TLS 1.2 | Security | |
| DT244530 | Connections using a certificate bundle with simplified SSL might return GSKit error 414 | Security |
Update 36040
2023-10-10 Linux x86 PTF: DYN2310101835AMD64_36040
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT241626 | db2cm reports instance does not exist during db2 -create -instance for the remote host when using db2locssh | Availability | |
| DT239457 | Slow performance during database recovery when replaying transactions using DGTT tables | Availability | |
| DT225334 | db2vend.C generates logs when executing db2cluster -cm -list -HOSTFAILUREDETECTIONTIME | Availability | |
| DT237784 | Rollback of transaction on event monitor table is not deferred on HADR TAKEOVER | Availability | |
| DT240634 | Performance degradation after member crash recovery with in-doubt transactions | Availability | |
| DT215935 | Host time going backwards causes purge in connections | Availability | |
| DT237799 | ROLLFORWARD OF DATABASE RESTORED FROM SNAPSHOT BACKUP MAY FAIL WITH AN UNEXPECTED CONDITION | Availability | |
| DT237077 | Table space not set to ROLLFORWARD PENDING state when it was not accessible during crash recovery | Availability | |
| DT238214 | HADR_REMOTE_HOST changed from hostname string to IP address after takeover in HADR with multiple standbys environment | Availability | |
| DT238513 | Security: Db2 is affected by vulnerabilities in compression routines (zlib) | Availability | |
| DT237938 | logical_backup stored procedure with -tsm option fails with SQL1797N | Availability | |
| DT236712 | Starting HADR as primary in pureScale failed with ADM12509E reason code 6 | Availability | |
| DT238609 | FODC_Panic from db restart/start due to SYSBOOT open error | Catalog Services | |
| DT237745 | LOGICAL_BACKUP stored procedure fails with error SQL1797N "Unable to extract schema object ddl for schema " | Catalog Services | |
| DT239599 | Security: Db2 is vulnerable to a denial of service when a specially crafted request is used via CLI (CVE-2023-45178) | Client & Connectivity | |
| DT241481 | Windows only, type2 LUW connection fails with com/ibm/db2/jcc/uw/UWConnection.DBForceDisconnect(JIZZ) | Client & Connectivity | |
| DT228852 | Security: Db2 federated server is vulnerable to a denial of service when executing LOAD under certain conditions (CVE-2024-27254) | Client & Connectivity | |
| DT241187 | Remove XML Extenders since it was discontinued in v9.7 | Data Management | |
| DT147957 | IT41481: RUNSTATS CALCULATES PCTINLINED INCORRECTLY WHEN USING TABLE SAMPLING | Data Management | |
| DT238088 | Automatic maintenance (db2acd) process may generate "hmonSQLConnect, probe:600 sqlcode=-1035" Error message every 5 minuets on db2diag.log while taking an offline backup | Data Management | |
| DT178438 | Performance Issue for Windows NT Db2 DSDriver | Deployment | |
| DT240673 | Join CDE table with nickname returns SQL1822N "SQL type not supported: 256" | Federation | |
| DT237800 | Federation returns SQL0901N “Bad Data type” when remote PostgreSQL has unique index on BYTEA column | Federation | |
| DT238497 | Create Teradata nickname failed with SQL0204N | Federation | |
| DT237766 | Federated query performance degradation when DB2_MAXIMAL_PUSHDOWN is set to ‘Y’ by default | Federation | |
| DT238900 | Q Apply should not activate range partition subscriptions if there are any rejected rows during the initial load | IIDR | |
| DT238517 | On Unix and Windows platforms, ASNCLP expose error ASN1551E when creating SQL capture control tables if we specify the UOW keyword | IIDR | |
| DT225087 | asnmon getting sql0803n after setting DB2_COMPATIBILITY_VECTOR=ORA | IIDR | |
| DT242834 | Security: PCRE opensource library affected by multiple vulnerabilities | Process Model | |
| DT215999 | Contention on dbMgrLatch with many client connection termination | Process Model | |
| DT211904 | db2evmonfmt can fail with with DB2 SQL Error: SQLCODE=-20377 | Process Model | |
| DT237788 | Possible SQL hang or node trap on v11.5.9 DPF environment when with hold cursors are used. | Process Model | |
| DT222859 | Security: Specially crafted statement results in abnormal termination of Db2 server (CVE-2023-38727) | Query Compiler | |
| DT215667 | Security: Specially crafted ALTER TABLE may cause abnormal termination of Db2 server (CVE-2023-38720) | Query Compiler | |
| DT211674 | Security: Db2 is vulnerable to denial of service with a specially crafted RUNSTATS command on an 8TB table. (CVE-2023-40687) | Query Compiler | |
| DT238314 | In complex queries using OLAP function first_value on column ordered tables, in MPP systems, may encounter a trap. | Query Compiler | |
| DT189592 | SYSCAT.DATAPARTITIONS contains incorrect statistics values for column-organized tables | Query Compiler | |
| DT222991 | The SYSSTAT.TABLES.FPAGES statistic is sometimes inconsistent with NPAGES and MPAGES | Query Compiler | |
| DT212934 | Security: Db2 is vulnerable to denial of service with a specially crafted query containing common table expressions (CVE-2023-40373) | Query Compiler | |
| DT237459 | SQL0901 "Empty plan list detected!" when compiling query with full outer join | Query Compiler | |
| DT228461 | THE FILTER FACTOR WILL NOT BE ADJUSTED TO THE REQUESTED VALUE SPECIFIED BY THE SELECTIVITY CLAUSE | Query Compiler | |
| DT222637 | SYSTOOLS.MESSAGES is not created in the specified table space | Query Compiler | |
| DT242525 | Interrupt to fmp may generate many harmless error message in db2diag.log | Runtime | |
| DT239550 | The package cache daemon leaves locks behind with DB2_VARLOCK_VARIANT_ENABLE enabled | Runtime | |
| DT238478 | CDE Query fails with SQL0901N AssertionFailedException Thrown at Scheduler.cpp : 7525 | Runtime | |
| DT239479 | PROCEDURE | Runtime | |
| DT238735 | INSTANCE MAY TRAP WITH POSSIBLE MEMORY CORRUPTION DETECTED | Runtime | |
| DT228229 | Db2 takes long time to dump diagnostics to the first occurrence data capture (FODC) directory | Runtime | |
| DT238133 | CREATE PROCEDURE | Runtime | |
| DT227816 | Db2 is missing rows inserted into table using QRep | Runtime | |
| DT236913 | A SELECT STATEMENT WITH CSE MAY HANG | Runtime | |
| DT196678 | Security: Db2 is vulnerable to remote code execution caused by installing like named jar files across multiple databases (CVE-2023-27859) | Runtime | |
| DT242608 | FODC_Panic might be generated when inserting characters longer than the target column length | SQL Compatibility | |
| DT240334 | Pacemaker docs are being removed due to using an outdated opensource library. | Security | |
| DT236965 | Security: A vulnerability in libqb affects Db2 High-Availability deployments using Pacemaker (CVE-2023-39976) | Security | |
| DT238702 | When an SSL error occurs, Db2 might only return an error code in the diagnostic log rather than a message | Security | |
| DT224740 | Security: In certain cases users with DATAACCESS authority can execute routines they are not authorized to (CVE-2023-38003) | Security | |
| DT238653 | db2cm command returns list of parameters and it includes invalid parameter for Mutual Failover environment. | pureScale | |
| DT238311 | Db2 pureScale members got trapped at libdb2cf_api.so.1 CF library | pureScale | |
| DT223903 | Add a functionality to collect additional diagnostic data for a connection purge problem. | pureScale |
Update 33830
2023-08-25 Linux x86 PTF: DYN2308250039AMD64_33830
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT228165 | ROLLFORWARD COMMAND MAY HANG WITH LOW DBHEAP MEMORY | Availability | |
| DT224265 | When running an online backup with EXCLUDE LOGS option and with DB2_DISABLE_FLUSH_LOG setting enabled, backup gets completed successfully but db2diag.log shows "DIA8414C Logging can not continue due to an error" message. | Availability | |
| DT224539 | Primary database hangs while starting HADR on standby in pureScale. | Availability | |
| DT214526 | High number of locked objects and lock waits on CatCacheLock - on table SYSIBM.SYSUSERAUTH | Catalog Services | |
| DT224696 | db2support collection hangs when there are indoubt transactions | Client & Connectivity | |
| DT236621 | More than 350 EINVAL (22) "Invalid argument" LEVEL: Error (OS)[] errors is returned when you pipe the output of a DB2 command to the head operating system command | Client & Connectivity | |
| DT224887 | Memory Leak connected with db2acd process | Client & Connectivity | |
| DT223909 | CLP removes new line characters if there are a simple comment between bracketed comments and CREATE PROCEDURE statement | Client & Connectivity | |
| DT236661 | Invalid XML from table monitoring functions FOR BIT DATA | Data Management | |
| DT222000 | Deadlock on rows in SYSXMLSTRINGS or SYSXMLPATHS when many concurrent applications drive queries and inserts of XML documents | Data Management | |
| DT224960 | A table space in an offline state can be incorrectly brought online resulting in data corruption | Data Management | |
| DT228892 | Creating Teradata wrapper on AIX failed with SQL10031N from V11.5.4 | Federation | |
| DT224489 | Federating to SQL Server throws SQL1822N Unexpected error code "HY104" received from data source "". Associated text and tokens are " Invalid precision value". | Federation | |
| DT228669 | SQL Error "-803" occurs when creating monitor tables with ASNCLP on Oracle. | IIDR | |
| DT228901 | db2pd -applications may result in messages "Changing data structure forced command termination" | Process Model | |
| DT223627 | During system controller startup, some diagnostics messages are not recorded in the diagnostics log | Process Model | |
| DT236687 | Reduce severity level of db2diag probe if it is an interrupt for WLM monitoring functions | Process Model | |
| DT223336 | db2pd -dump all dumpdir='/scratch/' -repeat 5 2 may dump data into wrong directory | Process Model | |
| DT212788 | Drop event monitor may result in creation of an applicatoin on non-coordinator nodes | Process Model | |
| DT237138 | Poor performance of Db2 query when the following conditions mentioned in the description are met | Query Compiler | |
| DT208544 | Security: Db2 is vulnerable to denial of service with a specially crafted query (CVE-2023-30991) | Query Compiler | |
| DT228679 | SQL0901 "Predicate not found" during Federated query compilation | Query Compiler | |
| DT224613 | Possible sustained trap sqlrr_rds_common_post() when Federated Query fails | Runtime | |
| DT236724 | SQL0901N 'numCurrentHWMs <= numCachedHWMs' in a query that runs concurrent to insert/update activity | Runtime | |
| DT236512 | Db2 trap due to ipcresources is NULL during db2fmp shutdown | Runtime | |
| DT215391 | Columnar Aggregation taking excessive amounts of memory | Runtime | |
| DT228412 | Memory leak while using JSON_TABLE function in sql | Runtime | |
| DT224383 | When the Db2 driver is repeatedly loaded and unloaded by an application, and the SSLServerCertificate parameter is configured, the in-memory keystore may leak a small amount of memory | Security | |
| DT236921 | When TLS 1.3 is enabled, GSKit error 446 might be seen in the diagnostic log when a Java client closes a connection | Security | |
| DT225098 | userprofile banner causes HADR issues | pureScale | |
| DT224776 | Setting the CF_MEM_SZ too high (around 1 TB) will cause the CF to crash | pureScale |
Update 32821
2023-07-27 Linux x86 PTF: DYN2307271447AMD64_32821
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT148223 | IT37810: REDUCE DB2DIAG.LOG MESSAGE "GET USER MAPPING" AND "SQLQG_FEDSTP_HOOK, PROBE:40 MESSAGE" | ||
| DT197526 | When running asnmon on LUW with control tables on z/OS, asnmon terminates with ASN0543E error | ||
| DT169902 | Big SQL instance panics with 'Corrupt pool free tree node' from sqloDiagnoseFreeBlockFailure() | ||
| DT197143 | CP4D- Q replication server reported the message "ASN8999D Corrupted qStreamedTransMsgHeader on send queue xxxx" | ||
| DT195980 | Fix the unique index issue and Update the new QMAP name for CCD columns. | ||
| DT188249 | Fix ALTER TABLE ALTER COLUMN DROP/SET DEFAULT in v1158 | ||
| DT188885 | "Delete gtran committed before restart point" message floods capture log when processing an empty global transaction | ||
| DT173830 | Use of non-supported RID function triggers SQL0901N error instead of the expected SQL5115N error | ||
| DT168942 | JCC driver returns ERRORCODE=-4499 where a seamless failover is expected | ||
| DT147889 | ABNORMAL TERMINATION OF QUERY WITH COMMON TABLE EXPRESSION | ||
| DT147884 | QUERY FAILS WITH ERROR SQL0901N "NLJN LOJ INNER NOT NULLABLE" | ||
| DT172370 | Q Apply startup or STARTQ may fail with SQL-10 when checking if a target is a nickname. | ||
| DT169561 | Big SQL instance abends with an SQLO_UNEXPECTED_SYSERR from sqloWaitEDUWaitPost() | ||
| DT148867 | IT42001: DB2ADUTLUPLOAD MAY WRONGLY UPDATE A HISTFILE ENTRY THAT CORRESPONDS TO A BACKUP SEQUENCE THAT FAILS TO BE UPLOADED | ||
| DT148307 | IN DPF ENVIRONMENT, FEDERATION FMP COULD BE INTERPRETED BY OTHERINTERRUPT REQUEST FROM DB2 ENGINE. | ||
| DT160132 | IT42096: INCORRECT ERROR HANDLING IN SQLEFEDFMPMANAGER::GETFMPFROMGLOBALPOOL LEADS TO DB2 INSTANCE CRASH | ||
| DT148130 | IT41926: TRACKING ERROR IN WLM ERROR CORRECTION CAN LEAD TO NON FATAL ASSERTION | ||
| DT147955 | Security: : IBM DB2 IS VULNERABLE TO A DENIAL OF SERVICE AFTER ENTERING A MALFORMED SQL STATEMENT INTO THE DB2EXPLN TOOL | ||
| DT148670 | Security: : IBM DB2 IS VULNERABLE TO AN INFORMATION DISCLOSURE DUETO UNAUTHORIZED ACCESS. (CVE-2022-22483) | ||
| DT147386 | IT41166: SQL1092 TOKEN:X180085 ON CALL GET_DBSIZE_INFO(?,?,?,0) | ||
| DT215662 | Online BACKUP of SMS table space can fail with deadlock due to concurrent LOAD operation | Availability | |
| DT148117 | IT41276: SUSTAINED TRAP ON HADR STANDBY BLOCKS REPLAY-ONLY WINDOW | Availability | |
| DT222096 | LOGICAL_RESTORE fails when replaying schema DDL statements with syntax errors | Availability | |
| DT213313 | Slow performance during database recovery when replaying TRUNCATE TABLE or CREATE/ALTER TABLE NOT LOGGED INITIALLY | Availability | |
| DT214627 | LOGICAL_BACKUP (Schema-Level Backup) Produces Corrupted Backup Image If There are RCAC Tables in the Schema | Availability | |
| DT212931 | INDOUBT TRANSACTIONS NOT RESOLVED AUTOMATICALLY | Availability | |
| DT172989 | Db2 CLP by resource agents fails with SQL0332N error when database is used with locale that are incompatible with LANG C | Availability | |
| DT212699 | SYSPROC.SYSINSTALLOBJECTS('LBAR', 'M' ...) stored procedure unable to migrate IIAS restore history tables | Availability | |
| DT212779 | Audit records failures to access RCAC table data originating from LOGICAL BACKUP when it is not run | Availability | |
| DT209817 | DATABASE OUTAGE AFTER CRASH RECOVERY when using columnal table with intra-parallelism. | Availability | |
| DT211715 | Ignore non Critical Errors During Logical_Restore | Availability | |
| DT209692 | DATABASE OUTAGE DUE TO LACK OF LOG SPACE WHEN DB2_CDE _DCC ENABLED | Availability | |
| DT149261 | IT42027: PURESCALE MEMBER RESTART HANG DUE TO CIRCULAR DEPENDENCY WITH BACKUP EXECUTING ON A DIFFERENT MEMBER | Availability | |
| DT198216 | db2start may fail when pacemaker is in the environment with an SQL1345 error | Availability | |
| DT197154 | Memory leak in db2fmd while monitored db2 instance is stopped. | Availability | |
| DT209734 | HADR_REMOTE_HOST changed from hostname string to IP address after takeover | Availability | |
| DT209085 | LOGICAL_RESTORE - Ignore RCAC Options if No RCAC Tables Present in Backup Image and in Restore Set | Availability | |
| DT208667 | ADMIN_DROP_SCHEMA or LOGICAL_RESTORE fail when RCAC tables exist in schema | Availability | |
| DT208663 | Remove temporary directories and files as part of LOGICAL_RESTORE cleanup | Availability | |
| DT208662 | LOGICAL_RESTORE fails to restore INC/DEL backup image | Availability | |
| DT208660 | Hang in LOGICAL_RESTORE Python Script When Restoring from DPF to SMP | Availability | |
| DT198297 | HADR takeover by force fails when standby cannot resolve hostname of primary to IP | Availability | |
| DT189581 | Title: Query on HADR standby is forced off when DROP TABLE with SESSION as schema name is executed on the HADR primary database | Availability | |
| DT197487 | Using ET or LBAR with an unrecognized production IBM Cloud Object Storage endpoint results in SQL20569N | Availability | |
| DT189208 | -902 reported by LOGICAL_BACKUP or LOGICAL_RESTORE when provided incorrect cloud URL | Availability | |
| DT196637 | LOGICAL_RESTORE fails on image check due to unexpected file | Availability | |
| DT188273 | SYSIBMADM.PRIVILEGES missing SCHEMARCAC privilege | Availability | |
| DT195969 | LBAR - Fixing the Problem with CREATE EXTERNAL REMOTESOURCE | Availability | |
| DT196027 | LBAR - Fixing the Problem with Wrong Order of Restoring Dependent Views | Availability | |
| DT189209 | LBAR: Allow -drop-existing with -keep-rcac for LOGICAL_RESTORE and Fixing -keep-rcac and -replace-rcac Pre-checks | Availability | |
| DT179023 | It is not possible to upload images/logs using db2adutl when the attached database partition number is different than the one used in DBPARTITIONNUM | Availability | |
| DT179518 | Db2diag.log is flooded with message from "sqlpLLMUpdateLockWithGLMResponse, probe:3090" | Availability | |
| DT174277 | adding -remote_cmd option for db2cm fix to for systems with an ssh banner | Availability | |
| DT148686 | IT41856: TRAP/ERROR READING FROM LOG FILES WITH ALSM ENABLED | Availability | |
| DT173699 | SQL1797N with "Directory not empty" errors when calling LOGICAL_RESTORE or LOGICAL_BACKUP_DETAILS | Availability | |
| DT173106 | Error message from db2logts EDU | Availability | |
| DT173258 | LOGICAL_RESTORE fails with "Unable to find the metadata file info.json for" error when restoring single schema out of multi-schema backup image. | Availability | |
| DT169658 | db2cm -delete -qdevice fails while QDevice host is down | Availability | |
| DT170181 | Fixes to productize Logical Backup in Db2 11.5.8 | Availability | |
| DT149262 | IT42041: HANG DURING CRASH RECOVERY WAITING FOR LOG ARCHIVE WITH MIRRORLOGPATH AND BLK_LOG_DSK_FUL ENABLED | Availability | |
| DT161058 | TRAP IN FUNCTION SQLPDOUPDATELSNVALUESINXHDRS WHEN WRITING A LOGRECORD | Availability | |
| DT148514 | OUT OF LOG SPACE DURING COMMIT OR ROLLBACK WHEN REPLICATION IS ENABLED | Availability | |
| DT221822 | Allowing the user to receive ownership of a function with a sequence alias as a dependent object | Catalog Services | |
| DT211422 | Generate error message for DB2look when the wrong option is specified with -ct | Catalog Services | |
| DT212546 | Binding from an 11.5 client to a down-level server can fail with an SQL0104N error. | Catalog Services | |
| DT209762 | TOTALDBPARTITIONCONNECTIONS into TOTALMEMBERCONNECTIONS in db2look | Catalog Services | |
| DT208817 | db2updv115 returned SQLCODE -104 error for drop statement | Catalog Services | |
| DT208717 | Routines and triggers do not get revalidated by SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS for objects with a schema length below 4 characters. | Catalog Services | |
| DT189676 | Column-organized table may be locked in drop restrict state, preventing drop table from succeeding | Catalog Services | |
| DT188190 | Allow users with SCHEMAADM authority to create tables without having CREATETAB | Catalog Services | |
| DT188650 | RCAC dependencies can cause database fixpack updates to fail with SQL0478N | Catalog Services | |
| DT180107 | Index(es) found in PD which are not found in SYSIBM.SYSINDEXES | Catalog Services | |
| DT180628 | Upgrade event monitor target tables fails with SQL0443 - SQL0444 | Catalog Services | |
| DT172372 | Make Alter Table block correctly for the In clause and Long In clause condition | Catalog Services | |
| DT171921 | FODC error during drop table - inconsistency between syscat.indexes and sysibmts.tsindexes | Catalog Services | |
| DT169621 | Stored Procedure definitions missing the PARAMETER MODE (IN/OUT/INOUT) | Catalog Services | |
| DT145029 | db2look got SQL0206N when upgrading from Db2 11.5.4 to 11.5.6 or above without db2updv115 | Catalog Services | |
| DT212309 | When using JDBC type 2 driver, abort call from the Transaction Manager could return XAER_PROTO. | Client & Connectivity | |
| DT222034 | Compiling .cbl file generated by prep command failed with 309 "Malformed subscript" error | Client & Connectivity | |
| DT214747 | Server list missing alternate server when value of alternate server matches the value of the server it is set up on for the length of alternate server | Client & Connectivity | |
| DT214991 | ACR is disabled for the Federation DRDA fenced wrapper after applying fix for DT188887 | Client & Connectivity | |
| DT211379 | Security: IBM Db2 JDBC driver is vulnerable to arbitrary code execution. (CVE-2023-27867, CVE-2023-27868, CVE-2023-27869) | Client & Connectivity | |
| DT213363 | Data loss potential when using Embedded SQL with multiple agents and Multi-row insert | Client & Connectivity | |
| DT208528 | Documents are not indexed with warning IQQP0009W | Client & Connectivity | |
| DT179678 | IQQD0008E Collection | Client & Connectivity | |
| DT207573 | TRAP IN SQLEGWRT FUNCTION | Client & Connectivity | |
| DT208149 | DECIMAL_OLEDB to DECFLOAT conversion fails for value zero . | Client & Connectivity | |
| DT179633 | Invalid file handle error returned by SQLDriverConnect/W() API on windows platform causing engine abort | Client & Connectivity | |
| DT197561 | AccessViolationException in db2app64.dll (Db2 .NET Provider native code) while invoking a StoredProcedure from Db2 .NET driver | Client & Connectivity | |
| DT188887 | Security: IBM Db2 is vulnerable to a denial of service when attempting to use ACR client affinity for unfenced DRDA federation wrappers. (CVE-2023-27555) | Client & Connectivity | |
| DT196884 | Signals could get delivered to CLI sub threads which are meant to be delivered to CLI main thread | Client & Connectivity | |
| DT179750 | .NET application returns error SQL0843N during connect | Client & Connectivity | |
| DT180609 | SQLCODE -902 can be returned when a client reads larger LOB data using application compile with AIX 32-bit library | Client & Connectivity | |
| DT178648 | Allow db2cli refreshldap to work on installed Db2 clients not just Drivers | Client & Connectivity | |
| DT188305 | DB2BULKCOPY MAY RETURN CLI0125E WHEN TRYING TO LOAD MULTIPLES OF16K NUMBER OF ROWS | Client & Connectivity | |
| DT173390 | Null Pointer Exception during HADR failover | Client & Connectivity | |
| DT178562 | Resize and redefine the size of char array program_z | Client & Connectivity | |
| DT174264 | odbc_cli driver package does not accept precision greater than 31 for decimal types while connecting to IBM i | Client & Connectivity | |
| DT173047 | Re-authentication occurs when re-using an existing transport for a member in xa transaction | Client & Connectivity | |
| DT173970 | "SSL socket setup failed" error logging in db2diag.log caused by monitoring the SSL socket | Client & Connectivity | |
| DT173536 | Running zload on a file bigger than 2GB fails with SQL2731N Error while reading from input data file | Client & Connectivity | |
| DT168528 | Changing "sqeLocalDatabase::AutoBind, probe:20963" from "LEVEL: Warning" to "LEVEL: Error" | Client & Connectivity | |
| DT207549 | Security: Db2 is vulnerable to denial of service with a specially crafted XML query statement (CVE-2023-38728) | Data Management | |
| DT213899 | Slow RUNSTATS performance after upgrade from Db2 v10.5/v11.1 to v11.5 | Data Management | |
| DT214206 | A Db2 instance can crash if a database encounters a too many open file handles (SQLO_FHNL) error while opening the database storage group files | Data Management | |
| DT212891 | Data loss while ADMIN_MOVE_TABLE possible | Yes | Data Management |
| DT208144 | SQLD_REC_DELETED "DELETED RECORD ID" may show up during select from sysibmadm.admintabinfo | Data Management | |
| DT197696 | ENABLE OPTION TO ALLOW AUTOMATIC TABLE MAINTENANCE TO CHOOSE OFFLINE INSTEAD OF ONLINE INDEX REBUILD TO AVOID DEADLOCK. | Data Management | |
| DT188237 | LOAD into MQT table using LOCK WITH FORCE option does not force all locks and hangs on SET INTEGRITY | Data Management | |
| DT189082 | Under certain conditions user can get false SQL0960C The maximum number of objects have been created in the table space | Data Management | |
| DT188148 | Automatic Reorg Evaluation on an ITC table can hold back completion of an automatic table reorganization on the table | Data Management | |
| DT180384 | Private memory leak while using Sequences | Data Management | |
| DT178710 | pureScale: hate lists temporarily empty after large queries | Data Management | |
| DT169362 | LOAD from cursor into inline XML with values longer than 256 characters results in SQL1194W | Data Management | |
| DT178367 | Segmentation fault in sqldDumpDKEY | Data Management | |
| DT178232 | Error messages from sqlbExtentMovementEntryPoint can be inadvertently suppressed | Data Management | |
| DT174577 | SQL16003 from XML query | Data Management | |
| DT171612 | Tablespace Reduce Max/HWM can provoke dumps .bin due to unexpected lock holding in SQLP_EXTENT_MOVE_STARTED | Data Management | |
| DT148089 | IT39613: SIGNAL #11 IN XMLRNSERIALIZER::PACKSTATE | Data Management | |
| DT173007 | Security: IBM Db2 may be vulnerable to a Denial of Service when executing a specially crafted 'Load' command. (CVE-2022-43929) | Data Management | |
| DT147509 | IT38703: INGEST TO PARTITIONED DATABASE DOES NOT WORK OVER SSL | Data Management | |
| DT148406 | IT38343: ENHANCE DB2_CSL_SEARCH_PERCENT TO IMPROVE INSERT PERFORMANCE | Data Management | |
| DT160180 | Rollforward/replay of online reorg log causes slow log replay | Data Management | |
| DT168735 | The INGEST utility on AIX fails with DB21018E when connected to a remote database with an SSL encrypted connection | Data Management | |
| DT160471 | Possible page latch contention when inserting into an insert time clustered table | Data Management | |
| DT147574 | IT41721: IMPORT WITH INSERT_UPDATE FAILS WITH SQL3203N AFTER GETTING SQL0437W. | Data Management | |
| DT148675 | IT41241: POSSIBLE FMP TRAP WHEN USING ADMIN ROUTINES OR ANY MODULE USING LIBDB2XMLINIT531.A | Data Management | |
| DT149264 | IT42035: A CLI LOAD INTO A COLUMN ORGANIZED TABLE MIGHT CRASH WITH A SPECIFIC STACK | Data Management | |
| DT148311 | INDEX ERROR DURING ROLLBACK WHEN INSERTING INTO A DECLARED GLOBAL TEMPORARY TABLE THAT IS ORGANIZED BY COLUMN | Data Management | |
| DT169540 | IT42201: Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables | Data Management | |
| DT148473 | IT40815: Difference in Per-Partition TSIZE between REORGCHK and REORGCHK_TB_STATS for Partitioned Tables | Data Management | |
| DT222769 | Validating "/etc/zipl.conf".. DBT3615E The db2prereqcheck.. Reason Code 3 for Db2 V11.5.8.0 | Deployment | |
| DT215950 | installFixPack fails with an ERROR for non-root installations, complains about loaded libraries | Deployment | |
| DT197671 | Security: IBM Db2 on Windows is vulnerable to privilege escalation. (CVE-2023-27558) | Deployment | |
| DT214851 | python2 is no longer needed for Db2, but still checked by db2prereqcheck | Deployment | |
| DT178134 | On Sles 15, db2installPCMK hitting "nothing provides pkgconfig(libqb)" | Deployment | |
| DT173853 | db2iupdt fails to drop a collocated member using the member id | Deployment | |
| DT173400 | InstallFixPack fails with DBI20105E when attempting to update Pacemaker | Deployment | |
| DT224589 | sqlerReturnFmpToPool messages flood the db2diag.log | Federation | |
| DT198104 | Security: Db2 is vulnerable to a denial of service through a specially crafted federated query on specific federation objects (CVE-2023-29258) | Federation | |
| DT223376 | Oracle unfenced wrapper trapping | Federation | |
| DT222119 | Db2 federation query with decimal and char comparison predicate becomes slow due to not being able to do pushdown | Federation | |
| DT214010 | Timestamp and Date not pushed down to MongoDB Data Source | Federation | |
| DT220220 | Federated user mapping change is not refreshed after HADR takeover | Federation | |
| DT213111 | If we lost connection from POSTGRESQL while fetching the data from POSTGRESQL using ODBC wrapper (Federation) and loading into DB2, then load is hanging | Federation | |
| DT208699 | CREATE NICKNAME command for a remote SQL Server table returns -204 error occurs: undefined name | Federation | |
| DT203382 | SQL query containing the OLAP LEAD function returns wrong results | Federation | |
| DT196864 | Federation server memory panic caused by sqlqgFedRbk1 | Federation | |
| DT196289 | Federated does not push down certain predicates to z/OS | Federation | |
| DT143275 | IT41646: FEDERATION FUNCTIONS NOT PUSHED DOWN WHEN USING PARAMETER MARKERSUCH AS TO_TIMESTAMP(?,'YYYY-MM-DD HH24:MI:SS') | Federation | |
| DT187940 | Security: IBM Db2 federated server is vulnerable to a denial of service when using a specially crafted wrapper using certain options. (CVE-2023-30442). | Federation | |
| DT189684 | Federation: Oracle net8 wrapper-support function pushdown: replace, trim and to_number | Federation | |
| DT180458 | Instance crash due to double memory free in sqlqgFedCmt1 | Federation | |
| DT173847 | SELECT NICKNAME MAY RETURN A GARBLED CHARACTER AT THE END | Federation | |
| DT170049 | Db2 Federation nickname driver issue | Federation | |
| DT173461 | Federation returns SQL0901N "Unknown type" error when query numeric value with single quote using ODBC wrapper | Federation | |
| DT173486 | Security: Db2 federated server is vulnerable to a denial of service when a specially crafted cursor is used. (CVE-2023-46167) | Federation | |
| DT172037 | Federation ODBC wrapper characters might be truncated for MariaDB, MySQL community edition, and SAP hana data sources | Federation | |
| DT148431 | IT39324: FEDERATED OPERATIONS MIGHT LEAD TO INSTANCE CRASH WHEN HEALTH MONITOR IS TURNED ON | Federation | |
| DT148462 | IT40445: CRASH IN WHEN XML SOURCE FILE IS DELETED OR RENAMED | Federation | |
| DT160542 | Federation SQL1476N error "-433" insert into nickname(varchar_column) select varchar_column from local_table | Federation | |
| DT148065 | IT38517: MSSQL_SERVER::GET_ERROR_INFO ERROR IN MS-SQL FEDERATION CONFIGURATION | Federation | |
| DT225689 | Missing parameter marker in ASNDB2SQ package | IIDR | |
| DT223427 | Restore some operations in Replication Center | IIDR | |
| DT224566 | Q Capture needs to set correct default value for TRANS_COMMIT_MODE parameter | IIDR | |
| DT222930 | Q Apply replicating columnar table in DPF may report SQL -644 if target table does not use all data partitions. | IIDR | |
| DT215322 | Asnmon takes a sigsegv and a dump is generated when it writes to a file with a long path name. | IIDR | |
| DT222106 | Oracle Apply initial load with SQL*Loader fails with ASN7530E bad data record for DECIMAL column data having equal precision and scale | IIDR | |
| DT215896 | Oracle Q Capture should not get ORA-01741 for inserts into the IBMQREP_CAPMON table | IIDR | |
| DT215449 | Asnmon report error message ASN5154W when the alert on QCAPTURE_MEMORY uses a value greater than 2047. | IIDR | |
| DT214858 | Fix memory corruption error in Q Capture send queue | IIDR | |
| DT211484 | Oracle QCapture should not stop on OCI_SUCCESS_WITH_INFO | IIDR | |
| DT189305 | Q Apply poor performance for complex RI needs to be improved by doing dependency analysis based on RI key values | IIDR | |
| DT213082 | Q Apply should use compression with binary format during columnar table initial load | IIDR | |
| DT212936 | SQL Capture and Q Capture are not updating PART_HIST table for ATTACH/DETACH/ADD range Partition - Potential Data loss after Capture restart | IIDR | |
| DT209069 | Need COMMITs for retention_limit pruning in SQL Capture | IIDR | |
| DT208925 | The message "Parameter index 78 is out of range." is displayed every time Capture is started | IIDR | |
| DT208526 | Issue ASN7358I message on Q Capture startup when trans_batch_sz is greater than 1 and Q Capture automatically bumps up MAX_TRANS | IIDR | |
| DT189173 | Make DROPTAB_ACTION optional in Q Capture | IIDR | |
| DT197841 | If the target table already exists, and the unique index is suitable, Replication Center (RC) and ASNCLP incorrectly still try to create index | IIDR | |
| DT199933 | ADDCOL Processing leads to ASN7814E due to inconsistent IS_KEY information between IBMQREP_SRC_COLS and IBMQREP_TGT_COLS | IIDR | |
| DT180608 | Oracle Q Apply gets error ORA-01400 for MRI due to incorrect default for RTRIM_CHAR_TO_VARCHAR parameter | IIDR | |
| DT174287 | Replication Center does not display the Alert Group assigned contacts | IIDR | |
| DT173810 | Add "NO CACHE ORDER" when creating IBMQREP_APPLYCMD and IBMQREP_CAPCMD control tables. | IIDR | |
| DT172482 | Q Capture should read from serialized XML log records instead of fetching from the table when XML columns are defined in a separate long tablespace | IIDR | |
| DT174059 | Security: IBM Db2 on Windows is vulnerable to an information disclosure vulnerability as sensitive information may be included in a log file. (CVE-2022-43930) | Multiple | |
| DT173489 | Security: IBM Db2 is vulnerable to an information disclosure vulnerability due to improper privilege management when a specially crafted table access is used (CVE-2022-43927) | Multiple | |
| DT224997 | Db2 instance hang upon database creation failure SQL1643C | Operating System Services | |
| DT215290 | #pragma options in DB2 header files cause compiler warnings | Operating System Services | |
| DT214775 | CONNECTION SLOWNESS/HANG DUE TO MORE LATCH WAIT AT GROUP AUTHENTICATION STEP. | Operating System Services | |
| DT198274 | Security: IBM Db2 db2set is vulnerable to arbitrary code execution. (CVE-2023-30431) | Operating System Services | |
| DT205468 | db2prereqcheck -tb_dev failed with segmentation fault(segv) at strncpy() | Operating System Services | |
| DT202928 | Trap in dlopen() causes deadlatch with loadquery() called by Db2 signal handler | Operating System Services | |
| DT188227 | Private memory leak on COS SDK | Operating System Services | |
| DT179583 | Can't compile in Application with DB2 Client Server 11.5.8. This is the error that the system returns: libdb2.so: undefined reference to sqloRemStgDelete | Operating System Services | |
| DT202887 | PD_GET_DIAG_HIST and db2diag tool might return entries outside of specified time range. | Problem Determination Tooling | |
| DT179659 | db2csap generates a core dump when running db2support | Problem Determination Tooling | |
| DT160816 | Misleading/Incorrect Path Reported by db2diag command | Problem Determination Tooling | |
| DT222611 | Db2 can fail with SQLKD_PARTNER_ERR - "Received HALT block with zero return code" | Process Model | |
| DT222775 | Locking event monitor incorrectly reports RR isolation level for statements that are in compiling state | Process Model | |
| DT222690 | DB2 SYSTEM APPLICATIONS MAY HANG ON A DB2 DPF INSTANCE | Process Model | |
| DT214839 | Failure on an SQL statement with error may lead to trap in sqmSqlCacheMetrics::CaptureCoordHWMArgs | Process Model | |
| DT211718 | "db2 force application('apphdl')" can fail to properly interrupt external table operations using SSL connection. | Process Model | |
| DT188935 | Event Table Is Filling Up After the Event Monitor Is Dropped in DPF System | Process Model | |
| DT197244 | Incorrect diagnostic log message in sqlkd_snd_buffer may lead to a crash | Process Model | |
| DT195996 | Db2 concurrent workload may slow down due to heavy latch wait on the SQLO_LT_sqmPartitionedRequestMetrics__metricsSyncPoint latch | Process Model | |
| DT189583 | db2pd -apinfo crash with -debug option because of extended memory corruption | Process Model | |
| DT187963 | SYSMANAGEDQUERIES wlm work class of type RUNTIME in a 11.5.6 based database with old wlm default environment | Process Model | |
| DT179060 | application not going away, stuck in sqkfChannel::BroadcastData | Process Model | |
| DT188297 | DB2 trap in federation communication against DB2 z/os federated | Process Model | |
| DT172665 | HADR status changed to disconnected after primary reboot | Process Model | |
| DT174378 | Security: Db2 could allow a local user with special privileges to cause a denial of service during database deactivation on DPF (CVE-2023-38719) | Process Model | |
| DT170166 | LOGGING ENHANCEMENT FOR AN ISSUE CAUSING ORPHANED APPLICATION IN DECOUPLED STATUS IN DPF | Process Model | |
| DT170035 | GET DB CFG traps if using DB2NODE to fetch data from a remote node | Yes | Process Model |
| DT160459 | DB2DIAG.LOG FLOODED WITH DIAGNOSTIC MESSAGES | Process Model | |
| DT148687 | IT41917: MON_GET_TABLE MAY BLOCK ON A LOCK WHEN EXTERNAL TABLES ARE BEINGUSED | Process Model | |
| DT148129 | IT41889: A NON ENCRYPTED DATABASE THAT IS RESTORED AS AN ENCRYPTED DATABASE IS NOT CONNECTABLE AFTER THE RESET DB CFG COMMAND. | Process Model | |
| DT148314 | IT41989: THE EVMON_FORMAT_UE_TO_XML TABLE FUNCTION CAN TRAP FOR LOCK EVENTS INVOLVING A TABLESPACE LOCK WHEN THE TABLESPACE IS ALREADY DR | Process Model | |
| DT149281 | get_dbsize_info() may return unexpected large value for DATABASECAPACITY | Process Model | |
| DT222709 | FIXPACK UPDATE MAY LEAD TO ERROR SQL901N | Query Compiler | |
| DT224882 | UPDATE or DELETE of global temporary table returns SQL0551 | Query Compiler | |
| DT220313 | SQL0901N "No Remote Query output columns given." from table function involving column-organized tables | Query Compiler | |
| DT214149 | Subquery with FETCH FIRST n ROWS and OLAP function but without ORDER BY on column-organized tables might return more rows than expected | Yes | Query Compiler |
| DT221828 | SQL0508N when DB2_EXTENDED_OPTIMIZATION=MARKMCARD_MISSINGPKCOL ON | Query Compiler | |
| DT220159 | A Db2 query may exhibit long compile times when there are several CSEs (Common Sub-Expressions) referenced | Query Compiler | |
| DT189461 | COLUMN-ORGANIZED FETCH-IXSCAN ESTIMATED COST IS INACCURATE FOR QUERIES THAT RETRIEVE A LARGE NUMBER OF COLUMNS AND ROWS. | Query Compiler | |
| DT173447 | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query. (CVE-2023-30443) | Query Compiler | |
| DT212933 | A DB2 query may return incorrect results when query references a user defined function and at-least one columnar table | Query Compiler | |
| DT215096 | Poor performance of Db2 query with always true regexp_like predicate. | Query Compiler | |
| DT197954 | A multi-join query involving column-organized tables and join predicates with complex expressions might yield incorrect results. | Yes | Query Compiler |
| DT187836 | Query compile fails with SQL0901N "pid type does not match original untyped code | Query Compiler | |
| DT172015 | Info level diagnostics might be recorded in db2diag log file for DIAGLEVEL 0-3 | Query Compiler | |
| DT212371 | SQL0204N due to timestamp checking to compare start of compilation with the creation time of the table | Query Compiler | |
| DT212885 | Provide method to favour access plans that can exploit performance enhancement to column-organized updates/deletes with joins | Query Compiler | |
| DT211543 | SQL0901N error with "Empty plan list detected" may be returned for MPP queries which construct XML elements | Query Compiler | |
| DT211077 | Poor performance of merge statement when hidden column of PK absent in ON | Query Compiler | |
| DT209344 | Possible performance issue and high demand for STMTHEAP (or SQL0101N) for complex XML queries with multiple Union All branches | Query Compiler | |
| DT197773 | Automatic catalog statistics sampling occurs incorrectly in some situations | Query Compiler | |
| DT209442 | SYSCAT.ROUTINEPARMS missing parameters for LAG and LEAD built-in functions | Query Compiler | |
| DT189799 | Creating an expression-based index may lead to SQL0622N error | Query Compiler | |
| DT189181 | Security: IBM Db2 is vulnerable to a denial of service as the server may crash when using a specially crafted subquery. (CVE-2023-27559) | Query Compiler | |
| DT188878 | Security: IBM Db2 is vulnerable to a denial of service. Under rare conditions, setting a special register may cause the Db2 server to terminate abnormally (CVE-2023-25930) | Query Compiler | |
| DT160619 | Security: IBM Db2 is vulnerable to a denial of service as the server may crash when compiling a specially crafted SQL query. (CVE-2023-26021) | Query Compiler | |
| DT178597 | Security: IBM Db2 is vulnerable to a denial of service as it may trap when compiling a variation of an anonymous block (CVE-2023-29255) | Query Compiler | |
| DT203400 | Security: IBM DB2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30446) | Query Compiler | |
| DT147742 | 901 ERROR MIGHT OCCUR WITH THE MESSAGE "PLAN NOT FOUND FOR UNIONLEG" | Query Compiler | |
| DT173349 | INSERT INTO COLUMN-ORGANIZED TABLE WITH SUB-SELECT REFERENCING THE TARGET OF THE INSERT MAY RETURN INCORRECT RESULTS IN DPF SYST | Query Compiler | |
| DT188141 | Security: Db2 server may terminate abnormally when using a specially crafted query on certain databases. (CVE-2023-30987) | Query Compiler | |
| DT180503 | ALLOW AN EMBEDDED OPTIMIZATION GUIDELINE ANYWHERE WITHIN AN SQL STATEMENT. | Query Compiler | |
| DT197297 | "SET ?" returns SQL0901 with stmt_conc=LITERALS | Query Compiler | |
| DT189575 | -901 with Can not enforced Maxcard > 1 when multiple joins used in query | Query Compiler | |
| DT188308 | Explicit cast to VARCHAR or VARGRAPHIC without length ignores default string units | Query Compiler | |
| DT188352 | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30447) | Query Compiler | |
| DT188497 | Query fails with error SQL0901N "nljn LOJ inner not nullable" | Query Compiler | |
| DT172257 | Query execution plan has non-numeric Total Cost values | Query Compiler | |
| DT174288 | Plan ID changes when migrating from 10.x versions of Db2 to 11.1 and later. | Query Compiler | |
| DT178746 | CREATE TABLE IF NOT EXISTS ignores dft_table_org=COLUMN database configuration parameter | Query Compiler | |
| DT147960 | IT41629: ISSUING TRUNCATE TABLE STATEMENT MAY CAUSE THE SERVER TO TERMINATE ABNORMALLY. | Query Compiler | |
| DT174584 | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30445) | Query Compiler | |
| DT173922 | With Db2 DPF, SQLCODE -901 "Correlated part col not in stream." might occur during compilation of a query with correlated grouping sets columns | Query Compiler | |
| DT172317 | Db2 query may generate Incorrect result when tables have Referential Integrity(RI) relation. | Yes | Query Compiler |
| DT173793 | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query. (CVE-2023-30449) | Query Compiler | |
| DT173255 | Security: IBM Db2 is vulnerable to denial of service with a specially crafted query on certain tables. (CVE-2023-30448) | Query Compiler | |
| DT172693 | Creating NZPLSQL routine may result in stack memory corruption | Query Compiler | |
| DT172335 | IN MPP CONFIGURATIONS, UNDER RARE CONDITIONS, A QUERY WITH A CORRELATED COLUMN REFERENCE IN A SUBSELECT MIGHT RESULT IN A SEGV TRAP | Query Compiler | |
| DT148293 | IT41067: ISSUING SELECT UNION ALL QUERY WITH LARGE CLOB MAY FAIL WITH SQL1585N | Query Compiler | |
| DT172119 | Poor performance of Db2 query when Group By list has expression and index column | Query Compiler | |
| DT169994 | Slow compilation of queries involving INNER JOINs of multiple tables and some partitioned tables | Query Compiler | |
| DT148689 | IT41977: POSSIBLE -901 ERROR FOR NESTED QUERIES WITH CASE EXPRESSIONS WITHSUB-QUERIES REFERENCED THE SELECT LIST. | Query Compiler | |
| DT168886 | Db2 query may trap when cse with union | Query Compiler | |
| DT168757 | IT42207: WRONG RESULT WHEN GROUP BY COL IS MISSING | Yes | Query Compiler |
| DT148852 | SQL0901N FODC_AppErr generated when running a query | Query Compiler | |
| DT160196 | Db2 server may terminate abnormally issuing a query with unreferenced CTE | Query Compiler | |
| DT160511 | Performance issues when queries contain predicates on columns derived from constants in recursive sub-selects | Query Compiler | |
| DT147773 | IT41923: CREATE INLINED TRIGGER FAILED WITH SQL901N (REASON "NO SOURCE TABLE FLAG SET FOR UPDATE FROM QUERY") | Query Compiler | |
| DT223178 | Rare memory corruption when HSJN is done in Columnar logic on Columnar Tables. | Runtime | |
| DT220310 | Incorrect Results when columnar tables JOIN predicate involves SUBSTR on CODEUNITS32 CHAR columns | Runtime | |
| DT147693 | IT38953: POSSIBLE CORE FILE, TRAP WITH CORRUPTED STACK GENERATED BY DB2FMP WHEN QUERY IS INTERRUPTED | Runtime | |
| DT215090 | Extra diagnostics to diagnose rare traps in Columnar HSJN that have CHTExtraPayloadPage in stack. | Runtime | |
| DT222401 | A QUERY HAVING FFNR MIGHT BE IN A HANG SITUATION AT SQLRI_HSJNDONEPROBETUPLES IN INTRA PARALLEL ENVIRONMENT | Runtime | |
| DT147398 | IT41890: MIN(TRUNC(TIMESTAMP)) THROWING SQL0901N | Runtime | |
| DT223133 | Query might fail with -901 - Reason "unexpected error at TableQueueEvaluator.cpp:1096". | Runtime | |
| DT214258 | fmp hung during force application | Runtime | |
| DT211633 | Very rare risk of possible memory corruption in Columnar Join plans | Runtime | |
| DT215592 | TRAP UNDER ibm_cde::query::SortInfo::getPublishingWork | Runtime | |
| DT214228 | OOM because of large section size | Runtime | |
| DT213791 | DB2 may generate SQL0901N for blu insert query | Runtime | |
| DT212824 | FODC Generated When Wide Row Split Across TQ Buffers | Runtime | |
| DT211214 | Under certain conditions query cannot be forced when agent is looping in sqlriPercentileGetValue. | Runtime | |
| DT211306 | Excessive logging on interrupt in smp | Runtime | |
| DT198759 | FAILED_SQL_STMTS incorrectly increased the count when the DML statement failed to compile | Runtime | |
| DT208338 | select from DGTT may get wrong results if there is a regular table with the same schema and name | Runtime | |
| DT188693 | Security: IBM Db2 is vulnerable to a denial of service as the server may crash when an Out of Memory occurs. (CVE-2023-26022) | Runtime | |
| DT208631 | Interrupt to fmp may generate many harmless but confusing error message in db2diag.log. | Runtime | |
| DT208575 | SQL0901 (Reason "usertemp inconsistent IUD") | Runtime | |
| DT203318 | Array Input may report -901 sqlcode (probe 020 in sqlktopn(), msg=TQ already open) | Runtime | |
| DT197066 | FODC Trap in sqlra_find_var_var | Runtime | |
| DT196926 | Queries on synopsis table return invalid dates | Runtime | |
| DT149266 | IT42044: SQL0955 RC=2 MAY BE RETURNED FOR SORT REQUESTS WITH A WIDE SORT KEY (>32K) WHEN AVAILABLE SORTHEAP IS LIMITED | Runtime | |
| DT196650 | Rebind of a package defined in a module can incorrectly fail with a SQL0440N | Runtime | |
| DT195966 | Insert statement hits FODC_Trap in SavepointResources::refreshNextTSNsToSplitAtSavepointOpen function | Runtime | |
| DT188654 | Protective logic against a possible trap CDE | Runtime | |
| DT188951 | SQL0901N in JoinSpillInfo::resetPartInfoForRepart() with Keys mis-match before and after repartitioning | Runtime | |
| DT187825 | When Statement concentrator (stmt_conc) is set to COMMENTS or COMM_LIT, it could result in leak of package cache memory and a reduced package cache hit ratio | Runtime | |
| DT128047 | IT40543: CONNECTION FROM DB2FMP TO THE ENGINE IS NOT CLEANED UP AFTER AN INTERRUPT | Runtime | |
| DT178557 | applications calling sqlugrpn() with datetime columns in distribution key may abort | Runtime | |
| DT180543 | SQL0901N - Reason "unexpected error at MinMaxPartialEvaluator.cpp:68" | Runtime | |
| DT174686 | Agent cannot be forced under certain conditions | Runtime | |
| DT147258 | IT35932: POSSIBLE FMP TRAP WHEN RUNNING DB2EXPLAIN WITH A STATEMENT CONTAINING UNESCAPED NEWLINE (\N) AND MULTIPLE SETS OF '(/)' | Runtime | |
| DT173735 | PERFORMANCE has slowed down with "DYNAMIC SQL CACHE NON REUSE" | Runtime | |
| DT172803 | Possible 3 ways hang with FMP and 2 db2agent | Runtime | |
| DT172626 | An unexpected program error in Db2 self tuning memory (db2stmm) may cause query or database hang | Runtime | |
| DT173315 | Wrong DateTime format or delimiter chosen | Runtime | |
| DT168876 | IN DPF, In an ERROR SCENARIO IF QUERY IS USING A VARIABLE, IT COULD FAIL WITH -901 or -902 (SQLKT_PGM_ERROR or SQLKT_SEVERE_PGM_ERROR) | Runtime | |
| DT171809 | Insert query crashes Db2 with RTABLE is ON | Runtime | |
| DT168620 | Excessive storage consumption due to Reorg Table Reclaim Extents not cleaning up extents properly after Trickle Feed Insert is disabled | Runtime | |
| DT160159 | Incorrect padding during conversion from char(8) to char(12) when using CCSID 1047 | Runtime | |
| DT171981 | Insert into a DGTT which contains XML fields on MPP environment might crash the instance | Runtime | |
| DT170011 | Using external UDF in recursive query executes only once and returns wrong number of rows | Yes | Runtime |
| DT169944 | Assertion Failure "nextTSNOnPage == currTSN". Additional info: Page next TSN inconsistent with table next TSN | Runtime | |
| DT160513 | PERFORMANCE DOWNGRADED AFTER UPGRADING TO V11.1.4.7 DUE TO MORE CALL OF sqlra_compile_var | Runtime | |
| DT147383 | IT41074: INVALID DATE FORMAT WHEN INSERTING DATES | Yes | Runtime |
| DT221915 | DBMS_LOCK.REQUEST not returning correct status code. | SQL Compatibility | |
| DT212411 | Creation of a view on a transient external table results in error “SQL0901 No column information found in the packed descriptor” | SQL Compatibility | |
| DT213994 | Under certain conditions DBMS_LOCK.ALLOCATE_UNIQUE can return NULL LOCK HANDLE | SQL Compatibility | |
| DT213848 | DBMS_LOCK.REQUEST throws error SQL0431N and SQL0803N incorrectly when the same lock is requested from a different session which is already being held by another session. | SQL Compatibility | |
| DT208624 | create external table when using option TRIMBLANKS BOTH trailing trimming does not work | SQL Compatibility | |
| DT208377 | QUERY ON EXTERNAL TABLE HAVING BIGINT COLUMN FOLLOWED BY A COLUMN OF ANY DATA TYPE, FAILS WITH SQL20570N | SQL Compatibility | |
| DT209180 | LF/CR in quoted data results in failure when it appears in the last column, and the buffer ends with a record delimiter character | SQL Compatibility | |
| DT209301 | NULL character in FIXED FORMAT binary data causes SELECT failure VARBINARY | SQL Compatibility | |
| DT196248 | db2look generates an external table DDL that works on v11.5.5 but fails on later versions after two options became mutually exclusive | SQL Compatibility | |
| DT189717 | SQL20569N Error when specifying encoding utf8 option for an external table created in a database with non-unicode code page | SQL Compatibility | |
| DT195953 | Incremental restore failing with SQL20569N | SQL Compatibility | |
| DT188851 | DBMS_LOCK.REQUEST throws error SQL0206N incorrectly when the same lock is requested from a different session which is already being held by another session. | SQL Compatibility | |
| DT169382 | External Table load failure when data file > 2MB contains sequential escape characters | SQL Compatibility | |
| DT149246 | When an external table command is run using the REMOTESOURCE option set to yes, and a scenario occurs where the coordinator is interrupted during the transfer of data from the remote source to the fmp process, a hang occurs. | SQL Compatibility | |
| DT147577 | IT41972: DB2 CRASH WHEN ALIAS IS USED TOGETHER WITH A PARTITIONED TRANSIENT EXTERNAL TABLE | SQL Compatibility | |
| DT148796 | Select from external table might hang when escaped field delim is present in data with LFINSTRING TRUE and CRINSTRING TRUE. | SQL Compatibility | |
| DT224814 | Security: Db2 is vulnerable to a denial of service under certain conditions when creating a table (CVE-2023-38740) | Security | |
| DT223175 | Security: Db2 is affected by a vulnerability in GSKit (CVE-2023-32342) | Security | |
| DT173476 | Security: IBM Db2 for LUW is vulnerable to insufficient audit logging (CVE-2023-23487) | Security | |
| DT208397 | Security: : IBM Db2 is vulnerable to information disclosure due to improper privilege management when certain federation features are used. (CVE-2023-29256) | Security | |
| DT215550 | Security: IBM Db2 is vulnerable to remote code execution. (CVE-2023-35012) | Security | |
| DT209435 | CREATE DATABASE may result in a SQL0552N if the user only has SYSCTRL authority | Security | |
| DT208180 | Security: IBM Db2 is vulnerable to remote code execution. (CVE-2023-29257) | Security | |
| DT187810 | SQL1729N is encountered when attempting a CATALOG STORAGE ACCESS command with a KMIP or PKCS11 keystore | Security | |
| DT178890 | On Linux and AIX platforms with a fix for IT41557, DB2 may panic or hang after a password check times out | Security | |
| DT172470 | REVERT GSK_MS_CERTIFICATE_STORE BEHAVIOUR AND CREATE A SEPARATE SETTING TO TURN ON MSCNG | Security | |
| DT208786 | Member may FODC when a RDMA adapter fails. | pureScale | |
| DT195923 | db2cm -enable not working in a two-sites multiple standby cluster with same-site failover automation | pureScale | |
| DT195910 | db2cluster -verify -req -rdma_ping times out when the cluster is configured to use significant number of RDMA adapters | pureScale | |
| DT180011 | Reduce CF memory by shrink of GBP structure fails with timeout after 5 minutes | pureScale | |
| DT178933 | db2cluster -verify -req -rdma_ping : performance statistics are missing into result files | pureScale | |
| DT180017 | False positive error in CF cfdiag when reducing container size | pureScale | |
| DT172758 | Backup latches caused system hang on the database where the backup is running. | pureScale | |
| DT170021 | SAL Panic, page name mismatch | pureScale | |
| DT170023 | CF GBP missing detach failure | pureScale | |
| DT148093 | CRM STATUS COMMAND REPORTS INCORRECT STATUS OF RESOURCES | pureScale |
Downloads
Downloads for Update 49307
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 42302
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 43143
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 42458
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 40526
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 38086
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 37208
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 36040
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 33830
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
Downloads for Update 32821
AIX
| AIX (64-bit) |
|---|
| IBM Db2 Universal Fixpack |
| IBM Db2 Server Fix Pack |
| IBM Data Server Client |
| IBM Data Server Runtime Client |
| IBM Data Server Driver |
| IBM Data Server Driver for ODBC and CLI |
Linux
Windows
[{"PRLabel":"Db2 Mod packs, fix packs and special builds","PRLang":"English","PRSize":"0 B","PRPlat":{"label":"Other","code":"PF059"},"PRURL":"https://www.ibm.com/docs/en/db2/11.5?topic=editions-mod-packs-fix-packs-special-builds"}]
Change History
Removed SPSS KI
| DT135652 |
Off
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":"a8mgJ0000000NcXQAU","label":"Install\/Migrate\/Upgrade-\u003EUpdate"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0;10.5.0;11.1.0;11.5.0;11.5.1;11.5.2;11.5.3;11.5.4;11.5.5;11.5.6;11.5.7;11.5.8;11.5.9;12.1.0;12.1.1;12.1.2;12.1.3;12.1.4;12.1.5;8.2.0;9.1.0;9.5.0;9.7.0;9.8.0"}]
Was this topic helpful?
Document Information
Modified date:
23 July 2026
UID
ibm16856211