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

Clear

Db2 for z/OS

Showing 1068

zIIP Eligible Q-APPLY

Currently the SQL Queries in QREP Apply are CPU-intensive. The CPU cost of those queries cost more than our top 5 application programs combined. We recommend to make Q APPLY Queries zIIP eligible to reduce the CPU cost for QREP APPLY.
8 months ago in Db2 for z/OS 1 Not under consideration

Allow for an option in the syntax of a (compiled scalar) SQL function to use RELEASE(DEALLOCATE).

Thread reuse and High performance DBATs are dependent on packages being bound with RELEASE(DEALLOCATE). But, there is no provision for the package associated with compiled SQL scalar functions to have RELEASE(DEALLOCATE) as an option. I have been ...
over 7 years ago in Db2 for z/OS 0 Not under consideration

RESTORE SYSTEM should support log apply across DSN1COPY and vendor utilities

RESTORE SYSTEM can fail in log apply when there was a DSN1COPY or vendor utility within the log apply range. This occurs because RESTORE SYSTEM uses pageset control log records to determine that a LOG NO utility had been run, and neither DSN1COPY ...
over 1 year ago in Db2 for z/OS 0 Future consideration

Support of static SQL (SQLJ) for IntelliJ regarding Code completion and Error Detection

A lot of customers are using IntelliJ enterprise wide, while still using static sql in Java and therefore have a heavy need for support of the IDE and not just read log output and match it with the code in the editor.
over 2 years ago in Db2 for z/OS 3 Not under consideration

Wrong result from reading Archive Enabled Tables with GET_ARCHVIE set to Y

When reading Archive Enabled Tables we set a value for the global variable GET_ARCHIVE in order to get the appropriate result. If we set it to N only the base table is read. If we set it to Y we want both the base table and the archive table to be...
over 7 years ago in Db2 for z/OS 0 Not under consideration

Wrong result from reading System Temporal Tables with CURRENT TEMPORAL SYSTEM_TIME set to a non-NULL value

When reading System Temporal Tables we set a value for the special register CURRENT TEMPORAL SYSTEM_TIME in order to get the appropriate result. If it is NULL only the base table is read. If it is not NULL we want both the base table and the histo...
over 7 years ago in Db2 for z/OS 1 Not under consideration

RUNSTATS DIRECTORY (DSNDB01) TABLESPACES

Till now (DB2 12) it is not allowed to run RUNSTATS on the directory tablespaces.Because of features like LOB COMPRESSION or SPT01 COMPRESSION it is strongly recommended to have the possibility to run RUNSTATS on the directory tablespaces. We have...
almost 9 years ago in Db2 for z/OS 1 Not under consideration

Use Limitkeys as histogram-stats, if appropriate

Recently we had a Performance Problem where I was requested to collect histogram-stats for a column, which matches the partitioning column. Because this was a big table, running this runstats took about 9 hours to complete. If limitkeys could serv...
over 9 years ago in Db2 for z/OS 2 Not under consideration

LOGICAL PARTITION NUMBER as the target of a partition load

MR081409202 GGDB209015Letus code the logical partition number as the target of a partition load, so we do not have to change our load utility control cards
about 13 years ago in Db2 for z/OS 1 Not under consideration

Restart Time of DB2 should not be dependent on SCA size

During restart of DB2, the time difference between DSNR003I and DSNR004I is a function of the SCA size. Case TS009645595 was opened and has all the details. But in summary: this large time differenece of 30 seconds (in our case) is a function of t...
almost 3 years ago in Db2 for z/OS 1 Not under consideration