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 2592

Add new column in Db2 catalog table

when IBM is planning to add a "LASTUSED" column on the DB2 for z/OS sysibm.systables table.
over 6 years ago in Db2 for z/OS 1 Delivered

DSNADSM for DB2 V11 does not gather information about SYSIBM.SYSSTATFEEDBACK

DSNADSM for DB2 V11 does not gather information about SYSIBM.SYSSTATFEEDBACK – This might lead to incomplete Runstats recommandations when reporting an access path problems via an SQL, as the DSN_STAT_FEEDBACK from the explain tables might not c...
almost 8 years ago in Db2 for z/OS 0 Not under consideration

Update new V12 RTS catalog columns after reorg

In Db2 for z/OS v12, there are new catalog columns in the RTS tables such as:SYSIBM.SYSTABLEPART-TYPE-PAGENUM-BPOOL-PGSIZE-DSSIZE- MEMBER_CLUSTER-COMPRESSRATIO SYSIBM.SYSTABLESPACE-PAGENUM -INSERTALG -PQTY-STORTYPE -STORNAME -VCATNAMEetc. These co...
over 6 years ago in Db2 for z/OS 1 Not under consideration

Apply security restriction in Db2 table only via database connector tools (but not from database objects)

There are few use cases where Db2 table access must be restricted only from DB connector tools(eg; SPUFI, QMF or DSE in IDz or any other DB visualizer) but not from the database object itself. To explain further, we do have home grown tools(x1) us...
over 2 years ago in Db2 for z/OS 1 Functionality already exists

Drop Databases Created by Implicit Mapping Tables

Problem statement/ pain point: We have started to use on-line reorgs without specifying the mapping table because v11 will generate one for you. Pretty cool. Db2 will create a database, DSNnext_db_identity_number, create a table space, create the ...
over 6 years ago in Db2 for z/OS 1 Not under consideration

REPAIR CATALOG TABLESPACE command for xml table space

We are working with OBJECT_CREATE_FORMAT=EXTENDED and with UTILITY_OBJECT_CONVERSION=NOBASIC for a long time without any problem. In the last time we began to work with these parameters in other DB2's that include many tables with XML columns. The...
over 6 years ago in Db2 for z/OS 1 Functionality already exists

Enhance ALTER INDEX that columns can be reordered without drop and recreate

Recently we had a major incidence in production because an automatic bind happened after the drop of an index of a very big table and before the recreate of that index, although the Create used the Option DEFER YES. We wanted to reorder some colum...
over 6 years ago in Db2 for z/OS 4 Not under consideration

Remove some of the restrictions related to SQLCODE -20555

There is currently a restriction on the use of archive-enabled tables and temporal tables in one statement: The execution of this statement leads to SQLCODE -20555: SELECT * FROM DB2.LZTB0586 WHERE VNR IN ( SELECT VNR FROM DB2.LZTB0520) SQLERROR O...
over 1 year ago in Db2 for z/OS 1 Not under consideration

Instrument workfile high-watermarks in ACCTG

Instrument IFCID 0003 and IFCID 0148 counter(s) to show the maximum amount of Workfile used by a thread (4K blocks total, or separate by tables/indexes, or separate by 4K/32K Workfiles -- implementation choice.) It is difficult to manage Workfile ...
over 13 years ago in Db2 for z/OS 1 Not under consideration

DB2 should optimize queries adequately when are missing or out of date

In V12 it was intended to extend the NPGTHRSH to empty tables and to tables with missing stats. The idea was to pick up the appropriate index which means: if a sort can be avoided choose this one, otherwise pick up the index, which has the most ma...
about 8 years ago in Db2 for z/OS 1 Not under consideration