Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

Search results: Db2

Showing 33

Improved functionality for tablespace fast pre-allocation

My customer is experiencing huge performance problems due to Tablespace Pre-allocation (DB2_USE_FAST_PREALLOCATION).At this time, IOCP Timeout occurs in Db2 and many tossbuffers occur in GPFS.This customer has been struggling with this problem for...
about 2 years ago in Db2 / pureScale 6 Future consideration

Integrated Pacemaker Monitoring & Alerting Functionality

IBM recently integrated the Pacemaker cluster manager in Db2 but the feature has no documented monitoring or alerting capabilities exhibiting best practices. Enlighten customers with Best Practice/Configuration documentation on how to setup the mo...
about 1 year ago in Db2 0 Future consideration

Optimizer does not use HIGH2KEY/LOW2KEY for columns with COLCARD 1

Optimization issue if a business_time_oriented table has only one row. In syscat.columns the content of the business_time columns are detected (high2key, low2key) but the value can not be found in the distribution statistics. This leads default fi...
about 2 years ago in Db2 1 Future consideration

Db2 TOTAL_CPU_TIME monitoring metric on AIX should reflect "wall" CPU time and not use PURR-scaled time reported currently by thread_cputime AIX API

Db2 monitoring interfaces report "CPU time" metric (TOTAL_CPU_TIME), which accounts the time that given activity/request (and all higher level aggregated interfaces) spent actively "on CPU" whilst executing the query. On AIX this information is ob...
almost 2 years ago in Db2 0 Future consideration

ADMIN_MOVE_TABLES needs to support INDEXES on EXPRESSION

ADMIN_MOVE_TABLE (AMT) procedure fails in SWAP phase, if the table to be moved has an expression based index defined. This issue has been lifted partially, as the RENAME of the table is now supported with INDEX on EXPRESSION (IoE). But in our case...
over 2 years ago in Db2 3 Future consideration

Allow REORG INPLACE and modify REORG RECLAIM EXTENTS on ITC tables

Beginning Db2 v10.5, REORG RECLAIM EXTENTS on ITC tables also implicitly performs sparse extent consolidation before freeing empty extents ( https://www.ibm.com/docs/en/db2/10.5?topic=enhancements-reorganization-make-table-maintenance-easier ). Ho...
almost 2 years ago in Db2 0 Future consideration
6 MERGED

Need a utility to defragment large tables in a timely fashion when REORG is unable to reclaim space

Merged
Large, highly volatile, tables can become heavily fragmented when there is a significant amount of daily delete and insert activity. In some cases, the rows deleted don't leave enough empty space on a page for a REORG to clean up or reclaim that s...
over 1 year ago in Db2 / Db2 on Cloud 1 Future consideration

Enhance MON_GET_TRANSACTION_LOG to return Transaction Log number of OLDEST_TX_LSN and the Transaction log number of the minbuflsn recovery information returned by db2pd -dirtypages

Enhance MON_GET_TRANSACTION_LOG to return Transaction Log number of OLDEST_TX_LSN and the Transaction log number of the minbuflsn recovery information returned by db2pd -dirtypages. For example when trying to identify the reason for the First Acti...
almost 2 years ago in Db2 0 Future consideration

Change behaviour of default Fast Communications Manager (FCM) port

Change behaviour of default Fast Communications Manager (FCM) port https://www.ibm.com/support/pages/db2-db2-server-tcpip-port-numbers For Db2 Version 11.5.5 or older, the ports used are 60000 and higher. For example, ports 60006 - 60011 would be ...
almost 4 years ago in Db2 1 Future consideration

IBM Data Server .Net Provider Support For Informix Types DATETIME

Hi, we are in the process of moving from .Net Framework to .Net Core. Currently using the Net5.IBM.Data.Db2 driver connecting through the DRDA protocol.For DATETIME data types we are having trouble searching. A simple query is throwing the excepti...
over 3 years ago in Db2 / Db2 Connect and Drivers 5 Future consideration