Skip to Main Content
IBM Data Platform Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data Platform 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 for z/OS

Showing 456 of 2588

Allow alter column to drop NOT NULL constraint

Currently the only way to remove the NOT NULL constraint from a column is to unload the table, drop-recreate table (or drop-add column) and reload table. Such a small change needs so much effort, and causes unnecessary outage and service disruptio...
over 1 year ago in Db2 for z/OS 1 Not under consideration
18 MERGED

EXPLAIN(ONLY) should create no locks

Merged
We did an rebind packages with EXPLAIN(ONLY) with an owner change and got into problems because rebind phase-in was not used. So there were a lot of locks which caused timeouts. The owner change for EXPLAIN(ONLY) is needed for a vendor tool. We th...
over 1 year ago in Db2 for z/OS 1 Delivered

Inheritance of PRIQTY/SECQTY Parameters for LOB and Index Spaces in Newly Activated PBG Partitions

In a Universal Table Space (UTS) defined as Partition-by-Growth (PBG), when a base table includes a LOB column, the initial LOB table space and its associated index can be explicitly defined with specific primary and secondary space allocation par...
about 1 month ago in Db2 for z/OS 0 Under review

Wrap-around PBG table optimized for time-series data

Add support for a new type of PBG table/tablespace which is optimized for time series data, such as that used for journaling, logging, staging, history collection, etc. The main feature of this new PBG table/tablespace is that data is always inser...
7 months ago in Db2 for z/OS 1 Under review

Way to tell if a Db2 view is not being used any longer

We are looking for a solution to tell if a Db2 view is still used or not.A request came to our team to rename a column in several tables. One of the tables have multiple view on it, and one of the view includes the column to be renamed. We cannot ...
over 1 year ago in Db2 for z/OS 4 Future consideration

Enable customers running 24/7 to create unique indexes

Our Internet and Mobile applications are used 24/7 and we do not have any batch windows nor any maintenance windows. When creating new indexes on existing tables the a CREATE INDEX operation generates an unwanted outage when created with DEFER NO....
almost 9 years ago in Db2 for z/OS 5 Future consideration

Instrument workfile high-watermarks in ACCTG

This would be useful to all business users that seek to tune their installation for best performance; specifically in the area of MAXTEMPS. Instrument IFCID 0003 and IFCID 0148 counter(s) to show the maximum amount of Workfile used by a thread (4K...
almost 2 years ago in Db2 for z/OS 1 Delivered

Add auditing to Db2 profile tables

We need a way to determine who/what/when changed something on the profile tables. DSN_PROFILE_TABLE DSN_PROFILE_ATTRIBUTES Current tables have timestamp but it's static. Would be nice to have row change timestamp added so we have both insert and u...
12 months ago in Db2 for z/OS 1 Future consideration

Support for CREATE INDEX DEFER YES DEFINE NO would be very usefull for Spaces with a 'high' number of partitions to avoid timeouts on SYSTSTAB.

When using "CREATE INDEX DEFER YES DEFINE NO", "DEFINE NO" is ignored with SQLCODE 20122 and the VSAM Clusters are created anyway. Doing this for a partitioned index on a partitioned table with lots of partitions (400+) the runtime of CREATE INDEX...
9 months ago in Db2 for z/OS 1 Not under consideration

Prevent package invalidation after ALTER TABLE ROTATE

System: Production management databaseActor: Developers maintaining the databaseDescription: Our customer runs a 24/7 production management OLTP system with IMS V10 and DB2 V9 for z/OS on which its transaction rate gets as high as 10 trans/sec, an...
over 12 years ago in Db2 for z/OS 1