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 226

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

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

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

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

Add format level identifier to journal entries for database journaling

Today, journaling of database supply a lot of usefull information, but one is missing : the format level identifier, in other words, the description of the fields. Why do I need that ? Because sometimles I change a filed in a file. Then this file ...
11 months 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

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.
11 months ago in IBM i / Db2 for i 1 Not under consideration

System i native support for MS-SQL Server Connection

Native Support for System i to connect to MS-SQL Server using the remote Database entry (ADDRDBDIRE).Connection should support SELECT, UPDATE, INSERT to provide a possibility for data exchange.There are exists a lot of open souce tools which works...
almost 9 years ago in IBM i / Db2 for i 6 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...
11 months ago in IBM i / Db2 for i 3 Not under consideration

AES Crypt

Make the AES algorithm compatible with AES calculated by different software platforms. The ENCRYPT_AES sql function can encrypt a DB column. Unfortunately the algorithm is IBM proprietary [The internal encryption algorithm used is from the CLiC To...
almost 2 years ago in IBM i / Db2 for i 1 Not under consideration