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 for z/OS

Showing 792

Explain STMTCACHE By DSG instead of 1 member

EXPLAIN STMTCACHE ALL will only enter data into the DSN_STATEMENT_CACHE table for the member of the datasharing group on the LPAR which it's running. To get all of the dynamic SQL stats, the EXPLAIN has to run multiple times. Have the ability to e...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Enhance DSN1COMP to allow more than one input per job step

Currently only one full copy image may be included in each job step //jobname JOB acct information//COMPEST EXEC PGM=DSN1COMP,PARM='FULLCOPY'//STEPLIB DD DSN=prefix.SDSNLOAD,DISP=SHR//SYSPRINT DD SYSOUT=A//SYSABEND DD SYSOUT=A//SYSUT1 DD DSN=COPY...
almost 5 years ago in Db2 for z/OS 0 Not under consideration

Allow for LISTDEF Processing and Template when specifying FROMCOPYDDN on an UNLOAD

Details: 1) Site has multiple tablespaces that use a consistent naming scheme for image copies.2) Manual does not mention use of "template-name" in the FROMCOPYDDN line of the "source-spec" section of the "UNLOAD" page.3) Receive following error w...
over 8 years ago in Db2 for z/OS 1 Not under consideration

Separate workfile allocation into different latches

Currently, the WACT latch governs all workfile allocation usage. When the customer ran workload failover testing, the WACT latch proved to be a bottleneck. Root cause analysis determined that the bottleneck came from the fact that multiple types o...
almost 4 years ago in Db2 for z/OS 3 Not under consideration

Authorization for ALTER Commands at schema level

Our DBA team receives countless requests to reset sequence values for our developers. This is a tedious task that should be a self-service task for our developers. We need some mechanism to allow our developers the ability to alter these sequences...
almost 4 years ago in Db2 for z/OS 2 Not under consideration

CHECK DATA for informational referential constraints

We use informational referential constraints, i.e. foreign keys defined as NOT ENFORCED for some relationships between tables. When running the CHECK DATA utility for a table with foreign keys defined as NOT ENFORCED the foreign keys are not check...
almost 7 years ago in Db2 for z/OS 1 Not under consideration

Identify a more representative selectivity for common predicates

Our queries have predicates that many queries share in common where the default selectivity is significantly outside the range of what ever actually occurs. This results in poor and/or unstable query performance. For common predicates with high un...
almost 11 years ago in Db2 for z/OS 1 Not under consideration

Allow Multiple Dataset Inputs to DSN1PRNT

Allow more than 1 input dataset for use with the DSN1PRNT stand-alone utility. This would function as a concatenated list under the SYSUT1 DD.
almost 6 years ago in Db2 for z/OS 1 Not under consideration

PLANNAME and PROGNAME in error-message if PROGAUTH(ENABLE) error

Hi When a program fails e.g. with reasoncode 00F3003B, I want to see in the error message, which row DB2 tried to find in SYSIBM.DSNPROGUATH, i.e. I need program- nad planname.
almost 8 years ago in Db2 for z/OS 1 Not under consideration

Db2 for z/OS: Change SETCURRENTVERSION via Reorg

Now, the Repair Utility with option SETCURRENTVERSION has to be used, to change all v0 tables to the highestVersion. Unfortunately this action is not concurrent. It would be better to have the the opportunity to do that with an online reorg.
almost 6 years ago in Db2 for z/OS 1 Not under consideration