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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Allow table compression to be disabled for DGTTs and CGTTs
In short: OLTP applications frequently encounter performance issues because DB2 enables table compression by default for all DGTTs / CGTTs. Details from a real-time example: When inserting 40K rows to a DGTT, it takes 2 seconds. When we immediatel...
Allow SELECT INTO to assign query results to Local Variables within a Function/Procedure
When trying to assign a query result to local variables within a PROCEDURE or FUNCTION using Dynamic SQL only a DYNAMIC CURSOR (see below) can be used which leads to more complicated and lengthy code. However, using SELECT INTO (see below) could b...
Allow Table-Valued-Function (TVF) within DB2 SQL PL Module
Within a SQL PL MODULE, a Table-Valued-Function/TVF cannot be created, but outside of a MODULE, this can be done. This seems to be a restriction on MODULE functionality given that they are an analog to PL/SQL PACKAGES. Our request is to allow the ...
Global Variables: A global variable can be created with a default value. Each session that uses it will then instantiate a version of that global variable, with the default value and any change in the value is limited in scope to its unit-of-work....
Unique return code for attempts to grant access to statistical views
When a grant of access to a statistical view is attempted, the error message returned is -551, you lack the authority to do the grant. In actuality, no amount of authority will allow the grant of access to a statistical view.
Eliminate a lock needed by a SELECT statement in order to performance a query without need to implement a dirty read - UR.Although there is a solution doing an uncommitted read on the transaction, it requires an application modification changing t...
Oracle supports disabling index in ALTER INDEX command.
Disabling an index means that the index still exists in the database, but it is not included in the optimizer.
It would be also helpful in Db2 when find out the optimal Index.
Do not place IBM confidential, company confidential, or personal information into any field.