Download
Downloadable File
| File link | File size | File description |
|---|---|---|
Abstract
Download Db2 v11.5.9 Published CSB (Cumulative Special Build) for Db2® for Linux®, UNIX®, and Windows® and Db2® Connect™ products.
Use this page to download a Db2 CSB for the installed Db2 product you have. Db2 CSB images are delivered from Fix Central. Special builds are cumulative. Included are links 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, .NET). Click on the CSB to view it.
CSBs are cumulative, with each CSB containing all fixes delivered in previous CSBs.
CSBs are listed in descending order, with the most recent ones at the top. As a result, earlier-listed CSBs include all the fixes from those listed further below.
CSBs cannot be chronologically ordered based solely on their numbers.
CSBs and the listed Known Issues (KIs) may be updated retroactively.
Not all CSBs are included in this list.
Security KIs will be added only after they are officially announced.
For more information on Security KIs, please refer to the Published Security Vulnerabilities page.
Starting Special Build 55285 (DYN2503051558), Db2 has the following updates:
Db2 11.5.9 Stack uplift:
Storage Scale 5.1.9.7
Db2 11.5.9 new OS support for pureScale:
RHEL 8.10
RHEL 9.4
SUSE 15SP6
Download Description
Special Build 69673*
2025-10-24
*This is the most recent CSB
Linux x86 PTF: DYN2510241909AMD64_69673
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT451941 | Database recovery failed in pureScale with SQLP_LERR from sqlpshrValidateLfsLsn | Availability | |
| DT452626 | XA Transaction State Inconsistency during HADR Takeover with Reads on Standby enabled | Availability | |
| DT451130 | Table with column populated by CURRENT TIMESTAMP special register contains higher than expected value after a point-in-time rollforward | Availability | |
| DT450735 | During a forced takeover Pacemaker Monitor script may get timed out due to deactivate command getting hung, causing VIP not to move. | Availability | |
| DT452378 | Receiving SQL0964C error when active log space is not being held back by any inflight transaction | Availability | |
| DT450447 | NON-FATAL ASSERTION message in db2diag.log when multiple paths are specified in automatic backup policy | Availability | |
| DT450126 | db2flsn utility to print the logfile from LRI returns that the log file is unused or blank | Availability | |
| DT448298 | Db2 db2flsn utility returns that the log file is unused or blank | Availability | |
| DT446266 | HADR force takeover fails due to monitor script incorrectly monitoring the database resource | Availability | |
| DT450723 | db2cat fails with SQL0100W even though orphan rows are reported | Catalog Services | |
| DT448360 | Segmentation fault might occur with db2look command and db2look output is truncated | Catalog Services | |
| DT424216 | Improving Performance of db2look with the "-L" Flag: SQL1635N Error Returned | Catalog Services | |
| DT450860 | -901 Reason "bad DefaultCod" on columnar table after ALTER COLUMN SET DEFAULT followed by additional ALTER COLUMN on same column | Columnar Storage | |
| DT453913 | Reduce memory allocations in MEMORY_TABLE | Data Management | |
| DT450231 | Crash during a drop database or restore database | Data Management | |
| DT172490 | Loading from cursor fails with SQL6103C in very rare cases | Data Management | |
| DT449768 | INGEST job fails intermittently with DB21018E | Data Management | |
| DT240514 | Debug for FODC_FmpTrap generates SIGILL (AIX) | Data Management | |
| DT147953 | IT41234: INGEST MAY HANG WHEN THE AMOUNT OF SHARED MEMORY IS INSUFFICIENT FOR FORMATTERS AND FLUSHERS | Data Management | |
| DT447063 | The db2profile and db2cshrc scripts attempt to add the missing jline-0.9.93.jar to the CLASSPATH. | Deployment | |
| DT442787 | Security: IBM® Db2® federated Server is vulnerable to sensitive information disclosure under specific conditions (PRISMA-2021-0055) | Federation | |
| DT453753 | Q Capture terminates with rc=3012 when decoding a RENAME TABLE log record | IIDR | |
| DT450290 | SQL Apply ASNLOAD fails with COPY YES | IIDR | |
| DT451244 | ASNCLP CREATE QSUB Message ASN2136W issued for compatible but dissimilar column types doesn't contain column name | IIDR | |
| DT451655 | Apply doesn't report an EXCEPTION for duplicate INSERT on a CONDENSED CCD target when the row contains a LOB value 'OVERSIZED/NOT MODIFIED' | IIDR | |
| DT448591 | Oracle Q Apply inserts incorrect value for SRC_TRANS_ID in IBMQREP_EXCEPTIONS | IIDR | |
| DT451114 | On FPF: stale transaction causes Q Capture to SIGSEGV | IIDR | |
| DT449736 | ASNCLP PROMOTE REPLQMAP with LIKE predicate may incorrectly include QMAPS from the source server that should not be promoted | IIDR | |
| DT448366 | Huge values incorrectly reported in IBMQREP_APPLYMON for tables_loaded, rows_loaded, tables_loaded_physical_size, tables_loaded_logical_size | IIDR | |
| DT448338 | Q Capture gets ASN7099E "column could not be added" on ALTER TABLE ADD COLUMN on a range partitioned table | IIDR | |
| DT447702 | Missing ASN7004E error for ADDCOL signal that specifies a non-existing Column; Return Code 6017 is issued instead. | IIDR | |
| DT423435 | ASNCLP behavior is not aligned when creating a POINT-IN-TIME target Q Sub. | IIDR | |
| DT451388 | List DCS Applications Command Showing Protocol as TCP/IP for SSL/TLS Connections | Process Model | |
| DT448537 | db2support trap in a clustered environment | Process Model | |
| DT443627 | Partitioned table with CHAR or GRAPHIC partition column may fail with default string_units = CODEUNITS32 | Query Compiler | |
| DT450719 | Poor performance when a subquery is used in a WHERE clause | Query Compiler | |
| DT442230 | Using TRIM function in a query may lead to -302 error | Query Compiler | |
| DT444862 | Extra diagnostics to investigate rare trap on package rebind | Runtime | |
| DT448243 | CURRENT LOCK TIMEOUT special register might be ignored on Database Partitioning Feature (DPF) environment | Runtime | |
| DT438681 | Columnar Group-By query fails with assertion in RegularLPHashTableImpl.hpp | Runtime | |
| DT446657 | Performance degradation may occur during sort operation due to extra Flight Recorder log. | Runtime | |
| DT447685 | DECODE gives wrong result with decfloat data type using DB2COMPOPT=NO_DECODE_TO_CASE | Runtime | |
| DT446857 | Delete operation with transient external table failed with SQLCODE -644 | SQL Compatibility | |
| DT445966 | SELECT on an external table fails with SQL20570N and "Error while processing end of record was expected at byte * in data file." when the input file is large. | SQL Compatibility | |
| DT390233 | Upgrade GSKit to 8.0.60.1 | Security | |
| DT449817 | SYSIBMADM.AUTHORIZATIONIDS view does not consider SYSSURROGATEAUTHIDS catalog table | Security | |
| DT443098 | Performance may be impacted when multiple EDUs dump diagnostics due to communication timeouts. | pureScale | |
| DT438938 | Possible deadlatch between CF workers after a communication timeout between member and CF using RDMA network. This may cause a CF failover. | pureScale | |
| DT440664 | remove printf() from signal handler of ca-server | pureScale |
Special Build 63280
2025-07-31 Linux x86 PTF: DYN2507311522AMD64_63280
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT259644 | HADR Standby Database Can Flood db2diag.log with SQL2171N Messages When Replaying a DROP TABLE Statement | Availability | |
| DT174696 | RECOVER DATABASE or ROLLFORWARD DATABASE command fails with SQL10003C. | Availability | |
| DT446123 | High number of latch waits from SYSUSERAUTH cache causing slowdown | Catalog Services | |
| DT425312 | IBM® Db2® is vulnerable to an information disclosure and credential exposure to privileged users under specific conditions. (CVE-2025-36131) | Client & Connectivity | |
| DT443394 | QueryTimeout not working properly on AIX | Client & Connectivity | |
| DT440057 | Failure in streaming QRep replay of IUD operation into columnar table | Columnar Storage | |
| DT440205 | INGEST job fails intermittently with DB21018E | Data Management | |
| DT443419 | In Federated environment distributed XA transactions fail and send xa_end to remote data source | Federation | |
| DT440517 | Q Capture does not detect the end of an aborted transaction in DPF and does not advance the minLSN for some partitions | IIDR | |
| DT440552 | Q Capture should not issue ASN7348W for column organized tables with an unenforced primary key or unique constraint | IIDR | |
| DT440568 | ASNMON fails to suspend monitoring activities when no server_alias is configured in the IBMSNAP_SUSPENDS table | IIDR | |
| DT442857 | IBMQREP_CAPMON max_trans_size is incorrect for global transactions in DPF | IIDR | |
| DT445819 | Buffer Used for Amazon RDS Token Not Cleared, Causing Unexpected Characters | Operating System Services | |
| DT443706 | Monitoring Functions log 'FCM Interrupt' as Severe in db2diag.log | Process Model | |
| DT445755 | Db2 query may generate -901 when distribution key is in equal predicate | Query Compiler | |
| DT446388 | Db2 query may show poor performance when scalar subquery source is also target of data modification of the query | Query Compiler | |
| DT439872 | Large nested DECODE expressions may result in large statement heap usage and possible out-of-memory condition | Query Compiler | |
| DT437847 | Real-time statistics collection for a temporary table during SQL statement compilation can result in a severe error. | Query Compiler | |
| DT442500 | Incorrect result when a Scalar Subquery result is used in a local predicate on the parent operator | Query Compiler | |
| DT437270 | SQL0901N for CDE JOIN queries using LIKE as a join-condition | Runtime | |
| DT438171 | Possible memory corruption running Java functions with multiple schemas | Runtime | |
| DT438749 | Memory leak in db2fmp process when WLM_SET_CLIENT_INFO procedure is called in a connect procedure | Runtime | |
| DT446369 | Connect agents hang if insufficient time passes when audit COS file was last open | Security |
Special Build 62071
2025-07-02 Linux x86 PTF: DYN2507021306AMD64_62071
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT433254 | Pacemaker HADR: takeover might not be initiated due to no order constraint | Availability | |
| DT442874 | ERROR MESSAGE : ZRC=0x80100024=-2146435036=SQLP_NOTA "Transaction was not found" repeatedly dumps in DB2DIAG.LOG. | Availability | |
| DT437293 | Pacemaker fatal error while controld attempts to communicate with a non-existing/respawning attrd | Availability | |
| DT442273 | SQLO_LT_SQLP_LHSH__hshlatch contention with partition table on little endian machine | Availability | |
| DT436367 | db2cm fails to add database mount resource when the instance owner has LANG set to a non-English locale. | Availability | |
| DT435369 | Security Bulletin: IBM® Db2® is vulnerable to a denial of service due to the database monitor script incorrectly detecting that the instance is still starting under specific conditions (CVE-2025-36136) | Availability | |
| DT437731 | Multiple sideward recovery request messages can lead to a double free block failure which causes crash recovery to fail. | Availability | |
| DT437317 | HADR standby database might crash with SIGSEGV on function sqlpAddEntryToTransTable with Reads on Standby enabled | Availability | |
| DT439678 | Memory leak while using db2look for generating DDL for variables and views | Catalog Services | |
| DT438815 | Memory leak when db2dsdriver.cfg has ACR's alternateserverlist section on AIX | Client & Connectivity | |
| DT437666 | SQL30020N received while fetching huge LOB data with 8 rows per fetch. | Client & Connectivity | |
| DT439922 | Native Object Storage Table Space and OS level FIPS support | Cloud Object Storage | |
| DT438178 | Rollforward may fail with SQLU_PRG_ERR when processing a Load Start log record | Data Management | |
| DT440320 | ZERO'ED OUT MEMORY PAGES WHEN DIRECTIO PAGES ARE SWAPPED | Deployment | |
| DT436148 | IBM® Db2® is affected by the vulnerability in corosync library. (CVE-2025-30472) | Deployment | |
| DT437495 | asnqapp reports an SQL100 or SQL803 exception for a columnar table - row not replicated when savepoint rollback for 1st row in a transaction on a columnar table | IIDR | |
| DT438893 | Q Apply data corruption when a transaction is spilled because memory is full and use_stream_trans=Y | IIDR | |
| DT437032 | asnqapp reports SQL100 exception for columnar table when num_apply_agents=1 with use_stream_trans=N | IIDR | |
| DT439742 | FODC_PANIC can occur when resource manager is enabled | Operating System Services | |
| DT437324 | db2start fails on instances created from a payload file installon | Operating System Services | |
| DT438045 | db2support cannot be unzipped due to bad zipfile offset | Problem Determination Tooling | |
| DT436618 | db2support command may hang during db2prereqcheck | Problem Determination Tooling | |
| DT443084 | Performance optimization of certain Db2 commands in a large DPF environment | Process Model | |
| DT439648 | On a DPF environment, slow down may occur due to latch contention during FODC_FCM_Resource data collection. | Process Model | |
| DT437996 | Heavy contention on the SQLO_LT_SQLE_KRCB__stopLatch from the sqlkd_clean_on_close function. | Process Model | |
| DT424885 | -901 or FODC_Trap might occur when running complex queries accessing a mix of replicated and non-replicated tables on MPP environments | Query Compiler | |
| DT439260 | SQLCODE -901 when joining a MEMORY_TABLE or an external table with a column-organized table with a "null = null" join predicate | Query Compiler | |
| DT221739 | Incorrect result with IN/EXISTS subquery predicate and table function | Yes | Query Compiler |
| DT443667 | Procedure with SET CURRENT PACKAGE PATH and Result Set may lead to SQL0501N when closing the cursor of the Result Set | Runtime | |
| DT435355 | In rare scenario, Db2 engine may report -901 with message in db2diag.log "NULL p_var->env!" in sqlra_find_var_var | Runtime | |
| DT439214 | Make registry variable DB2_CDE_SYNOPSIS usable in OPTGUIDELINES | Runtime | |
| DT437205 | In a rare plan , in DPF only, and with two or more ZZJOINs which are not nested, it is possible, with some sections to get a wrong result. | Runtime |
Special Build 59605
2025-05-08 Linux x86 PTF: DYN2505082025AMD64_59605
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT434928 | Crash recovery might fail when searching for a log despite the log existing | Yes | Availability |
| DT426790 | Post adding CLI parameters Patch2=15,25 and Querytimeoutinterval=0 through Windows ODBC Interface SQL30081N is thrown while establishing a connection. | Client & Connectivity | |
| DT435796 | Rebuild synopsis fails with SQL0428N when run using admin_cmd procedure | Columnar Storage | |
| DT426586 | Segmentation fault running XML query | Data Management | |
| DT436492 | Capture cannot replicate TRUNCATE IMMEDIATE in a rolled back transaction after Capture restart if nothing has been replicated yet | IIDR | |
| DT437506 | Improve diagnostic information for investigation of failing AWS S3 requests | Operating System Services | |
| DT437570 | Query on columnar table fails with a trap on LookupGroupingHashTableEvaluator. | Runtime | |
| DT435852 | db2fmp process might trap when dumping thread information | Runtime | |
| DT223226 | Hang and 901 are possible when complex insert from select into a Columnar table is done. | Runtime | |
| DT436914 | During a CF down, a connection attempt to a down CF can lead to slower CF failover. | pureScale | |
| DT426429 | DIA8411C is logged when db2cos is invoked on pureScale environment | pureScale |
Special Build 58840
2025-05-02 Linux x86 PTF: DYN2505020245AMD64_58840
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT387190 | *SQLHA.events.bin file is generated periodically after Restart Light event | Availability | |
| DT434584 | SQL1677N failure during DB2START of the CF on AIX / pureScale | Availability | |
| DT434690 | Overlay IP Resource Created with db2cm Fails to Start on AWS When Network Interface Is Not 'eth0' | Availability | |
| DT422677 | db2mscs "NETNAME_VALUE" maximum length 14 bytes instead of 15 which is MAX_COMPUTERNAME_LENGTH | Availability | |
| DT423510 | Security: IBM Db2 is vulnerable to timeouts under extreme CPU load due to Pacemaker starvation. (CVE-2025-36008) | Availability | |
| DT433753 | CIE00756E Error Logged During Text Search Startup | Client & Connectivity | |
| DT424393 | Insert, update or delete operation could get error allocating an index page. | Data Management | |
| DT198304 | Client Import of boolean values to Db2 server results in all values being true (1) regardless of input values in the .DEL file. | Data Management | |
| DT436692 | Security: IBM® Db2® is affected by a vulnerability in Apache Parquet (CVE:2025-30065) | Federation | |
| DT424150 | IBM® Db2® is vulnerable to a denial of service as the server may crash under certain conditions (CVE-2025-2518) | Federation | |
| DT425663 | Security: Db2 is vulnerable to memory leak when running Federated queries with the certain condition. (CVE-2025-36071) | Federation | |
| DT434688 | Security: IBM® Db2 is vulnerable to a denial of service under specific conditions (PRISMA-2023-0067) | Federation | |
| DT434948 | A transaction issuing a TRUNCATE IMMEDIATE followed by ROLLBACK causes Q Capture to SIGSEGV | Federation | |
| DT434603 | ASN0060E CAPTURE "QASN" : "LogrdThread". The Capture program encountered an internal error "trans::scanDelete" | IIDR | |
| DT434601 | Q Apply fails with "ASN0569E/streamTransMsg is not BEGIN..." | IIDR | |
| DT433451 | Q Capture can fail with openScan -601 when replicating columnar tables on a NON-DPF configuration | IIDR | |
| DT436493 | A truncate Immediate in a ROLLED BACK transaction failed to replicate in DPF for a table defined in a nodegroup that did not include the coordinator node | IIDR | |
| DT436891 | Q Apply reported sql644 when applying changes to Db2 columnar table on DPF | IIDR | |
| DT434608 | Log files in the target ET log directory are not removed when streaming is off | IIDR | |
| DT425868 | In LUW tables with DECFLOAT are not eligible for Multi_Row_Insert | IIDR | |
| DT426704 | Column CCD_KEYUPD_AS_DELINS and CCD_ALLUPD_AS_DELINS are missing in LUW(1140) migration script | IIDR | |
| DT426652 | Poor Q Apply performance for Non-Condensed CCD targets because of high number of KEY_DEPENDENCIES | IIDR | |
| DT435517 | Capture comes down with 6005 when a transaction is aborted in a Non-DPF system with use_stream_trans=y | IIDR | |
| DT433927 | Q Apply "LOAD from CURSOR (REMOTE FETCH)" fails with ASN7530E "RC: 0, SQLCODE: -1001" | IIDR | |
| DT433388 | Wrong SQLCODE displays in SQL Apply log. | IIDR | |
| DT435041 | Restoring from S3 fails with SQL2542N when the backup file is in the root directory | Operating System Services | |
| DT434920 | ListObject requests returns empty result set in REST mode | Operating System Services | |
| DT435737 | db2support may fail when calling ifconfig as it may not exist on all installations. | Process Model | |
| DT437045 | Security: IBM® Db2® is vulnerable to denial of service with a specially crafted query. (CVE-2025-33143) | Query Compiler | |
| DT436605 | Allow repartitioned joins under some additional circumstances when enabled via registry setting | Query Compiler | |
| DT436326 | db2exmig and SYSPROC.SYSINSTALLOBJECTS with action 'M' fail granting privilege when the schema has special characters | Query Compiler | |
| DT436198 | Query on columnar table fails with a trap on LookupGroupingHashTableEvaluator. | Runtime | |
| DT435638 | Security: IBM® Db2® is vulnerable to users regaining access without admin help after account lockout. (CVE-2025-33012) | Security | |
| DT436277 | Lost lock notification during lock connection resync on pureScale. | pureScale | |
| DT436195 | Security: IBM® Db2® is vulnerable to a stack-based buffer overflow. (CVE-2025-33092) | pureScale |
Special Build 57034
2025-04-07 Linux x86 PTF: DYN2504072300AMD64_57034
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT426142 | 'db2trc on' might produce FODC_Trap if using XA | Availability | |
| DT422164 | db2instanceinfo.reg file is missing in HADR with Pacemaker environment. | Availability | |
| DT419943 | Slow log replay during database recovery due to excessive page writes to disk | Availability | |
| DT417099 | Specific catalog cache entry becomes NOT LOADED and causes high x-lock continuously. | Catalog Services | |
| DT425986 | Security: IBM® Db2® is vulnerable to a denial of service under certain conditions (CVE-2025-3050) | Columnar Storage | |
| DT433778 | Security: IBM® Db2® is affected by a vulnerability in the netty library. (CVE-2025-24970) | Federation | |
| DT434402 | Oracle NET8 Wrapper Federated Stored Procedure Support for TIMESTAMP WITH LOCAL TIME ZONE | Federation | |
| DT425654 | Enable referential integrity(RI) dependency through control tables | IIDR | |
| DT422315 | A warning notifying a potential SQLO_SSEM_EXCEEDED_MAX when ipcmni_extend is not enabled is incorrectly logged to db2diag.log at the Severe level. | Operating System Services | |
| DT433958 | Security: IBM® Db2® is vulnerable to running out of memory under certain condition (CVE-2025-33134) | Problem Determination Tooling | |
| DT419596 | Incorrect result when query has UNION ALL that reference same sources in multiple branches. | Yes | Query Compiler |
| DT433822 | Query with "NULL equals NULL" join predicate between two column-organized tables might result in SQL0901N error | Query Compiler | |
| DT433336 | KI DT169432 is missing from Db2 v11.5.9 | Runtime |
Special Build 55706
2025-03-24 Linux x86 PTF: DYN2503242052AMD64_55706
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT418806 | HADR NAT support not working on Windows error SQL1768N RC=4 | Availability | |
| DT425793 | SQLO_LT_SQLP_XID_HASH_BUCKET__xregHshLatch Latch contention in very high concurrent XA workload | Availability | |
| DT426125 | A cluster driven takeover might fail if the takeover occurs right after the HADR state becomes PEER | Availability | |
| DT425011 | dnf fails to resolve Pacemaker package conflicts during update | Availability | |
| DT424932 | db2cluster -cm -enter -maintenance may fail when locale is not English | Availability | |
| DT421871 | Client special registers are not replayed when using WLM if CONDBAT limit is reached on Z/OS. | Client & Connectivity | |
| DT424762 | Replication target table returns incorrect results after TRUNCATE IMMEDIATE is executed on a source columnar table in a DPF environment | Data Management | |
| DT393789 | FODC trap when interrupt the query manually | Federation | |
| DT433150 | Security: IBM® Db2® is affected by a vulnerability in json-smart 2.5.0 (CVE-2024-57699) | Federation | |
| DT423458 | The ALTER SERVER statement is failing when the host, port, and SSL parameters are provided together in a single statement | Federation | |
| DT426619 | Q Rep force abort streamed transaction when db cfg LOG_DDL_STMT=Y and transaction contains any DDL | IIDR | |
| DT425730 | Concurrent db2pd -memblocks on windows may bring Db2 down. | Operating System Services | |
| DT425372 | Fix filesystem error handling for GPFS and EXT4 | Operating System Services | |
| DT422191 | Security Bulletin: IBM® Db2® is vulnerable to a denial of service due to the improper release of resources after use (CVE-2025-36006) | Process Model | |
| DT425933 | In a rare and complex plan using columnar tables we could get odd errors, like -811 or -901 . | Runtime | |
| DT426007 | Interrupt/Force of ADMIN_MOVE_TABLE() procedure can leave EDUs hanging on AIX Operating System. | Runtime | |
| DT406482 | SQL0413N while casting Character datatype values more than 15 characters to Decimal from Column-organized tables | Runtime | |
| DT425966 | Select from administrative view might fail with SQL1042C when AUDIT and VALIDATE are enabled for instance level auditing and KERBEROS or GSSPLUGIN authentication plugins are in use | Security |
Special Build 55285
2025-03-05 Linux x86 PTF: DYN2503051558AMD64_55285
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT213797 | Runtime rollback progress monitor in application snapshot is not correct | Availability | |
| DT424728 | db2cm fails to create Overlay IP resource due to improper handling of AWS instance metadata retrieval | Availability | |
| DT417677 | Incremental backup may fail with SQL2048 rc5 | Availability | |
| DT421677 | db2 backup or restore hangs with high number of buffers | Availability | |
| DT419304 | Applications may report SQL0912N rc=2 even after CF lock memory is already freed | Availability | |
| DT423473 | Failure to connect when using partially NULL connection string | Client & Connectivity | |
| DT422722 | When attempting to bind a file or list of files using a different ID than the default NULLID, the files may be bound using the default ID NULLID instead | Client & Connectivity | |
| DT419242 | Security: IBM® Db2® is vulnerable to a denial of service under certain conditions.(CVE-2025-1000) | Client & Connectivity | |
| DT409120 | Prevention of Index Page Merge from writing beyond the end of the page | Data Management | |
| DT416787 | Prevention of underflowing of pendNotExistCnt | Data Management | |
| DT419372 | SYSPROC.ADMIN_DROP_SCHEMA() fails with SQL0443N and reports SQL1131N from CALL SYSPROC.ADMIN_GET_DEPTREE() when dropping large schemas | Data Management | |
| DT422521 | Rows missing after successful INGEST INSERT RESTART NEW | Data Management | |
| DT422068 | Actual object size is less than computed size error | Data Management | |
| DT420578 | Index keys misordered for Thai codepage 874 | Data Management | |
| DT420578 | Index keys misordered for Thai codepage 874 | Data Management | |
| DT400406 | Some built-in string functions used in querying XML data can produce incorrect results. | Data Management | |
| DT390629 | FODC_ForceDBShutdown due to ADMIN_GET_INDEX_INFO sending request to non-catalog partition | Data Management | |
| DT421381 | Change of ADM6073W message to Info level during db2ckupgrade | Data Management | |
| DT381283 | db2scp binary not updated after installFixPack | Deployment | |
| DT417579 | Security: IBM® Db2® is vulnerable to a denial of service due to insufficient release of allocated memory resources. (CVE-2025-0915) | Federation | |
| DT423222 | Security: IBM® Db2® is vulnerable to a denial of service due to insufficient release of allocated memory after usage.(CVE-2025-1992) | Federation | |
| DT420520 | SQL1822N Unexpected error code "22001" received from data source | Federation | |
| DT425502 | Q Apply gets sql206 replicating a transaction with multiple large statements on columnar tables | IIDR | |
| DT422629 | Q Apply may get SQL0428 for a TRUNCATE TABLE when COMMIT_COUNT is used or SQL0803 when inserting to DONEMSG table | Yes | IIDR |
| DT419625 | Negative value in IBMQREP_APPLYMON | IIDR | |
| DT425584 | REVERT CHANGES TO ALTER BUFFERPOOL MEMORY AFFINITY BEHAVIOUR | Operating System Services | |
| DT422733 | DB2PD MAY FAIL WITH "FAILURE: MAX RESIZE THRESHOLD EXCEEDED | Problem Determination Tooling | |
| DT421608 | db2cos script is lacking necessary data collection for FODC_Member event | Problem Determination Tooling | |
| DT421697 | Change db2diag.log message from "LEVEL: Severe" to "LEVEL: Warning" when a non-existing application is forced off (SQL1230W) | Process Model | |
| DT423953 | Enhancement to dump diagnostics for corrupted collation ID | Query Compiler | |
| DT417652 | Possible performance issue for queries with correlated NOT EXISTS predicate and nested levels of correlation | Query Compiler | |
| DT422178 | Security Bulletin: IBM® Db2® is vulnerable to a denial of service as the server may crash under certain conditions with a specially crafted query (CVE-2025-2534) | Query Compiler | |
| DT419444 | ALTER TABLE to change the column data type may fail if there are constraints on the table | Query Compiler | |
| DT423965 | QUERY THAT USES A SCALAR FUNCTION AND INVOLVES MQT LEADS TO -901 BAD PLAN UNRESOLVED QNC FOUND ERROR | Runtime | |
| DT147951 | IT41213: QUERY WHICH USES ANY SCALAR FUNCTION AND INVOLVING MQT LEADS TO -901 BAD PLAN UNRESOLVED QNC FOUND. | Runtime | |
| DT423223 | Improve interruptibility of queries with very large HSJN inner leg in rowstore. | Runtime | |
| DT416456 | SQL using upper or lower scalar function fails with SQL0001N for CCSID 420 | Runtime | |
| DT423307 | Table access based on rid_bit() returns no rows if rid()/TSN value is high on Column Organized Tables | Runtime | |
| DT148615 | IT38785: SQL STATEMENTS WITH MANY LIKE PREDICATES COULD RUN SLOWER ON V10.5 FP7 AND LATER | Runtime | |
| DT422037 | DIVISION BY ZERO for DECFLOAT does not return SQLSTATE 0168F but 00000 in some cases | Runtime | |
| DT424104 | STORAGE ACCESS ALIAS commands might fail with SQL1741N or write erroneous error messages to the diagnostic log | Security | |
| DT423543 | When communication between the CF and members times out, a large directory named CF_DIAGNOSTICS_DETAIL.* may be generated under db2dump by default. | pureScale |
Special Build 52441
2025-01-10 Linux x86 PTF: DYN2501102124AMD64_52441
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT419493 | db2cluster -cfs -create -filesystem command fails after installFixPack online upgrade with "mmcrfs: The requested format version for the file system (5.1.8.1 - default) exceeds the current committed function level for the cluster (minReleaseLevel 5.1.2)." | Availability | |
| DT406764 | db2cluster -cm -exit -maintenance fails on cluster with more than 8 quorum nodes. | Availability | |
| DT417102 | A database Rollforward command to a point in time or to end of backup in a DPF environment may fail with SQL4973N | Availability | |
| DT417572 | Memory corruption during DPF roll forward of LOAD COPY image | Availability | |
| DT416742 | Filter option of db2fmtlog tool does not handle component correctly. | Availability | |
| DT400782 | First active log file might not move up when an HADR standby database with ROS enabled is deactivated | Availability | |
| DT147866 | IT37708: WHEN NUMBER OF TABLE PARTITIONS IS HUGE(EXAMPLE : 21000), DB2LOOK FAILS TO RECREATE TABLE DDL | Catalog Services | |
| DT419926 | db2 get db cfg + show detail returned wrong value for DECFLT_ROUNDING | Client & Connectivity | |
| DT418725 | CLI Driver: Planned failover intercepted by affinityFailbackInterval | Client & Connectivity | |
| DT417213 | CLP commands in ksh93 can malfunction when "db2" is the last command in a script | Client & Connectivity | |
| DT406719 | CDE Query may fail with SQL0901N Reason unexpected error at PageIteratorForTSNRange.cpp:1808 | Columnar Storage | |
| DT416907 | ADMIN_MOVE_TABLE in pureScale with FORCE_ALL option might take a long time to complete SWAP phase or even fail when running concurrently with other applications that are in the process of rebinding previously invalidated packages | Data Management | |
| DT395300 | Replay of extent movement may hang in a deadlatch | Data Management | |
| DT417977 | Reverting - db2prereqcheck tool is showing AIX requirement for both 11.5.9.0 and 11.5.8.0 as 7.2 TL3 SP3 instead of 7.2 TL5 | Deployment | |
| DT397896 | Security: IBM® Db2® is vulnerable to unbounded recursions due to a vulnerability in protobuf-java (CVE-2024-7254) | Federation | |
| DT400381 | Security: IBM® Db2® is vulnerable to a denial of service due to a vulnerability in protobuf-java. (CVE-2022-3510, CVE-2022-3509, CVE-2022-3171) | Federation | |
| DT398834 | IBM® Db2® is affected by a vulnerability in the hadoop-common library. (CVE-2024-23454) | Federation | |
| DT416751 | Capture may hang when replicating columnar tables with USE_STREAM_TRANS=N | IIDR | |
| DT188249 | Fix ALTER TABLE ALTER COLUMN DROP/SET DEFAULT in v1158 | IIDR | |
| DT241639 | Q Capture program stops even TERM=N is specified when Db2 is down | IIDR | |
| DT407067 | Asnmail failed to send emails due to SMTP server response error | IIDR | |
| DT409136 | debug code for Q Apply when MRI is on | IIDR | |
| DT400993 | asntrc flow output contains incorrect function names | IIDR | |
| DT416815 | Incremental backup may fail with errors in sqloReadVLow | Operating System Services | |
| DT393578 | Db2 operation requests to S3 fails on FIPS-enabled environments | Operating System Services | |
| DT407026 | Improve ossHexDumpLine() resiliency | Operating System Services | |
| DT418607 | DB2SUPPORT COMMAND FAILS WITH ERROR: Error accessing file . | Problem Determination Tooling | |
| DT416755 | SQLO_NOMEM_PCKCACHEH OOM WHEN SMALL PACKAGE CACHE SIZE AND CONSTRAIN MEMORY SET | Process Model | |
| DT417525 | Excessive lock timeouts caused by db2lused | Process Model | |
| DT406942 | Archived log files are deleted in pureScale when a host failed and the affected member cannot move back to its home host | Process Model | |
| DT400682 | Security: IBM® Db2® federated server is vulnerable to a denial of service as the server may crash under certain conditions with a specially crafted query (CVE-2024-51473) | Process Model | |
| DT394980 | db2exmig and SYSPROC.SYSINSTALLOBJECTS fail for explain table migration when the schema has blanks, lower case letters or special characters | Query Compiler | |
| DT396320 | Db2 may encounter a severe error when issuing a query with IN predicate and guideline | Query Compiler | |
| DT409145 | Incorrect result when query has subquery predicate with correlation. | Yes | Query Compiler |
| DT381784 | Db2 may terminate abnormally after upgrade to a new fixpack. | Query Compiler | |
| DT148803 | db2pkgrb terminates abnormally with concurrent call to SYSPROC.ADMIN_REVALIDATE_DB_OBJECTS() | Query Compiler | |
| DT398583 | Security: IBM® Db2® is vulnerable to denial of service under certain conditions using specially crafted statements. (CVE-2024-49828) | Query Compiler | |
| DT418744 | Preventative approach to a rare trap in sort monitoring code with intra_parallel enabled. | Runtime | |
| DT400216 | Table access based on rid_bit() might be slower than rid() on Column Organized Tables | Runtime | |
| DT212894 | Running select statement with LISTAGG(...) WITHIN GROUP(ORDER BY ...) returns error -901 | Runtime | |
| DT146845 | IT34397: A MERGE STATEMENT CAN FAIL WITH AN SQL0901N: REASON (UNEXPECTEDERROR AT TSNRANGEITERATOR.CPP:841) | Runtime | |
| DT417613 | SQL0901N may be returned instead of the actual sqlcode when a statement with maxerrors is executed to an external table. | SQL Compatibility | |
| DT419142 | A bad file might not contain whole field (zone) data in case an external table found bad data in fixed format. | SQL Compatibility | |
| DT417614 | A query to a format-fixed external table with a space to the right of the data in the DECIMAL column returns SQL20570N. | SQL Compatibility | |
| DT416963 | Incorrect "Library is not loaded" diaglog entry from cryptGetSSLApiAddress | Security | |
| DT391670 | GSKit Enhancements | Security |
Special Build 50315
2024-11-01 Linux x86 PTF: DYN2411010131AMD64_50315
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT398812 | Security: IBM® Db2® is vulnerable to a denial of service as the server may crash under certain conditions with a specially crafted query. (CVE-2024-52894) | Availability | |
| DT398584 | Member can hang or crash in pureScale/AIX due to RDMA timeouts | 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 | |
| DT396843 | Application may hang when running the SELECT * FROM SYSIBMADM.DB2_INSTANCE_ALERTS statement in a pureScale environment | Availability | |
| DT394926 | Modify db2pd -hadr so that it no longer obtains a latch | Availability | |
| DT396293 | Db2 Pacemaker Corosync QDevice - Delete Cluster Domain and Read, but crm cluster status still shows old name | Availability | |
| DT395376 | Setting TRACEREFRESHINTERVAL attribute to non-zero value in db2cli.ini file leads to memory leak | Client & Connectivity | |
| DT397282 | db2dsdcfgfill fails to create dsn in db2dsdriver.cfg file when dcs catalog is present | Client & Connectivity | |
| DT396756 | db2prereqcheck is missing a dependency check | Cloud Object Storage | |
| DT398441 | SQL error SQL0901N with reason "unexpected error at TimeStamp.cpp:3395" | Columnar Storage | |
| DT400694 | db2dart might fail to read a page with error code 0x87020036 | Data Management | |
| DT393460 | Replication target table becomes incorrect after TRUNCATE IMMEDIATE is executed on a source database in a DPF environment | Yes | Data Management |
| DT398851 | ADMIN_MOVE_TABLE in pureScale with FORCE_ALL option might take a long time to complete SWAP phase or even fail when running concurrent applications that access the same table using static SQL | Data Management | |
| DT398417 | ADMIN_MOVE_TABLE might change schema of SYSIBM indexes | Data Management | |
| DT392298 | db2hmon waiting in Pending remote request | Data Management | |
| DT389572 | db2prereqcheck tool is showing AIX requirement for both 11.5.9.0 and 11.5.8.0 as 7.2 TL3 SP3 instead of 7.2 TL5 | Deployment | |
| DT397421 | Q Apply re-applies some transactions on restart after coming down for a MQ Client connection error | IIDR | |
| DT397544 | Possible replicated dataloss on DPF when a streamed transaction contains a savepoint rollback because of a statement-level SQL error | IIDR | |
| DT398357 | asnmon should send unencrypted emails if asnmon parms TLS_KEYDB and TLS_LABEL are not set by user | IIDR | |
| DT395180 | QApply fails with ASN0569E and SIGSEGV during initial load of a subscription from z/OS to AIX | IIDR | |
| DT399725 | When using an XML resource policy, the database memory set is not allocated on the proper nodes. | Operating System Services | |
| DT398397 | RESTORE OR CREATE DATABASE MAY FAIL WITH ERROR ECF_INVALID_INVOCATION_SEQUENCE | Operating System Services | |
| DT395188 | Db2 Security Plugin loading failed when using ASAN (Address SANitizer) | Operating System Services | |
| DT399999 | Unnecessary port binding retry although bind might have returned success return code | Process Model | |
| DT396594 | TAB_FILE_ID is inconsistent between mon_get_table and mon_get_locks | Process Model | |
| DT397218 | Potential FCM buffer leak on DPF systems when receiving SQL0803N | Process Model | |
| DT395155 | Client Communication Protocol Monitor Element in Db2 v11.5.9.0 Fails to Correctly Identify TCPIP and SSL Connections in Event Monitors | Process Model | |
| DT398108 | SQL0901N (Reason "unexpected error at Parser.cpp:947".) | Query Compiler | |
| DT389552 | DB2 MIGHT TERMINATE ABNORMALLY FOR QUERIES REFERENCING VERY LARGE CASE EXPRESSIONS IN PREDICATES | Query Compiler | |
| DT395723 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-45663) | Query Compiler | |
| DT396820 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-49350) | Runtime | |
| DT390024 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-41762) | Runtime | |
| DT400964 | Incorrect output format of db2pd -appl | Security | |
| DT397567 | Rare GSKit error 100 from multithreaded Db2 clients when using SSL and an in-memory keystore | Security | |
| DT398093 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-47118) | Security | |
| DT391915 | Unable to form HADR connection in STRICT_FIPS when only TLSV12 is specified in SSL_VERSIONS | Security |
Special Build 47198
2024-09-13 Linux x86 PTF: DYN2409131345AMD64_47198
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT394761 | Execute 'db2cluster -verify -req -rdma_ping' repeatedly may get core dump at sqlhaAddRoutesAndArpsBasedOnSysFile() | Availability | |
| DT381277 | Rollforward using overflowlogpath fails due to read only access to overflowlogpath. | Availability | |
| DT394782 | THE EVMON_UPGRADE_TABLES PROCEDURE LEADS TO A NON-RECOVERABLE LOAD | Catalog Services | |
| DT394248 | db2cat cannot cleanup sysibm.sysrel orphan rows | Catalog Services | |
| DT395574 | -901 error is received when SQL_ATTR_ROW_ARRAY_SIZE set to 8 when the receiving data from a Lob column with data size > 64 k. | Client & Connectivity | |
| DT392626 | Schema filter might not work properly while performing EDMX wizard operation(Updating or Creating Entity Framework Model) through Visual Studio 2019. | Client & Connectivity | |
| DT395876 | ADMIN_MOVE_TABLE might fail with SQL0668N RC 10 on pureScale | Data Management | |
| DT394671 | ADMIN_MOVE_TABLE in pureScale with FORCE_ALL option might take a long time to complete SWAP phase or even fail when running concurrent applications accessing the same table using dynamic SQL | 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 | |
| DT239580 | SQL Apply failed SIGIOT during startup | IIDR | |
| DT394111 | Administration notification log records written by a WSE instance on 11.5.9 Windows corrupts Event log data. | 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 | |
| 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 | |
| DT395960 | SQL0901N when UNION has more than 64 branches | 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 |
| DT393202 | low selectivity estimate of IS NULL predicates results in less optimal plan execution | Query Compiler | |
| DT380744 | Rare sigsegv when HSJN is done in Columnar logic on Columnar Tables | Runtime | |
| DT391953 | Potential memory leak in java heap if SP/UDF implemented by java | Runtime | |
| DT396187 | Intermittent GSKit error 106 from multithreaded Db2 clients when using SSL and an in-memory keystore | Security | |
| DT396218 | CF asserts during member shutdown can cause crash of CF | pureScale |
Special Build 46591
2024-08-21 Linux x86 PTF: DYN2408212104AMD64_46591
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 | |
| DT386697 | db2cm -import fails on Mutual Failover instance on Pacemaker cluster environment that uses a qdevice | 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 | |
| DT392845 | Table columns may contain bad default which will cause SQL0901N | Catalog Services | |
| DT391371 | Altering column data type from CHAR to VARCHAR may corrupt default insert length/value. | Catalog Services | |
| DT394113 | pureScale instance may panic when unfixing a page due to an invalid page latch | Data Management | |
| 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 | |
| DT387637 | Incompatibility between Db2 11.5.5+ client and Db2 11.1.4.7 server for INGEST command | Data Management | |
| DT393712 | SQL Update on Column-Organized Remote Table on Federated Database might fail with SQL1667N | Federation | |
| DT382287 | Security: IBM® Db2® is vulnerable to denial of service under specific conditions (CVE-2024-37071) | Federation | |
| DT393166 | SQL Capture should ignore row Opcode 6 | IIDR | |
| DT394335 | Q Capture incorrectly replicates a row that is rolled back because of duplicate key violation | 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 | |
| DT393449 | Backup/Restore operations may abort due to SQLO_ADDR_CONFLICT error of db2vend process. | Operating System Services | |
| DT214893 | FODC_AppErr doesn't use the path configured by "db2pdcfg -fodc FODCPATH= | Problem Determination Tooling | |
| DT392571 | Event Monitor application handle may be stuck in Pending remote request on pureScale or DPF systems. | Process Model | |
| DT381925 | Connection retry logic should be avoided for down members in pureScale | Process Model | |
| DT387634 | Calling the EVMON_FORMAT_UE_TO_TABLES procedure may take time and it cannot be forced | Process Model | |
| DT394272 | Scalar Subquery joined with Base Table participating in Outer Join may cause poor performance | 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 | |
| DT364145 | Performance issue for queries with Left Outer join referencing a correlated scalar sub-query in the ON clause | 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 | |
| DT391848 | A CF hang can occur during a gbp page dump from a FODC_INDEX | pureScale |
Special Build 43682
2024-07-03 Linux x86 PTF: DYN2407032047AMD64_43682
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT390383 | Security: IBM® Db2® is vulnerable to an information disclosure under specific conditions (CVE-2024-40679) | Availability | |
| DT387031 | db2cm -copy_resources is not copy db2fs and db2partition | Availability | |
| DT383079 | Running db2cm commands such as 'db2cm -create -cluster' with db2locssh fail | Availability | |
| DT389438 | list active database command does not show SQL1611W even if no database is activated | Client & Connectivity | |
| DT386318 | BLOB data returned in different order incorrectly when BLOB data size is > 64k and SQL_ATTR_ROW_ARRAY_SIZE is set to 8. | Client & Connectivity | |
| DT269809 | db2dsdcfgfill causing Segmentation fault | Client & Connectivity | |
| DT383007 | Security: Db2 is vulnerable to a denial of service when querying certain tables using a specially crafted statement (CVE-2024-35152) | Client & Connectivity | |
| DT386729 | Hang due to deadlock between SQLB_BPD__bpdLatch and InsertRange__mConcurrentInsertLatch when updating a columnar table with LOBs | Columnar Storage | |
| DT390408 | Enable db2pdcfg -cos off for db2cos_indexerror scripts | Data Management | |
| 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 | |
| DT148397 | IT37721: LOAD INTO SMALL MDC TABLE MAY FAIL IN SQLBPURGEORFLUSHALLPAGESINSMALLRANGE, MAY CAUSE DB SHUTDOWN AND CRASH RECOVERY FAILURE | Data Management | |
| DT391187 | The db2jcc_license_cisuz.jar file is shipped with Db2 images from v11.5.6.0 upwards | Deployment | |
| DT380323 | Security: Db2 federated server is vulnerable to denial of service with a specially crafted query under certain conditions (CVE-2024-35136) | Federation | |
| 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 | |
| DT382046 | Deactivate subscription if DCC is turned off while Capture is running for an active subscription | IIDR | |
| DT383101 | Q Capture should allow the use of wildcards for schema/table name in IBMQREP_EXCLSCHEMA | 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 | Yes | Query Compiler |
| DT386007 | Poor performance of internal procedure SYSIBM.SQLPROCEDURECOLS resulting in high CPU usage | Query Compiler | |
| DT383082 | CREATE OR REPLACE SQL routine fails with SQLCODE -901 "No procedure package found in sysdepencies" | Query Compiler | |
| DT386505 | Input JSON to JSON_TO_BSON function not validated for uniqueness before conversion to JSON | Runtime | |
| DT387010 | Performance issue is possible with extra Flight Recorder information being logged. | Runtime | |
| DT386079 | -901 error and FODC_AppErr dump when a datetime result exceeds the valid range of dates | Runtime | |
| DT382454 | STATEMENTS ON TABLE WITH LOB COLUMNS WITH LARGE NUMBER OF ROWS MIGHT DUMP AND RETURN SQL0901N | Runtime |
Special Build 42449
2024-05-18 Linux x86 PTF: DYN2405180105AMD64_42449
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT378347 | "The registry does not exist" error message in db2diag.log for db2instanceinfo.reg file | Availability | |
| DT378855 | CF communication may time out when FODC diagnostics are dumped | Availability | |
| 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 | |
| DT381031 | db2cleancat not checking orphaned rows | Catalog Services | |
| DT366161 | Update outdated apache-mime4j-core jar. | Client & Connectivity | |
| DT364439 | When retrieving rows with decfloat values as -NaN and -SNaN using ODBC in a C or C++ program, the sign is lost. | Client & Connectivity | |
| DT381033 | Instance traps while attempting to use Native COS tablespaces on a platform where they are not supported | Cloud Object Storage | |
| DT381542 | Poor performance when doing a high number of inserts to column organized tables | Columnar Storage | |
| DT380591 | INSPECT command on a corrupted column-organized table results brings down the database with error code SQL1224N and FODC_Trap | Columnar Storage | |
| DT380446 | Panic when freeing TableAccessor during TRUNCATE TABLE | Columnar Storage | |
| DT363631 | Poor performance during inserts into columnar tables due to high contention on database heap latch | Columnar Storage | |
| 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 |
| DT381196 | -902 returned by db2ReadLog API when attempting to decompress the compressed row image in the log record | Data Management | |
| DT276217 | after ADMIN_MOVE_TABLE NOT ENFORCED constraints might be missing | Data Management | |
| DT378207 | Error message in db2diag.log can be ignored (sqldProcessIxmSettingsRegVar, probe:5495) | Data Management | |
| DT364325 | db2fmtlog not formatting "Delete LOB data" and "Non-update LOB data" log records | Data Management | |
| DT364320 | Excessive latch contention on SQLO_LT_SQLB_DIRTY_LIST_SET__walkLatch when DGTTs/CGTTs have indexes | Data Management | |
| DT270356 | Db2 tools permissions read only after being moved to a new folder location | Deployment | |
| DT381851 | Security: Db2 federated server is affected by a vulnerability in an open source library bcprov-jdk18on (CVE-2024-30171, CVE-2024-30172) | 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 | |
| DT378957 | Federation SQLServer native wrapper returns incorrect timestamp value on Windows platform | Federation | |
| DT380938 | A query may fail with SQL0101N or SQL0901N when using Federation three part name | Federation | |
| DT260513 | CSE TEMP from remote causing codegen to execute a subsection twice | Federation | |
| DT364021 | SELECT ... UNION SELECT DIGITS(c1) ... ORDER BY MAY RETURN AN INCORRECT ORDER | Yes | Federation |
| 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 | |
| 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 | |
| DT382026 | Trap in dlopen() causes deadlatch with loadquery() called by Db2 signal handler | Operating System Services | |
| DT379919 | Incorrect diagnostics in case tree that reports memory corruption. | Operating System Services | |
| DT259128 | A SQL1646N error returns and the number of threads used by the db2fmp increases. | Operating System Services | |
| DT270233 | DIO with NFS should be restricted to READWRITE/WRITEONLY | Operating System Services | |
| DT365492 | db2support collection get stuck at prerequisite check information step | Problem Determination Tooling | |
| 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 | |
| DT380361 | Existing database connection may hang, when new database creation fails with error SQL1643 | Process Model | |
| DT380116 | On Db2 pureScale Force DB Shutdown Does Not Stop the Database Quickly Enough | Process Model | |
| DT260289 | UPDATE DB CFG command might fail with SQL5124N in DPF or pureScale environment | Process Model | |
| DT378285 | UPDATE DBM CFG IN A CLIENT INSTANCE FAILS WITH SQL5126N AFTER UPGRADING FROM LOWER VERSION. | Process Model | |
| DT381749 | Trap when subquery predicate used with OR | Query Compiler | |
| DT380947 | Poor performance due to missing user selectivity marking | 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 | |
| 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 | |
| DT364003 | FODC_AppErr will be generated for an Update statement when a column from the target of the Update is referenced in the ORDER BY clause of a scalar sub-query in the SET clause | Query Compiler | |
| DT270076 | Security: Db2 is vulnerable to a denial of service with a specially crafted query under certain conditions (CVE-2024-28762) | Query Compiler | |
| DT270401 | Db2 11.5.8. CDE query fails with AssertionFailedException Thrown at JoinSpillInfo.cpp : 4342 | 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 | |
| DT354341 | Database upgrade in a pureScale environment might fail with "SQL0973N Not enough storage is available in the "CF_SCA_SZ" heap or stack to process the statement" | pureScale |
Special Build 40226
2024-03-22 Linux x86 PTF: DYN2403221434AMD64_40226
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| 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 | |
| DT271473 | Diag Mount resource not extended to new host for add/drop CF | Availability | |
| DT260618 | db2cat not generating Packed descriptors with correct codepages properly | Catalog Services | |
| DT269614 | Support Db2 .Net provider for Linux on IBM Z | Client & Connectivity | |
| DT261226 | Slow performance due to excessive db2diag.log function TableInserter::handleTailPageZero entry | Columnar Storage | |
| 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 | |
| DT261574 | Security: Db2 is affected by a vulnerability in an open source library zlib (CVE-2023-45853) | Deployment | |
| DT258225 | Disable message queue creation in db2licd which has been discontinued | 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 | |
| DT257398 | Federation: Performance is bad due to query not pushed down for "no support correlation cse" | Federation | |
| DT261886 | SYSPROC.NNSTAT traps in _IO_vfprintf function call | Federation | |
| DT260107 | The SQL statement or command failed with SQL901 and reason lock not owned by caller | 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 | |
| DT261306 | SQL1652N File I/O error occurred returned on db2start or db2stop in DPF | Operating System Services | |
| 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 | |
| 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 | |
| DT319206 | A way to block calling of calling of UTL_MAIL, UTL_SMTP, UTL_TCP by any and all users. | Runtime | |
| DT276989 | VARCHAR_FORMAT() support for DECFLOAT | Runtime | |
| DT269735 | db2expln command returns a huge optimizer estimate when queries have a IXAND access plan | Runtime | |
| DT261533 | Security Bulletin: IBM® Db2® is affected by multiple vulnerabilities in ICU libraries. | Runtime | |
| DT269600 | varchar_format support for decfloat | Runtime | |
| DT260082 | The query may hang when DB2_MAX_THREADS_PER_FMP is set | Runtime | |
| DT257175 | Return code get can overwritten in message from sqlerCallDL in db2diag.log | Runtime | |
| DT364123 | Replay of a LOAD COPY image stored in Cloud Object Storage may fail with SQL1092N. | Security |
Special Build 39340
2024-02-20 Linux x86 PTF: DYN2402201659AMD64_39340
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| 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 | |
| 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 | |
| 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 | |
| DT258875 | Interrupt Federation NOSQL queries returns error code SQL1476N | Federation | |
| 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 | |
| DT261352 | Files libdb2CosApiS3.so and db2RemStgManager are missing on Linux for zSeries | Operating System Services | |
| DT259936 | Avoid "cannot open file" errors while using rah or db2_all concurrently | Operating System Services | |
| DT258849 | db2support debug information enhancement for db2look output generation failure | Problem Determination Tooling | |
| DT256943 | BDInsights workload query simple-23 fails with SQL0901N against DATALAKE/Iceberg TPC-DS tables accelerated by MQTs stored in Db2 Native format on Cloud Object Storage (NCOS) | Query Compiler | |
| DT259695 | db2exmig moving to Db2LUW v11.5.9.0 fails on Windows platform | Query Compiler | |
| 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 | |
| DT261258 | Under RHEL 8.6 operating system, pureScale users may see high CPU usage on their system. | pureScale |
Special Build 39210
2024-02-07 Linux x86 PTF: DYN2402071931AMD64_39210
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| 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 | |
| DT258379 | db2cm -list fails to determine active state of HADR database resources on RHEL 9 | Availability | |
| DT259092 | Db2look missing SET CURRENT SCHEMA statements for variable DDL in output | Catalog Services | |
| DT258325 | db2cat not generating Packed descriptors related with timestamp scale/precision properly | Catalog Services | |
| DT258452 | Multiple queries can hang in compilation caused by deadlatch involving SQLO_LT_sqlrlc_sysuserauth_cache_cb__defunct_list_latch | 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 | |
| DT259443 | Using DB2_USE_ALTERNATE_PAGE_CLEANING might, over time, clean dirty pages more aggressively than expected | Data Management | |
| DT258500 | ADMIN_MOVE_TABLE option MESSAGES ON SERVER might cause SQL0104N | Data Management | |
| DT258165 | ADMIN_GET_TAB_INFO reports LOB/XML sizes as zero while ADMIN_MOVE_TABLE is in progress | Data Management | |
| DT246121 | SQL2048N might wrongly be raised on a backup operation when registry DB2_BCKP_PAGE_VERIFICATION=TRUE | Data Management | |
| DT258954 | db2installPCMK fails when updating from db2 image with pcmk-docs to one without | Deployment | |
| DT258536 | Undefined user tenant receives SQL0270N Function not supported (Reason code = "125") when federating to Db2 for z/OS | Federation | |
| DT257584 | NNSTAT reports SQL20274W error | Federation | |
| 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 | |
| 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 Cumulative Special Build | 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 | |
| DT260222 | CAST from BINARY type to DECIMAL fails with -901 error sqlerrmc: unexpected error at DecimalCore.hpp:308 | 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 an 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 | |
| DT255491 | varchar_format prefixing with 0 when the number is passed in exponential format resulting in inconsistent output | Runtime |
Special Build 38308
2024-01-10 Linux x86 PTF: DYN2401101820AMD64_38308
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT258086 | db2scp breaks due to default behavioral change of scp in openssh | Availability | |
| 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 | |
| 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 | |
| DT237982 | DELETE from ORC ACID Hadoop table fails to delete all matching rows | Yes | Big SQL |
| 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 | |
| DT257417 | Two Phase Commit is not working as expected with the Db2 V1159 Restricted TCP/IP listener mode enhancement | 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 | |
| DT244554 | Catalog DCS directory command allows db name to be more than 8 characters but fails to uncatalog the same. | Client & Connectivity | |
| DT246809 | FODC_Panic with ASSERTION FAILED!!! on kvStorageImpl.cpp line 5831 | Cloud Object Storage | |
| DT255163 | REMOTE_TIER_ metrics not reported correctly. All COS read/write activity monitored in COMPACTION_TIER_ metrics. | Cloud Object Storage | |
| DT196926 | Queries on synopsis table return invalid dates | Columnar Storage | |
| 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 | Columnar Storage | |
| DT256966 | Queries on Columnar tables may fail with -901, "Unable to access target page from page map" reported in db2diag.log | Columnar Storage | |
| DT246563 | Security: Db2 is vulnerable to a denial of service when a statement is run on columnar tables under specific conditions (CVE-2023-50308) | Columnar Storage | |
| DT246565 | Message SQL0913N with reason code 80 and message "Unable to get insert range for table" in db2diag.log | Columnar Storage | |
| DT247235 | ADMIN_MOVE_TABLE SWAP might fail with SQL2105N RC=11 | Data Management | |
| DT247759 | DB2 MAY TRAP DURING LOCK ESCALATION | 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 | |
| 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 | |
| DT257627 | installFixPack -show_level_info for Db2 11.5.9 shows incorrect "Minimum committed code level required for online install" | Deployment | |
| DT253655 | Permit distinct is added in wrong place in remote statement for outjoin | Yes | Federation |
| DT257503 | Defect fix MS SQL Server rand() in a query predicate not working in CP4D v4.7 | Federation | |
| DT257775 | Db2 federation YEAR() function not pushdown to SQL Server caused low query performance | Federation | |
| DT257776 | CD4D Inline view query fails - SQL1822N - Schema must be specified when session schema is not set | Federation | |
| DT253570 | IN DB2 FEDERATED CERTAIN PREDICATE OPTIMIZATION DO NOT APPLY IN PRESENCE OF NICKNAMES. | Federation | |
| DT256815 | Security: Db2 is affected by multiple vulnerabilities in the open source presto library. | 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 | |
| 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 | |
| DT244749 | Using bulk insert feature to insert data into nicknames might result in Trap | 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 | |
| DT247984 | QApply fails with SQL0193N when processing an ADDCOL on a table with a user defined-type column, because QCapture sends a bad message. | 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 | |
| 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 | |
| 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 | |
| DT247384 | Db2 might crash due a failed semaphore operation (semop OSERR: EIDRM/EINVAL) after accessing a remote storage object (DB2REMOTE) | Operating System Services | |
| DT247998 | Cannot add new member in PureScale due to memory address conflict error | Process Model | |
| DT247649 | COMPACTION column names in MON_GET_BUFFERPOOL, MON_GET_DATABASE and MON_GET_TABLESPACE are wrong | Process Model | |
| DT247624 | Caching Tier Hit Ratio is incorrect | Process Model | |
| DT247203 | Db2 Trap in sqleWLDContinueSpin() | Process Model | |
| DT245132 | Db2 thread may hang when a signal handler is called during the invocation of localtime_r function | 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 | |
| DT237759 | A Db2 query may generate a SQL 901 when using an aggregate function on an expression | 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 | |
| DT221786 | Security: Db2 is vulnerable to a denial of service when using a specially crafted query (CVE-2023-47747) | Query Compiler | |
| DT257996 | SQL0180N WHEN USING CASE EXPRESSION WITH 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 | |
| DT245904 | SQL1042C error reported with SQLJ.RECOVERJAR and SQLJ.INSTALL_JAR for WINDOWS | Runtime | |
| DT245712 | app heap OOM due to huge runtime section allocations | Runtime | |
| DT244709 | Specifying a value outside the column range for the SUBSTR scalar function in CDE query may result in a SQL0901N | Runtime | |
| DT244628 | Rare 901 with SORT using FETCH FIRST N ROWS or LIMIT in columnar engine | Runtime | |
| DT245096 | Rare trap when columnar organized tables are in use and DB2_CDE_STMTCACHING reg variable is set. | Runtime | |
| DT245948 | Db2 does not support PKCS#11 OASIS Standard 2.40 version | Security | |
| DT255389 | GIM Installer is no longer bundled with Db2 | Security | |
| DT245990 | CHANGE THE DEFAULT TLS VERSION TO TLS 1.2 | 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 |
Special Build 37108
2023-11-08 Linux x86 PTF: DYN2311081556AMD64_37108
Downloads
| KI Number | KI Title | HIPER | Domain |
|---|---|---|---|
| DT242860 | Incorrect Output When Running db2level as Non-instance Owner Id in pureScale | Availability | |
| DT241626 | db2cm reports instance does not exist during db2 -create -instance for the remote host when using db2locssh | 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 | |
| DT238214 | HADR_REMOTE_HOST changed from hostname string to IP address after takeover in HADR with multiple standbys environment | Availability | |
| DT189371 | db2cleancat fails with SQL0100W even though orphan rows are reported | Catalog Services | |
| DT238609 | FODC_Panic from db restart/start due to SYSBOOT open error | Catalog Services | |
| DT241645 | FODC_Trap happened when running XA transaction in purescale unfenced DRDA wrapper | 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 | |
| DT243538 | SQLO_SLATCH_CAS64::getConflictComplex reports corrupt latch when releasing extended insert range as part of truncate table | Columnar Storage | |
| DT147957 | IT41481: RUNSTATS CALCULATES PCTINLINED INCORRECTLY WHEN USING TABLE SAMPLING | Data Management | |
| DT178438 | Performance Issue for Windows NT Db2 DSDriver | Deployment | |
| DT241777 | IMPORT on Db2 Federation nickname might cause SQL0440N Error. | 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 | |
| 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 | |
| DT243412 | asntdiff crashes on Windows platform | IIDR | |
| DT215999 | Contention on dbMgrLatch with many client connection termination | Process Model | |
| DT211904 | db2evmonfmt can fail with with DB2 SQL Error: SQLCODE=-20377 | Process Model | |
| DT236687 | Reduce severity level of db2diag probe if it is an interrupt for WLM monitoring functions | Process Model | |
| 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 | |
| DT222859 | Security: Specially crafted statement results in abnormal termination of Db2 server (CVE-2023-38727) | Query Compiler | |
| DT147398 | IT41890: MIN(TRUNC(TIMESTAMP)) THROWING SQL0901N | Runtime | |
| DT238876 | MPP instance might crash with SIGFPE (signal 8) - FODC_Trap is generated | Runtime | |
| DT243612 | SQL0901N during Columnar HSJN with Additional info: Hash Table cannot accomodate any more keys | Runtime | |
| DT242525 | Interrupt to fmp may generate many harmless error message in db2diag.log | Runtime | |
| DT223682 | On 11.5.8.0, java stored procedure may get an exception "java.security.ProviderException: Failed to initialize IBMJCEPlus provider" | Runtime | |
| DT242608 | FODC_Panic might be generated when inserting characters longer than the target column length | SQL Compatibility | |
| DT244530 | Connections using a certificate bundle with simplified SSL might return GSKit error 414 | Security | |
| DT236965 | Security: A vulnerability in libqb affects Db2 High-Availability deployments using Pacemaker (CVE-2023-39976) | Security |
Downloads
Downloads for Special Build 69673
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 Special Build 63280
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 Special Build 62071
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 Special Build 59605
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 Special Build 58840
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 Special Build 57034
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 Special Build 55706
Linux
Downloads for Special Build 55285
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 Special Build 52441
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 Special Build 50315
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 Special Build 47198
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
Downloads for Special Build 46591
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 Special Build 43682
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 Special Build 42449
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 Special Build 40226
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 Special Build 39340
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 Special Build 39210
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 Special Build 38308
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 Special Build 37108
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
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":"a8m50000000L2QmAAK","label":"Install\/Migrate\/Upgrade-\u003ESpecial Build"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
07 November 2025
UID
ibm17087189