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 950

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...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Allow 3 different options for statement concentration.

We would like 3 options for statement concentration. It is importantthat all three options are available. 1. No concentration. (already exists) 2. Concentrate queries that have no parameter markers (Current DB2 concentration) 3. Concentrate querie...
over 10 years ago in Db2 for z/OS 1 Not under consideration

force a timeout of threads that are holding latches for a specified period of time

Due to HW failure a thread was 'hanging' in db2 system holding a latch. Db2 system will remain in that status for ever. We were not able to identify the thread, and it was not possible to cancel the thread externally. Are looking for Db2 to 'timeo...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Add the SECTNO value to any IFCIDS currently containing STMTNO information, ideally the IFCIDS 53/58/59/60/61/64/65/66

Add the SECTNO (SYSPACKSTMT) value to any IFCIDS currently containing STMTNO information, ideally the IFCIDS 53/58/59/60/61/64/65/66, minimally the 53/58. Without this information it is difficult for Strobe to match up the SQL statement that is be...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Increase the limit of 100 ckpts entries in BSDS

BACKOUT YES specifies the recovery of objects to a prior point in time by a log-only backout. No image copy is restored, it uses the log to backout changes made since the log point that is specified in the TOLOGPOINT or TORBA options. So we sugges...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Display severity code in DSNUxxxxI message

DB2 only provides highest return code at then end of job, often we need to review the output of the reorg jobs to find out abnormal activities. Is it possible to display the seveirty code along with the current text for each DSNUxxxxI message ? Th...
over 10 years ago in Db2 for z/OS 1 Not under consideration

IFCID 172/196 (Deadlock/Timeout) – Add STCK for Held Locks

At IFCID 172/196 (Deadlock/Timestamp) please add a STCK for the held lock (blocker) when the lock was granted. In case of a lockout with this STCK the sequence of the locks, and so the sequence of the blocker-SQLs, can be reconstructed ‘post mor...
over 10 years ago in Db2 for z/OS 1 Not under consideration

Protocol the SQL in SYSPRINT for DSNTIAUL

We often use DSNTIAUL to access data. At the moment you can't see the executed SQL in the job output. If DB2 protocol this it will be very helpfull. Proposal is to write it to SYSPRINT ( default ) and/or controll the output DD via a paramter.
over 10 years ago in Db2 for z/OS 0 Not under consideration

Allow Functions / Expressions to be used with multi row insert

Please allow expressions and or functions to be used within a multi row insert statement. I have an application inserting 1000 rows via multi row insert and the table has the POINTS columns which needs to be populated using the function ST_POINT. ...
almost 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...
almost 11 years ago in Db2 for z/OS 1 Not under consideration