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

Showing 414

File journals

When upgrading from V6R1 to V7R1 we are no longer able to associate journal receivers with the journal after making file changes. We never had an issue until the upgrade to V7R1 and we have made numerous file changes without issues on V6R1. Techni...
about 8 years ago in IBM i / Db2 for i 3 Not under consideration

Support derived keys on field procs

System: Customer Service Maintenance Actor: User needing a previously available feature. Description: Hiper group PTF SI39169, released on 04/21/2010, added a constraint that restricted the creation of logical files with derived keys (functions su...
almost 9 years ago in IBM i / Db2 for i 3 Not under consideration

Allow COALESCE to provide automatic CAST

I have this line in a CREATE VIEW statement: coalesce(va.vaaddress1, '?Unknown') as vaaddress1, When the view is accessed using SQL embedded in ILEPRPG, the SQLSTATE becomes 01004. VAADDRESS1 is defined in a SQL TABLE as CHAR(40). It would save a ...
about 1 month ago in IBM i / Db2 for i 1 Not under consideration

Moving old data from production tables to historic tables in another library

In an active production system such as we have being in a 24 hour service financial environment, we have an issue with old data that exists in many of our database tables. Every second new data is being recorded in this tables and old the old data...
about 1 month ago in IBM i / Db2 for i 2 Not under consideration

Allow Request Body (request-message) on HTTP_DELETE* functions

I have a third party delete method API I am trying to call with HTTP_DELETE_VERBOSE. This API has parameters that I need to pass in a Request BODY (request-message), however, HTTP_DELETE* functions do not have a parameter in which to pass this req...
2 months ago in IBM i / Db2 for i 3 Future consideration

Add SIRGAS 2000 as supported datum on DB2 for i

Since 2005, Brazil has adopted datum SIRGAS 2000 as its official Georeferencing System. Therefore, all information exchanged between government entities must adhere to this standard. It is also used by other Latin American countries. Thus, it woul...
3 months ago in IBM i / Db2 for i 2 Not under consideration

SQL Update using Common Table Expresions

Currently an UPDATE statement that attempts to update a field with the selected value from a Common table expression causes an SQLCODE -199 with SQLSTATE 42601: "Illegal use of KeyWord UPDATE. Token ( SELECT VALUES was expected" --or something sim...
3 months ago in IBM i / Db2 for i 1 Not under consideration

Better documentation of Sqlstate behavior in IF statement

I ran into some peculiar piece of code that didn't do what I expected and decided to run a small test.The goal is to see if SqlState is being reset in an if-statement. My human brain says it shouldn't be reset in the example code below begin decl...
3 months ago in IBM i / Db2 for i 1 Functionality already exists

Allow more row value comparisons

Often old tables have two separate columns for a timestamp, a decimal date and time column instead of a single timestamp column. When querying those tables, it would be great if row-value-expressions could not only be compared for equality but als...
3 months ago in IBM i / Db2 for i 1 Future consideration

Support an ADD MEMBER option on the GENERATE_SQL SQL Stored Procedure

Today if the output source file and member do not exist, the procedure fails. I think the proc should add/replace the data in the output member but also add the member if it does not exist.
9 months ago in IBM i / Db2 for i 1 Future consideration

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.