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 (

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 ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.


My ideas: Db2 for i

Showing 145

DB2 for i PTF services to use ESA configuration for internet access

SYSTOOLS.GROUP_PTF_CURRENCY and SYSTOOLS.GROUP_PTF_DETAILS are great tools to keep track of missing PTFs on a system. When running SQL statement against this view, there is an internet connection from the system to PSP documents. This is a direct ...
over 6 years ago in IBM i / Db2 for i 1 Future consideration

SQL Add ANCHOR DATA To (%TYPE) functionality

The lack of support for the %TYPE or ANCHOR DATA TO for data declarations affects our ability to port databases that use this functionality. We are looking at porting a Postgres based application to IBM i and have a large number of functions that ...
about 5 years ago in IBM i / Db2 for i 2 Future consideration

Add an ANY_VALUE aggregate function

Please add an ANY_VALUE aggregate function, this would simplify queries that group by an id and also require other values that are known to be unique within the group. SELECT a.article_id, ANY_VALUE(a.description), COUNT(*) FROM article AS a JOIN ...
about 1 year ago in IBM i / Db2 for i 1 Future consideration


It would helpful to use an expression like a subselect with DDL, such as: alter sequence XYZ.SEQ1 restart with (select max(ID) + 1from XYZ.TAB1) Use Case: It is common to add rows to a table. If one of the columns is not an identity column but ins...
over 6 years ago in IBM i / Db2 for i 1 Future consideration

Speed up qsys2.active_job_info -> client_ip_address

We using the UDTF active_job_info in bacth to control jobs (msgw etc). Sometimes our DNS is not responding and the UDTF active_job_info is a never ending story because this function makes a reverse DNS look up and will never finish without a reach...
about 2 years ago in IBM i / Db2 for i 1 Future consideration

Document SQLCLI attribute to persist open cursors across program boundaries.

SQLCLI cursors are unexpectedly closed when an application returns to a calling program in the stack. The SQLCLI connection persists but the cursors do not. Use Case: Objective: Maintain array of open cursors for connecting client software having ...
over 6 years ago in IBM i / Db2 for i 3 Future consideration

SQL view containing printer IP addresses

I would like an SQL view containing printer IP addresses. This could be a column added to QSYS2.OBJECT_STATISTICS and would return the "RmtLocName" value that is found on the "Display Device Description" panel of the WrkDevD command. Use Case: I h...
about 7 years ago in IBM i / Db2 for i 4 Future consideration

Increase the maximum size of LOB objects to at least 4GB but perferrably 2TB

The 2GB "limit" on LOB objects is sometime painful. The limit should be at least 4GB but other databases support LOB sizes up to 2TB. So since this is the premiere database, I think we should also have the highest limits.
about 1 year ago in IBM i / Db2 for i 2 Future consideration

"create type" with all characteristics like column table

Improve the SQL "create type" command by adding the column header, the field text and all the possible features that are in a field of a table. In this way it would be possible to create the tables by simply referring to the "type" without definin...
over 5 years ago in IBM i / Db2 for i 3 Future consideration

DB2 Next Identity Value has incorrect value

The majority of new tables we create contain a record identity column defined as GENERATED BY DEFAULT, starting at 1, increment by 1. This column is also the primary key for the tables. Most inserts into tables do not specify a value for the recor...
over 7 years ago in IBM i / Db2 for i 2 Future consideration