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

Db2 for i

Showing 418

Add possibility to run an Excel macro from SYSTOOLS.GENERATE_SPREADSHEET

It would be convenient having the possibility to automatically run an Excel macro on a worksheet created by SYSTOOLS.GENERATE_SPREADSHEET. For instance to generate a chart based on the Excel data created.
10 months ago in IBM i / Db2 for i 1 Not under consideration

Add temporal information to commands and not just the system catalog

Add the ability to see temporal relations in the following:- DSPFD- DSPDBR It can be discovered with things likeRetrieve Database File Description (QDBRTVFD) APIhttps://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/apis/qdbrtvfd.htm#HDRTEMPOSys...
about 8 years ago in IBM i / Db2 for i 1 Not under consideration

Allow RUNSQLSTM to support a "continuation character" for very long SQL statements

When coding SQL statements for creating tables or indexes or whatever, we often have a problem formatting very long SQL statements because there is not "continuation line" character supported by the statement processor. The COMMENT ON statement ca...
over 1 year ago in IBM i / Db2 for i 3 Not under consideration

Hope IBM i can have DB2 Order By COLLATION KEY BIT scalar function

Customer need to Order By some DBCS Chinese field by Chinese stroke order. In open platform UDB DB2, can use COLLATION_KEY_BIT scalar function -- https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0050491.htm...
almost 6 years ago in IBM i / Db2 for i 4 Future consideration

Make PTF listing available in XML output

I was looking at all the great "IBM i Services" and I thought of a new one:List the PTF's available at IBM which are not on my system.However I thought of doing it on my own. First I looked athttp://www-912.ibm.com/a_dir/as4ptf.nsf/WWWPTFBYDATE?Re...
about 9 years ago in IBM i / Db2 for i 4 Not under consideration

RGZPFM while active does not always return deleted records space.

RGZPFM while should always return deleted record space. We have a large, always active, file with 1/3 deleted records that RGZPFM while active did not return deleted records space. We run 24/7 & only come down for Cums & OS & barely ma...
10 months ago in IBM i / Db2 for i 3 Not under consideration

Add column and filter for the job's current user to JOB_INFO

I need a way to get the job date from an SQL session so that I can test SQL statements as they might have run in the past using only SQL features. JOB_INFO UDTF only returns job information for the connection user not the current user as is needed...
over 7 years ago in IBM i / Db2 for i 1 Not under consideration

Extend the JOB_LOCK_INFO UDTF to provide the current awaited time

Please extend the JOB_LOCK_INFO UDTF to also provide the current wait duration for pending locks. This would enable easier automatic detection of erroneous locks and hanging jobs.
over 2 years ago in IBM i / Db2 for i 1 Not under consideration

Option to Normalize HTTP_RESPONSE_HEADER Fields (Key Names) in the QSYS2 HTTP Functions

The HTTP header fields are case-insensitive. That is, content-type, CONTENT-TYPE, and CoNtEnT-tYpE are all allowed uses of the IANA registered field Content-Type. Previously, when using the SYSTOOLS HTTP table functions (e.g., SYSTOOLS.HTTPGETCLO...
over 1 year ago in IBM i / Db2 for i 3 Future consideration

Temporal Support For System Tables

V7R3 of Db2 i introduced support for temporal tables. However, it is not possible for an end user to alter the system tables; such as QADBXREF / QADBIFLD, to be defined as temporal. Attempting to alter the table results in the following error mess...
about 5 years ago in IBM i / Db2 for i 3 Future consideration