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

My votes: Db2 for i

Showing 189

Add support for *LAST in CREATE ALIAS

CREATE ALIAS command allows to create aliases for a specific MEMBER of a physical table on IBM i, but the alias has to be explicitly named. Many applications add members periodically and start filling rows in the last member. Having the ability of...
over 4 years ago in IBM i / Db2 for i 7 Delivered

Make the number of concurrent copies of plan cache SQLs a dynamically configurable parameter

We have a very serious need to increase the number of concurrent copies of SQLs in the plan cache well beyond the current hard-coded limit of 3 copies. We currently have 631 production schemas, each with the same database and SQLs. It's a separate...
over 4 years ago in IBM i / Db2 for i 4 Delivered

IBM i service for ANZDFTPWD

The output of the ANZDFTPWD to a spoolfile only, might work 20 years ago, but in today's world that output format is no longer able to deal with today's demands. Use Case: We want to combine the information of the ANZDFTPWD command with other DB2 ...
over 4 years ago in IBM i / Db2 for i 4 Delivered

Enhance Performance of USER_INFO DB2 SQL View

The QSYS2.USER_INFO SQL View is nice to have. However, the performance on systems with thousands or even hundreds of User Profiles means a lot of waiting. Providea faster version of USER_INFO that returns only the User Profile Info and not the OBJ...
over 4 years ago in IBM i / Db2 for i 2 Delivered

Support OBJECT NAME as Parameter of OBJECT_STATISTICS UDTF

The Db2 for i SQL UDTF OBJECT_STATISTICS accepts only a FULL object name or NO object name as the third parameter. This means to produce a list of generic names, the WHERE clause must be added. Supporting a generic name on that Object_Name paramet...
over 4 years ago in IBM i / Db2 for i 3 Delivered

JDBC 1371E support

JDBCWe can access DB2 for i data in Java programs by using the JDBC driver that is included with the IBM Developer Kit for Java. Please enable the full 1371E support with Unicode surrogates. Use Case: JDBCWe can access DB2 for i data in Java progr...
over 4 years ago in IBM i / Db2 for i 1 Delivered

Extend FINAL TABLE to UPDATE/DELETE statement

DB2 on other platforms offers the FINAL TABLE with UPDATE/DELETE statements, however on IBM i this is limited to INSERT only. Please change DB2 for i to also support FINALE TABLE on UPDATE/DELETE statements. Use Case: The statement below... Select...
over 4 years ago in IBM i / Db2 for i 5 Delivered

Additional Information From SYSCOLUMNS

The output provided by querying SYSCOLUMNS is missing key information that can only be retrieved via API calls run directly on the IBM i. For example, the format of date / time columns is not present, and there may be others. The information retur...
over 4 years ago in IBM i / Db2 for i 6 Delivered

SYSDISKSTAT: Add percent busy

Disks are getting hammered on one system on rare occasion. IBM denies any culpability. Therefore I need way to know when to IPL system when the percent busy of the disks gets out of hand.Please add percent busy to sysdiskstat service Use Case: Mon...
almost 5 years ago in IBM i / Db2 for i 3 Delivered

CPF warning when system has reached 90% of 2.6 Million spool files

CPI1468 - System job tables nearing capacity is generated before the system becomes unusable. Very nice. CPF4235 is generated when the number of spool files exceeds 2.6 Million. It would be helpful to receive a similar message when the Spool file ...
almost 5 years ago in IBM i / Db2 for i 8 Delivered