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 138

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

New SQLSetStmtAttr option for Completion/Diag Messages

During Debug mode, on IBM i, the SQL CLI APIs, such as SQLExecute generate diagnostic and completion messages indicating things such as "xx rows selected" or "xx rows inserted", or "Table XXX Dropped". This information does not currently get gener...
over 6 years ago in IBM i / Db2 for i 2 Future consideration

API for Access Path Rebuild Progress

We commonly have access path rebuilds occurring post the vary on of an IASP. We would like the capability to monitor the progress of the access path rebuilds from a batch job rather than just the screen. Use Case: We run a superannuation system on...
almost 7 years ago in IBM i / Db2 for i 8 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...
about 7 years ago in IBM i / Db2 for i 4 Future consideration

DB2 Next Identity Value has incorrect value

The majority of new tables we create contain a record identity column defined as GENERATED BY DEFAULT, starting at 1, increment by 1. This column is also the primary key for the tables. Most inserts into tables do not specify a value for the recor...
over 7 years ago in IBM i / Db2 for i 2 Future consideration

DB2 Alter Table Rename column

DB2 for LUW and z/OS provide the capability to rename a column. DB2 for i should have the same functionality. Renaming a column's system name should be included, too. Use Case: In our IT department, Data Studio is used to create or modify tables a...
over 7 years ago in IBM i / Db2 for i 8 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.