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 984

Allow separate grantable authoriy for REFRESH MQT

The current authorization to issue a REFRESH TABLE on an MQT is the following (this is true up through and including v12): https://www.ibm.com/support/knowledgecenter/en/SSEPEK_12.0.0/sqlref/src/tpc/db2z_sql_refreshtable.html The privilege set for...
almost 5 years ago in Db2 for z/OS 1 Not under consideration

Make IDAA SQL Extensions available to the Db2 SQL API

By attaching an IDAA to our Db2 for z/OS we are adding analytics capability to the mainframe. Our data scientists are starting to exploit the capability, but need more SQL functionality (scalar functions) to be able to do analytics on all types of...
about 7 years ago in Db2 for z/OS 0 Not under consideration

prohibit alter/create tablespace not logged

Performing create/alter tablespace to be not logged might be considered a security problem.A solution for this can be a new ZPARM or a special privilege (in RACF & Db2) that will prohibit anyone from doing so, even SYSADM/DBADM etc. Another "c...
over 7 years ago in Db2 for z/OS 1 Not under consideration

Audit Policy enhancement for Global Temporary Tables

Audit policies are used frequently for us to track for a month the Group IDs read, write, etc of standard Tables of Type P,C,T. We would like be able to use this ability to Audit use of created Global Temporary Tables of Type G as well. This would...
over 7 years ago in Db2 for z/OS 1 Not under consideration

DB2 for z/OS ALTER FUNCTION REPLACE for inline SQL scalar and SQL table functions

Create an ALTER FUNCTION REPLACE statement for inline SQL scalar and SQL table functions such as already exists for compiled SQL functions and native SQL procedures. This would give the ability of the user to modify the source code for these funct...
over 9 years ago in Db2 for z/OS 0 Not under consideration

Request for a new zParm parameter, named for example IXCOPY to be set to YES or NO in order to choose how DB2 creates IX

This RFE requests a new zParm parameter, named for example IXCOPY to be set to YES or NO in order to choose the default for indexes creation:- if IXCOPY = NO (default) DB2 will continue to work as now, that means that DB2 will create all indexes C...
over 9 years ago in Db2 for z/OS 1 Not under consideration

Remove limitation on tables with XMl column

Today there is some limitations on tables with XML column. For example, we can't alter the table with ALTER PARTITION partotion-clause for LIMITKEYS. This limit cause us to drop and recreate the table with a lot of data(xml) and for downtime. We a...
over 2 years ago in Db2 for z/OS 1 Not under consideration

Prohibit inoperative packages after drop function

DROP and CREATE of userdefined function KZZ.LEXSORT set packages KIS##01 and KIS##30 to inoperative. Error in IMS region BOKMSG8F: SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00E30305, TYPE OF RESOURCE 0...
almost 10 years ago in Db2 for z/OS 0 Not under consideration

After START DB2 LIGHT(YES), provide new status messages while waiting for indoubt thread resolution

When DB2 is restartet using the LIGHT(YES) or LIGHT(CASTOUT) clause and indoubt URs exist, DB2 issues message DSNR052I at the end of restart. After this message, there is no acitvity driven by DB2 itself, that allows a monitoring or identifying wh...
almost 10 years ago in Db2 for z/OS 1 Not under consideration

Enhance Profile Monitors

We have just recently started making use of the Profile Monitor We are using it to identify threads connecting with outdated drivers. Would like to be able to have one entry to flag PRDID < JCC041* rather than enter a row for every version that...
over 2 years ago in Db2 for z/OS 1 Not under consideration