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 361 of 4279

Do not duplicate format identifier during CRTDUPOBJ processing

On the CRTDUPOBJ command there is an option to duplicate file identifers (FILEID). If set to *NO this will create unique file and member identifiers for the new object but will retain the format identifier. This format identifier makes the objects...
over 4 years ago in IBM i / Db2 for i 2 Is a defect

Hope IBM i can have DB2 Order By COLLATION KEY BIT scalar function

Customer need to Order By some DBCS Chinese field by Chinese stroke order. In open platform UDB DB2, can use COLLATION_KEY_BIT scalar function -- https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.sql.ref.doc/doc/r0050491.htm...
over 4 years ago in IBM i / Db2 for i 4 Future consideration

JavaScript (Node.js) as native stored procedure / UDTF language

Today we can use PL/SQL, java and any other ILE language to make stored procedures and UDTF in Db2. However new languages are being used for modern application ie javaScript within Node.js and Python to name a few - and and other languages from th...
over 4 years ago in IBM i / Db2 for i 5 Future consideration

Add Journal Entry Type for TRUNCATE TABLE

Add Journal Code "D" Entry Type "TT" or equivalent ("F-CR") on the SQL TRUNCATE TABLE event. Use Case: Current state, TRUNCATE TABLE creates a journal entry of F-CH and D-CG which states that the file has changed, these are the same entries writte...
over 4 years ago in IBM i / Db2 for i 2 Not under consideration

Return Type for DB2 Coalesce Function Should Be "CHAR" NOT "DECFLOAT(34)" when params are (INT,CHAR) OR (CHAR,INT)

Apparently by design when the DB2 coalesce function evalute parameters consisting of mixed data-types, particularly CHAR(S) and INTEGERS it chooses a return data-type of DECFLOAT(34). When only these data-types are involved it should choose a vari...
almost 5 years ago in IBM i / Db2 for i 2 Not under consideration

Add ISO 8601 timestamp format.

ISO 8601 format shows:2019-07-17T15:21:38Z2019-07-17T15:21:38+01:00T = seperator between date and timeZ = Zulu time+01:00 is Zulu + 1 hour Use Case: Trying to do data interchange with other systems.
almost 5 years ago in IBM i / Db2 for i 10 Future consideration

Document Display_Journal_Entry_Info

Found this undocumented feature Display_Journal_Entry_InfoI'd like it documented and supported. Use Case: Bust apart the journal entry data.
almost 5 years ago in IBM i / Db2 for i 1 Not under consideration

DBMON filtering enchancement when apllying on a Table

When starting a DBMON and filtering on a Table basis, FTRFILE, we would like to be able to see all sql traffic against this table, (successful, warnings and erroneous). Currently we are only able to see successfully executed sql statements. Use Ca...
almost 5 years ago in IBM i / Db2 for i 1 Not under consideration

Allow overriding system value on update of audit columns

Currently doing an SQL update with overriding system value on a column defined as "Generated Always For Each Row on Update as Row Change" results in an SQL0109 saying that it is only allowed on columns defined as Generated Always ??? (probably it ...
almost 5 years ago in IBM i / Db2 for i 3 Not under consideration

"UPSERT" - update or insert

It would be appreciated if a UPSERT SQL statement could be introduced, that do an UPDATE but if the row does not exist will be changed to an insert. Look at upsert patterns and antipatterns: https://michaeljswart.com/2017/07/sql-server-upsert-patt...
almost 5 years ago in IBM i / Db2 for i 5 Not under 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.