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

My subscriptions: Db2 for z/OS

Showing 982 of 15493

SQL Pruning for 0 > 1

The following SQL will not do a GETPAGE on 'table1' because the DB2 Optimizer recognizes that the predicate 'WHERE 0 = 1' has an empty result set: Select * from table1 where 0 = 1 The same is true if a date is used.:Select * from table1 where '201...
almost 11 years ago in Db2 for z/OS 1 Not under consideration

Preform "EXCHANGE" to "X" tables in one unit of work

add a feature to the sql exchange command to enable one unit of work for several tables.
almost 11 years ago in Db2 for z/OS 1 Not under consideration

Easier management of DB2 for z/OS DSNWLMJ java environment parameters

I have a suggestion for the file created by DSNTIJMV step DSNTIJJ. The JAVAENV file is created as a separate flat file for each ssidWLMJ job created. If this was a PDS named DSN!!0.JAVAENV(DSNWLMJ), one file would contain all the java environment ...
about 11 years ago in Db2 for z/OS 1 Not under consideration

Provide HWM for maxofilr resources

Neeed to record hwm for MAXOFILR We are a heavy user of lob data. With this zparm MAXOFILR we can control how many lob datasets are being used. But I have no way to determine of the zparm is set high or low. When we hit the value - the transaction...
over 11 years ago in Db2 for z/OS 1 Not under consideration

Process times out due to locks held by another process. Have to resubmit the process.

Process times out due to locks held by another process. Have to resubmit the processes. The first process has an exclusive lock on a row, the second process is trying to run an UPDATE statement (see below) and times out because it can't get an UPD...
over 11 years ago in Db2 for z/OS 1 Not under consideration

Prevent read/write (RW) access as part of CREATE TABLE

Add a clause on CREATE TABLE that controls what state the table(space) is in immediately after the creation - UT,RO or RW (default)
almost 12 years ago in Db2 for z/OS 1 Not under consideration

z/OS sever does not return Arabic data if substr is used for LIKE predicate. String transformation is needed as part of proce

z/OS sever does not return Arabic data if substr is used for LIKE predicate. String transformation is needed as part of processing. Host: z10 – z/OS V1R11DB2 for z/OS version 8.xx (PUT level is current as site is in the process of migrating to D...
about 12 years ago in Db2 for z/OS 1 Not under consideration

Increased flexibility for Resource Limit Facility (RLF)

Currently RLF can govern threads based on the number of service units used. Could it be changed to also cancel thread that exceed either an elapsed time, a number of getpages, a number of sync reads, or a number of async reads. The following would...
about 12 years ago in Db2 for z/OS 1 Not under consideration

-DIS DB(*) SP(*) ADV(AREST) or -DIS DB(*) SP(*) RESTRICT(AREST)

Also se PMR 75265.010.678 i would like to have a command that specific display the AREST restricted state for pagesets DSNI023I -DEP6 DSNIERST PAGESET WP41001D.SCHEDTS 710 PART (n/a) IS AREST ON BEHALF OF UR A773F44FF5E6. BACKOUT TO LRSN CA1F7C7BF...
about 12 years ago in Db2 for z/OS 1 Not under consideration

JOBSTEP NAME PASSED TO DB2 ACCOUNTING TRACES FOR BATCH JOBS

IN the DB2 accounting trace it is not possible to see the step name for a jcl. that is seen as correlation name. So if the same program is called more than once in the same jcl , it is very hard to guess the step which calls the one with the highe...
about 12 years ago in Db2 for z/OS 1 Not under consideration