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

Db2

Showing 1366

STATUS_CHANGE_TIME Colum doesnt exist in in mon_get views

We are currently working to migrate all our SNAP views to MON_GET views/Functions as SNAP views caused a response spike in our PROD environment recently.We are using STATUS_CHANGE_TIME columns of sysibmadm.applications to check lock waits on the d...
about 5 years ago in Db2 / Monitoring 0 Not under consideration

Ability to query catalog tables and administrative views in stand by

There is an option called Read On Standby (ROS) that allows to connect and perform selects on the standby role of a HADR cluster. However, this is focussed to business tables. I propose the capability to perform selects on the standby but just on ...
over 3 years ago in Db2 / High Availability and/or Disaster Recovery 0 Not under consideration

Evolved dictionary

Affected Product: Db2WoC Evolved dictionary - dictionaries evolve automatically to better quality and data be recompressed without user intervention. GEICO and some other customers like Bank of America (BofA) have been requesting this feature for ...
over 1 year ago in Db2 0 Future consideration

Building better quality dictionaries while doing CTAS in Warehouse SaaS / CP4D SaaS

Product affected: Db2 Warehouse on Cloud Feature affected : CTAS is a Db2 statement - CREATE TABLE AS functionality (CTA) Overview GEICO sees very bad compression as compared to Netezza. Its been observed that currently CTAS uses only the first pa...
over 1 year ago in Db2 0 Future consideration

Foreign key with on update "cascade"

As part of the SQL 92 standard, there is a referential action for foreign key that allows to update on cascade. The following link is the SQL 92 standard:http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt In the Section 11.8, there is the f...
almost 6 years ago in Db2 / Statements (DDL and DML) 0 Not under consideration

Preserve table creation timestamp after reorg-finsished using admin_move_table procedure (online table move)

Following Knowledge Center, https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0024850.htmlwe perform table reorg using admin_move_table . The issue is, after run admin_move_table command, the original...
almost 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

AUDIT to track view access

We would like to get a mechanism to AUDIT the access of views. We already use EXECUTE category but at table level. We do not use EXECUTE category at database level because it could impact the database performance. We tested all AUDIT categories ti...
about 3 years ago in Db2 / Db2 Warehouse on Cloud 0 Future consideration

Prompts for all db2 utility cancellations

I have faced this issue at the beginning of my career. When we ran into some issue with utility hung or ran some utility accidentally don’t know when it will be finished and when can we kill that process. If we give a prompt with some information ...
9 months ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Support log switch under SET WRITE SUSPEND EXCLUDE LOGS

Today Db2 cannot switch to a log file while write suspend. Therefore a archive log gets performed at beginning of write suspend. Then the write suspend can only last and the database can only work until 1 log file gets full. The time a database is...
about 6 years ago in Db2 / Backup/Restore/ Rollforward/ Recover 0 Not under consideration

Backup retention up-to 7 years

For databases that require long-term retention of backups for audit purposes, allow for 7 years of retention for database backups. In terms of restore, we expect to restore only from the same Db2 version and the older files are only for audit purp...
over 2 years ago in Db2 / Db2 on Cloud 0 Future consideration