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.


Db2 for i

Showing 201

SQL DB2 change in the for system name

When you create an SQL table and the object identifier specified is a valid system name you can not specifiy a different for system name. I would like to be able to specifiy a different name for compatibility with older programs while using newer ...
over 4 years ago in IBM i / Db2 for i 2 Not under consideration

QIBM_QZDA_INIT - Add new format that includes the source IP

Add a new exit point format for QIBM_QZDA_INIT that includes the IP address of the client initiating the connection. Use Case: We use the QIBM_QZDA_INIT exit point to filter which user accounts are allowed access via ODBC/JDBC. We would like to be...
about 7 years ago in IBM i / Db2 for i 2 Not under consideration

Improve Performance of QSYS2.BOUND_SRVPGM_INFO

The performance of QSYS2.BOUND_SRVPGM_INFO is really bad when you're using it in order to get all programs that use a specific BOUND_SERVICE_PROGRAM. More details can be found in the defined Use Case. However, using the same View with the given st...
about 3 years ago in IBM i / Db2 for i 2 Not under consideration

Disallow ENDJRNPF by work with system security

add option to Work with System Security to disallow ENDJRNPF for files in User libraries. If set to NO, users with appropriate security settings may ENDJRNPF. If set to YES, no user (even *SECADM) may ENDJRNPF.(maybe not applicable on *IBM librari...
almost 4 years ago in IBM i / Db2 for i 6 Not under consideration

First-class support for modernizing a data model

Database modernization on the IBM i is more complex & expensive than it could be. The Lab Services approach [1] of creating a logical file over redesigned tables, (to act as a surrogate for the old design) is a clever hack that reduces the cos...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

Add the "Command to Run" field to the JOB-INFO table query

Please add the "Command to Run" parameter to the query. It has nearly all the commands parameters except this one. Use Case: We use a complex process at month end to prepare jobs to run at month end. I need to be able to view the jobs submitted to...
over 2 years ago in IBM i / Db2 for i 4 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...
9 months ago in IBM i / Db2 for i 3 Not under consideration

Provide functionality to query RFE information via IBM i Service

Provide an IBM i Service that allows users to query the RFE database from their IBM i server. All details shown on the website / available when downloaded, should be returned; including comments that could be "concatenated" into a (DB)CLOB column....
almost 3 years ago in IBM i / Db2 for i 1 Not under consideration

improve performances of DB2 sequences

I like the principle of DB2 sequences, but there is a big problem with the implementation of it on IBM i. Indeed, the command CREATE SEQUENCE does not generate a real DB2 object, It generates an IBM i object of DATA AREA type. However, DATA AREAs ...
almost 2 years ago in IBM i / Db2 for i 5 Not under consideration

Change the default of CRTPF parameter SIZE

We are on 7.2, going to 7.3 soon. The default for CRTPF is SIZE(10000 1000 3). This means only 13000 records are required before escape message CPA5305 is issued. The default can be changed using CHGCMDDFT, but it's set back to the original IBM se...
almost 5 years ago in IBM i / Db2 for i 5 Not under consideration