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 162

The QSYS2.SYSDISKSTAT view should return "FAILED" instead of null value for disk paths that are in a FAILED state

When viewing disk path statuses from SST, a failed path will show a status of FAILED. When queried through QSYS2.SYSDISKSTAT these paths currently have a null "Resource Status". It would make more sense for the view to return information that is c...
10 months ago in IBM i / Db2 for i 1 Delivered

add SQL query with print instead of display option or generate spool file then PDF ACS

In DB2 for z/OS there are utilities to generate a print/hard copy report instead of displaying the SQL query on screen, I find in DB2 for i OUTPUT(*PRINT) is not available or valid, and don't know of DB2 for i utility to do so. Printing high volum...
11 months ago in IBM i / Db2 for i 5 Delivered

Additional Information from QSYS2.PTF_INFO

For those PTFs that have special instructions it would be useful to include this information via a NULL capable column of type CLOB, for example call PTF_SPECIAL_INSTRUCTIONS, so that it can be queried via the QSYS2.PTF_INFO view. Currently there ...
11 months ago in IBM i / Db2 for i 3 Delivered

Add view or udtf JOB_QUEUE_ENTRIES

Because the view JOB_QUEUE_INFO already exist, so similar to the output_queue_xxx views the job_queue_entries view is missing select * from qsys2.job_queue_entrieswhere job_queue_name = 'QBATCH'
about 1 year ago in IBM i / Db2 for i 3 Delivered

Provide buffer length of LOB columns in SYSCOLUMNS2 view

When processing I/U/D entries from a journal using the DISPLAY_JOURNAL we need to "map" the entry specific data over the record layout. The amount of space occupied by a LOB column varies; depending upon where in the record the column starts. So t...
about 1 year ago in IBM i / Db2 for i 5 Delivered

change RESPONSE_HTTP_HEADER for QSYS2.HTTP_GET_VERBOSE when we want cookie

The HTTP functions do not handle the multiple use of the "set-cookie" headers within an HTTP response. The root issue is that JSON keys should be unique and multiple instances of the "set-cookie" key are not permitted in JSON. Here is a possible a...
about 1 year ago in IBM i / Db2 for i 2 Delivered

An IBM i Service to retrieve program copyright info similar to DSPPGM DETAIL(*COPYRIGHT)

This would be useful for programmers attempting to review or confirm the copyright entries on their commercial products.
over 1 year ago in IBM i / Db2 for i 3 Delivered


IBM i SQL URI_ENCODE / URI_DECODE Function required to provide native support for HTML entities conversion. Benefit: Enables decoded URI value to be stored in an IBM i table as UTF-8 and displayed in ACS. Especially useful when working with differ...
over 1 year ago in IBM i / Db2 for i 4 Delivered


The function ADD_DAYS, ADD_HOURS, ADD_MINUTES, ADD_SECONDS, ADD_YEARS exist on DB2 LUW, but not on DB2 for i. However the function ADD_MONTHS is implemented on DB2 for i. Adding those missing functions on DB2 for i would be very useful to manage t...
over 1 year ago in IBM i / Db2 for i 3 Delivered

Add parameter to CHGPF to ignore CPA32B2

Our CI/CD software uses SSH to communicate with IBM i. In addition to installing ILE program objects, IFS files, ... it can also execute CHGPF. When removing a column from a PF IBM i will send the message CPA32B2 which will be automatically answer...
over 1 year ago in IBM i / Db2 for i 2 Delivered