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

FILTER BY CATEGORY

Db2 for i

Showing 332 of 4041

"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...
about 5 years ago in IBM i / Db2 for i 2 Future consideration

Add a parameter to RUNSQLSTM to Delete its work files once it completes

When running RUNSQLSTM to create SQL GLOBAL Variables or Global Temporary Tables or anything, it creates a couple of source files in QTEMP. One is named QSQLSRC, one is often named QSQLT000 or simlar. I would like a parameter on RUNSQLSTM named CL...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

Please fix QMQUERY to not need to sign off and on again when modifying multiple queries.

The company I am at uses *QRYDFN for most reporting. I have had to convert these reports from *QRYDFN to *QMQRY. When working with 1 QMQRY and have completed my changes, I then move to the next QMQRY. This is not possible as the tool is currently ...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

0N002 - A character cannot be mapped to a valid XML character.

Since we started using SQL more and more to build and parse XML we are running into SQL state error of 0N002 - A character cannot be mapped to a valid XML character. Our only known fix for this is to do a regular expression statement on each colum...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

Support ability to 'Lock In' a DB2 Plan

The DB2 optimizer continually reevaluates all conditions/variables to create the best plan at that moment. And almost always, the optimizer creates the best plan. There are times however, when the optimizer makes a poor choice. And when it does, t...
almost 7 years ago in IBM i / Db2 for i 1 Not under 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...
about 7 years ago in IBM i / Db2 for i 2 Future consideration

Enhance the QCMDEXC Scalar Function

Add a Third parameter to the function. There are two possibilities. Preview – Allows you to preview the command before executing it. Display – allows you to display the command but, the command executes. This would be use for anyone that needs to ...
over 1 year ago in IBM i / Db2 for i 1 Future consideration

Problem with CPYFRMIMPF command and file with CCSID = 1208 UTF-8

When using command CPYFRMIMPF FROMCCSID(1208) UTF-8 and *FIXED format, each national characters coded on 2 bytes are causing shifting of data in output file. As explained by iGSC in PMR 61492,001,822 when using *FIXED format and multi-byte code po...
about 7 years ago in IBM i / Db2 for i 3 Not under consideration

RGZPFM While Active, show jobs locking object in the job log

When performing a RGZPFM with ALWCANCEL(*YES), if the job completes but cannot return the deleted space due to the file being locked by other jobs, it would be useful if a message was issued in the RGZPFM's joblog, stating that jobs were locking t...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

Add skguard count to DB Health Center as System or Environment Limit

It turned out that hitting the maximum number of entries in skguard causes a major outage as no sqe optimization can take place. This requires an IPL to resolve. It seems reasonable to add the number of entries in skguard to DB Health Center to av...
about 6 years ago in IBM i / Db2 for i 1 Not under consideration