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

Db2 for i

Showing 394 of 4587

DSPJRN IFS entries to ASCII

When displaying journal entries for IFS (type B) the ESD data in the journal is in ASCII, but the display is EBCDIC so the content when display via the interface is not readable. It would be far better to either convert the content to ASCII automa...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

SQL Enhancement - CREATE OR REPLACE INDEX

Please implement CREATE OR REPLACE INDEX Use Case: In setting up a source member for a CMS to create or change an index through RUNSQLSTM, if the index already exists, it errors out. If I precede the CREATE INDEX with a DROP INDEX, it errors out i...
over 6 years ago in IBM i / Db2 for i 3 Future consideration

Port IBM NoSQL Wire Listener for DB2 to IBM i

With the IBM NoSQL Wire Listener for DB2 it is possible to use existing Applications that use MongoDB as their Database together with DB2 without changing the App.It runs on all Versions of DB2 except the DB2 for i. Details are here:https://www.ib...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

Add DB2 functions to modify JSON object

Today, with DB2, we have some functions to publish or consume JSON.We don't have any function to modify a JSON object Use Case: Need to modify JSON objects: add or remove a node, change a key or value
over 6 years ago in IBM i / Db2 for i 5 Not under consideration

Journal entry data to return binary timestamps

In the entry specific data returned by QjoRetrieveJournalEntries it would be useful to have the time/date/timestamp data to be returned in a binary format. For example, either a documented internal database format or the same time format used for ...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

"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...
over 6 years ago in IBM i / Db2 for i 3 Future consideration

Enhance SYSTOOLS.CHECK_SYSROUTINE & CHECK_SYSCST

Enhance SYSTOOLS.CHECK_SYSROUTINE & CHECK_SYSCST to include a "remote schema" parameter. Use Case: Allow easy comparison of SQL objects in test schemas & multi-tenant environments.
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

Multi-row insert in dynamic SQL RPG

Please enhance dynamic SQL support in RPG to include multi-row insert. Use Case: Dcl-DS myQualDS ExtName('THETBL') Dim(200) Qualified Inz; End-DS; myQualDS (1).dta = '1'; myQualDS (2).dta = '2'; Ctr = 2; SQLStatement = 'Insert into THETBL ? rows v...
over 6 years ago in IBM i / Db2 for i 2 Future consideration

Alter table without exclusive lock

Provide possibility to alter table add column without exclusive lock on the table to enable 24x7 deployment with zero downtime for real-time applications. Possible solution can be done in a same way as online DDL in innodb. (https://dev.mysql.com/...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

Increase VARCHAR() Scaler to 65KB, 16MB or 2GB

Currently SQL VARCHAR() scalar function under DB2 for i supports lengths of up to 32k or 32k-1 w/Nullable values. HLL on IBM i support 64k Varchar column/fields as well as 16MB Varchar lengths. Other Platforms (Microsoft) also support much longer ...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration