Db2 on-premise

Showing 15 of 17596

Ability for Reorg Reclaim Extents decrease page count from columnar tables

Currently the Page Count (value seen in column COL_OBJECT_L_PAGES from MON_GET_TABLE) is never reduced even after running Reorg Reclaim Extents.In a columnar table that suffers insert/update/delete we may get into a situation where Db2 will indica...

7 days ago in Db2 / Db2 on-premise 1 Under review

1 VOTE

Fix "ZRC=0x870F003E=-2029060034=SQLO_QUE_BAD_HANDLE "Bad Queue Handle" - when db2 utility output is piped

This error has been reported since 2014 and still not fixed as of DB2 LUW CSB build level 2503051558 (March 2025 release). You have updated DT236621 as recently as February 2025 and claim this is resolved; but we are at the March 2025 release and ...

about 17 hours ago in Db2 / Db2 on-premise 0 Submitted

2 VOTE

DB2 LUW version of z/OS Utility Estimator

reference to: https://community.ibm.com/community/user/blogs/soo-kim/2025/02/27/introducing-new-db2-utility-reorg-estimation-featu We would like a DB2 LUW version of the z/OS Utility Estimator to help estimate the duration of planned offline table...

6 days ago in Db2 / Db2 on-premise 0 Submitted

12 VOTE

Db2 Encryption at Rest breaks backup deduplication

For the EU's Digital Operational Resilience Act (DORA) Encryption at Rest is mandatory for many databases. Since we have turned on Encryption at Rest, data deduplication during backups is not working anymore. We always have to save the full 15+ TB...

2 months ago in Db2 / Db2 on-premise 0 Under review

4 VOTE

Replace a brand new server in a pacemaker cluster

Env ====DB2 V12.1.1 (Special Build 54779) with HADR setting on RHEL V9.4 1) HADR Primary : server-1 2) HADR Standby : server-2 3) A single ESE : server-3 Steps ====1) Config server-1 & server-2 as HADR pair2) Config pacemaker to join server-1 ...

24 days ago in Db2 / Db2 on-premise 1 Submitted

11 VOTE

Ability to perform create indexes on a table in parallel

Typically we need to (re-)create multiple indexe’s on a table. Right now this process has to be performed sequentially - index after index - which can take a very considerable time. We would like to see a feature to able to CREATE multiple INDEXes...

4 months ago in Db2 / Db2 on-premise 1 Under review

5 VOTE

remove restriction "rwx" for others from "/tmp" or location configured by DB2TMPDIR variable

To extra secure the server where DB2 software is installed it is preferred to create directories which don't have write and executable rights for others. On this way it prevents an ordinary user to create scripts on its own and execute them. In th...

2 months ago in Db2 / Db2 on-premise 1 Under review

5 VOTE

Automatic Table Partition Creation and Purging Based on Date Expressions

I propose the addition of a native feature in Db2 LUW for automatic table partition management based on a date or timestamp column. Specifically: Automatic Partition Creation: Allow users to define partitioning expressions (e.g., daily, monthly, y...

2 months ago in Db2 / Db2 on-premise 1 Future consideration

6 VOTE

Ability to start/stop Db2 listener without instance restart

During unplanned or planned maintenance work on the database, we need to have the option to quickly block users from connecting remotely on the database. Especially we need to prevent users from implicitly activating the database. Our current work...

3 months ago in Db2 / Db2 on-premise 0 Submitted

4 VOTE

Remote storage and datalake tables for Db2 on AIX

The feature is already available in Db2 for a while, but only supported in (Intel) Linux environments. Many large customers have their Db2 workloads on Power/AIX, benefitting from the platform. To keep Db2 as core component of lakehouse architectu...

7 months ago in Db2 / Db2 on-premise 1 Not under consideration

Please enter your email address

FILTER BY CATEGORY