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 162

Update cascade on constraints

Update cascade is allowed in other databases but, is restricted in DB2 for i, as more developers are modernizing their tables and are using constraints, referential integrity etc. This is going to be needed more and more.
about 3 years ago in IBM i / Db2 for i 2 Future consideration

Allow journal entry read (RCVJRNE) and native DB I/O with field proc encoded data.

Consider a field proc used for field level encryption. When replicating database activity, the data must be decrypted as it is being read from the journal. It then must be re-encrypted when it is written to the database. It would improve performan...
about 2 years ago in IBM i / Db2 for i 2 Future consideration

Fix DSPF to allow Fields on REFFLD that use full 128 character DDL long names

Our team uses has old DDS DSPFs and new ones built using PROFOUNDUI. Product DDS DSPF currently has a 32-character limit for long names/Aliases for fields referenced using REFFLD keyword. This limit should be extended to use the full 128 character...
over 6 years ago in IBM i / Db2 for i 5 Future consideration

Speed up table partitioning

Databases are constantly increasing in size, and more and more IBM i customers are approaching or exceeding the limits for a single DB2 table: 1.7 TB storage or 4.2 billion rows. DB2 MultiSystem allows for a table to have up to 256 partitions inst...
about 2 years ago in IBM i / Db2 for i 2 Future consideration

Remote User/Password in ARCN0100 (Connect format)

An SQL Client Integration Exit Program (ARDPGM) receives remote DB credentials from the SQL system via the Connect format ARCN0100. Both User ID and Password parameters are limited to 10 characters each and the user ID contains only upper case cha...
about 2 years ago in IBM i / Db2 for i 3 Future consideration

DB2 for i PTF services to use ESA configuration for internet access

SYSTOOLS.GROUP_PTF_CURRENCY and SYSTOOLS.GROUP_PTF_DETAILS are great tools to keep track of missing PTFs on a system. When running SQL statement against this view, there is an internet connection from the system to PSP documents. This is a direct ...
over 7 years ago in IBM i / Db2 for i 1 Future consideration

ALTER SEQUENCE: ALLOW SUBSELECT

It would helpful to use an expression like a subselect with DDL, such as: alter sequence XYZ.SEQ1 restart with (select max(ID) + 1from XYZ.TAB1) Use Case: It is common to add rows to a table. If one of the columns is not an identity column but ins...
over 7 years ago in IBM i / Db2 for i 1 Future consideration

SQL Add ANCHOR DATA To (%TYPE) functionality

The lack of support for the %TYPE or ANCHOR DATA TO for data declarations affects our ability to port databases that use this functionality. We are looking at porting a Postgres based application to IBM i and have a large number of functions that ...
about 6 years ago in IBM i / Db2 for i 2 Future consideration

Document SQLCLI attribute to persist open cursors across program boundaries.

SQLCLI cursors are unexpectedly closed when an application returns to a calling program in the stack. The SQLCLI connection persists but the cursors do not. Use Case: Objective: Maintain array of open cursors for connecting client software having ...
almost 8 years ago in IBM i / Db2 for i 3 Future consideration

SQL view containing printer IP addresses

I would like an SQL view containing printer IP addresses. This could be a column added to QSYS2.OBJECT_STATISTICS and would return the "RmtLocName" value that is found on the "Display Device Description" panel of the WrkDevD command. Use Case: I h...
over 8 years ago in IBM i / Db2 for i 4 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.