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

My votes: Db2 for i

Showing 143

Support WITH TIME ZONE in DB2 for i

Timestamps are stored by default in the current timezone which causes problems if you need to support an application in different timezones, compare historical data with other systems or on DST events. It would therefore be useful if DB2 for i wou...
about 2 years ago in IBM i / Db2 for i 5 Future consideration

Add optional argument for XMLPARSE

To use XMLPARSE, the external encoding of the data need to be consistent with XML prolog. But, often, the encoding of the variable (in hosted langage or CLOB) isn't the same as original value. For example : when we receive an XML file by FTP or ot...
about 2 years ago in IBM i / Db2 for i 1 Future consideration

Add FOR COLUMN or FOR SYSTEM NAME to Function Return Column Definitions

For User-defined SQL Function, today we can define returned column name using up to 128 characters. There currently (as far as I know) is no way to also assign a shorter, more memorable "System Column Name" to the returned parameter. For example:...
over 2 years ago in IBM i / Db2 for i 1 Future consideration

Extend FINAL TABLE to MERGE statement

DB2 on z/OS offers the FINAL TABLE with the MERGE statement, however on IBM i this is limited to INSERT only. Please change DB2 for i to also support FINAL TABLE combined with MERGE. Use case : in the query below, which increments a counter...
over 2 years ago in IBM i / Db2 for i 4 Future consideration

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

Make it possible to also define SYSTEM NAME for short LONG NAME for tables

When creating an SQL Table we define long descriptive names for them. We also define SYSTEN NAME that is used to name RPG Procedure Source files, Modules and Service Programs. When the descriptive "LONG NAME" is 10 letters long or shorter it is ...
over 2 years ago in IBM i / Db2 for i 3 Future consideration

SQL check authority enhancement to understand level of authority

QSYS2.SQL_CHECK_Authority function in SYSTOOLS, is available to retrieve whether the current user is authorized to an object. This is good as returns 1 if authorized. However, if the business needs to know, for a file object whether user can view ...
over 2 years ago in IBM i / Db2 for i 1 Future consideration

Provide an SQL service, view, or other way to report out information about services deployed via Integrated Web Services.

The ability to run reporting of information about deployed services, such as what services are deployed, what servers those are on, whether or not those are applying TLS and basic authentication, etc., would be a help to easily determine and audit...
over 2 years ago in IBM i / Db2 for i 2 Future consideration

An IBM i Service for retrieving Netserver session details

The QSYS2.SERVER_SHARE_INFO service shows various details about the existing shares including the share name, IFS path, read/write status, and current number of users that are connected. However it does not give a view of who those users are. This...
over 2 years ago in IBM i / Db2 for i 1 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.