Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


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.

ADD A NEW IDEA

My votes: Db2 for i

Showing 189

ACS Content Assist does not use the correct Schema when changed

In IBM i Access Client Solutions v.1.1.8.3 there is a new Content Assist feature by using the Ctrl and Space Bar keys. However if you change the Connection and apply a new JDBC configuration it will not pickup the correct schema even though it is ...
about 5 years ago in IBM i / Db2 for i 1 Delivered

DISPLAY_JOURNAL UDTF enhancement request

DISPLAY_JOURNAL UDTF currently accepts library and object as parameters and also if object name is not specified, it defaults to "ALL" for the library. We would like to request for an enhancement where this UDTF can accept a list of objects as par...
about 5 years ago in IBM i / Db2 for i 1 Delivered

add open file in (QDMLOPNF) to GET_JOB_INFO table function

please add to GET_JOB_INFO table function the jobs open file information as provided with API QDMLOPNF Use Case: none of the current SQL functions provide this information which will be helpful when looking for certain file information across jobs...
over 5 years ago in IBM i / Db2 for i 5 Delivered

IBM i Service to List Disabled Netserver Users

Currently, there is no way to list from an IBM i command the user that at disabled for use by Netserver. An IBM i Service to list the currently disabled users, and if possible re-enable them would be an ideal replacement. I accept that the Go Nets...
over 5 years ago in IBM i / Db2 for i 9 Delivered

SQL drop if exists

Please provide an IF EXISTS option on the DROP statement. For tables we have a CREATE OR REPLACE CONSTRUCT, however this isn't available for indexes/views/procedures... While a compound statement works, it requires multiple lines of code which is ...
over 5 years ago in IBM i / Db2 for i 3 Delivered

Ending jobs controlled when HTTPPOSTCLOB (generally a ibm jvm) is involved

We are on a V7R2 IBM i machine:We have many self programmed prestart jobs which are correctly shut down onsubsystem end with option *cntrld. This was realized by evaluating thejob-end-flag in the main cobol program. Now we faced a problem with the...
over 5 years ago in IBM i / Db2 for i 4 Delivered

Add IBM i Services to return a list of active watches as well as the information about those watches

There is the WRKWCH command as well as the Retrieve Watch Information (QSCRWCHI) and Retrieve Watch List (QSCRWCHL) APIs. This RFE is requesting IBM i Services to provide this information. Use Case: I want to ensure my watches are active; I really...
over 5 years ago in IBM i / Db2 for i 5 Delivered

Name the SQL programing language PL/SQL on IBM i

When coding stored procedures, UDTF and compound statement we have a nice language without a name. To be consistent across the industry it seems like the name PL/SQL (Procedural Language/Structured Query Language) is used for other databases - inc...
over 5 years ago in IBM i / Db2 for i 2 Delivered

Serverresponse is missing for systool functions like httpputclob

Serverresponse is missing for systool functions like httpputclob, httppostclob, etc.Even the httpputclobverbose function only returns the http header messages. But the responsemessage from the server that identifies the real problem will not be re...
over 5 years ago in IBM i / Db2 for i 1 Delivered

Retrieve SMAPP information a file

I would like to be able to extract the SMAPP information available thru the command DSPRCYAP in a file. Today the DSPRCYAP command only allows to print the information. The information I am interested in, are:- Estimated system access path recover...
over 5 years ago in IBM i / Db2 for i 4 Delivered