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 138

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

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

VARCHAR_FORMAT support TZH and TZM format elements

Db2 for z/OS aleady has this https://www.ibm.com/docs/ko/db2-for-zos/13?topic=functions-varchar-format Other databases such as Oracle and Postgresql already support this
over 1 year ago in IBM i / Db2 for i 1 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

Add abiilty to adjust the increment for selected system limits

I am working with a client that has a few very large files that grow daily and system limit 15003 is logged many times a day since the increment is 1Gb. They know this growth occurs and would like to have an option to specify the increment to be a...
over 1 year 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 ...
almost 2 years ago in IBM i / Db2 for i 1 Future consideration

CPYFRMIMPF support MBROPT(*UPDADD) for temporal tables

It is a very common occurrence that I receive an Excel file containing new data (e.g. new pricing from accounting). This data needs to be imported into Db2, replacing the existing data. They don't send me the complete data, only change data that h...
about 2 years ago in IBM i / Db2 for i 1 Future consideration

Additional parameter for SQL function timestamp_format to manage language

Timestamp_format analysis is based on the labels in QCPFMSG (CPX3BC0 and CPX8601), so only one language. On my machine, french : values timestamp_format( trim( '02/Fev/2021:11:36:44 ' ) , 'DD/Mon/YYYY:HH24:MI:SS') -> OK values timestamp_format(...
about 2 years ago in IBM i / Db2 for i 1 Future consideration