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

Provide a way to query Db2 for IBM i members

Currently, using OVRDBF to direct SQL statements to a specific database file member is functional, but it is not an ideal solution. It requires an external override that is disconnected from the SQL statement itself, making the code less self-cont...
5 days ago in IBM i / Db2 for i Submitted

Incorporate the SQL_ERROR, SQL_WARNING, and SQL_NOT_FOUND indicators into SQLCA

Incorporate indicators into SQLCA so that the code in SQLRPGLE is much clearer when validating SQL statements, without having to deduce it every time we read conditions involving sqlcode, sqlstate or sqlwarn. Wanted SQL_SUCCESS SQL_NOT_FOUND ...
4 days ago in IBM i / Db2 for i Submitted

SPOOLED_FILE_INFO add parameter for spool file

I often spend time looking for certain spool files belonging to a user. At present I have to do: SELECT * FROM TABLE(QSYS2.SPOOLED_FILE_INFO( USER_NAME => 'HUTCHINSON')) WHERE SPOOLED_FILE_NAME = 'QPJOBLOG' ORDER BY CREATION_TIMESTAMP DESC ; ...
19 days ago in IBM i / Db2 for i Submitted

Add to OBJECT_STATISTICS a column to inform us if a library is an IBM library

A new column would be added to OBJECT_STATISTICS called something like IBM_OBJECT. A value of 'YES' or 'NO' would be used. At present there does not appear to be an easy or definitive way of determining if a library belongs to IBM. SELECT OBJNAME ...
29 days ago in IBM i / Db2 for i Submitted

Can we please have a DEFECTIVE_PTF_CURRENCY_LOCAL

In the latest TR updates of IBM i 7.5 TR2 and 7.6 TR 2 the SYSTOOLS.GROUP_PTF_CURRENCY_LOCAL was announced.As we all know keeping current with PTFs is very important.With that in mind it must also be important to be aware of defective PTF's.For th...
22 days ago in IBM i / Db2 for i Submitted

include production ready IFS primitives (i.e. delete, rename) working with ccsid 1200 (or other unicodes).

Please introduce production ready QSYS2 primitives (functions, table functions...) to interact with IFS using an SQL interface, like a delete operation (unlink) or rename, in order to orderly and cleanly compose with the other functionality of the...
20 days ago in IBM i / Db2 for i Submitted

Enable multiple QDBSRV01 jobs to process requests concurrently on IBM i

We experienced highly utilized QDBSRV0 job that was processing internal journal entries (J-XP) only done via QDBSRV01. IBM i system provided QDBSRV01 operates as a single-threaded job that receives incoming requests and distributes most of the pro...
18 days ago in IBM i / Db2 for i Submitted

Replace SYSTOOLS http functions in SYSTOOLS.GROUP_PTF_CURRENCY

With a view to phasing out the use of the old HTTP functions in SYSTOOLS, it would be ideal to replace them with the HTTP functions in the SQL services provided by IBM, including, for example, systools.GROUP_PTF_CURRENCY
about 1 month ago in IBM i / Db2 for i Submitted

improve MERGE by adding the option "WHEN NOT MATCHED BY SOURCE THEN DELETE"

Today, it is impossible to use the DELETE clause behind WHEN NOT MATCHED.Some DBMS other than DB2 allow this.Would it be possible to add this feature, like in this example ? MERGE target_table USING source_table ON merge_condition WHEN MATCHED THE...
about 3 years ago in IBM i / Db2 for i Submitted

"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...
almost 8 years ago in IBM i / Db2 for i Submitted

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.