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 435

Allow more row value comparisons

Often old tables have two separate columns for a timestamp, a decimal date and time column instead of a single timestamp column. When querying those tables, it would be great if row-value-expressions could not only be compared for equality but als...
9 months ago in IBM i / Db2 for i 1 Future consideration

Support an ADD MEMBER option on the GENERATE_SQL SQL Stored Procedure

Today if the output source file and member do not exist, the procedure fails. I think the proc should add/replace the data in the output member but also add the member if it does not exist.
about 1 year ago in IBM i / Db2 for i 1 Future 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 ...
about 1 year 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.
about 1 year ago in IBM i / Db2 for i 1 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...
about 1 year ago in IBM i / Db2 for i 3 Not under consideration

Provide indicator for internal / hidden journal entries

For ages the DSPJRN command has had the INCHIDENT parameter to include hidden / internal entries in the output; and recently the DISPLAY_JOURNAL table function has been enhanced to provide similar functionality via the INCLUDE_INTERNAL parameter. ...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

I would like to change the default value for the SQL command DROP COLUMN from CASCADE to RESTRICT.

HelloI would like to change the default value for the SQL command DROP COLUMN from CASCADE to RESTRICT. As far as I know, this is not possible. The problem is that I usually enter the DROP COLUMN command as an SQL script in the ACS.And I often don...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

Add a new code for journal record delete's from R/DL to a new code example R/DX.

We use the RGZPFM command regularly as our software is old. We run RGZPFM on all file members on Sundays when we do not have locks on the files. I have a program that goes through all physical files in the user libraries and does a RGZPFM. Due to ...
over 1 year ago in IBM i / Db2 for i 2 Not under consideration

A wrong comment

Today an operator made a mistake in putting the sign in an update SQL stmt, and instead of a hyphen he put two hyphens.The result was catastrophic. Over 700,00 lines have been updated: update TABLE set AMOUNT = ,01--, TAX=123,4where KEY = 1 instea...
over 1 year ago in IBM i / Db2 for i 3 Not under consideration

Include DDM File based-on object information in the QDBRTVFD API

Today, when using QDBRTVFD to retrieve information about a DDMF (DDM File) the based on information returns only the Record Format name, not the file or library (or member) over which the DDMF is pointing. This occurs even when the DDMF is pointin...
over 1 year ago in IBM i / Db2 for i 1 Future consideration