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

My ideas: Db2 for i

Showing 156

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

Using IBM I ACS ( Access Client Solutions ) Add more Helpful Hints in Visual Explain by Color Coding deficiencies

When using Visual Explain in IBM ACS to look at query performance. When using the Side Panel with Atrributes and Values, can ACS Highlight worrisome results. For Example we learned that Percent Selectivity is a good metric to highlight. Can ACS hi...
2 months ago in IBM i / Db2 for i 1 Future consideration

Adding a new activation group parameter to CREATE or REPLACE VARIABLE

A C-ILE program is currently being created at CREATE VARIABLE, which runs with the activation group *CALLER. Therefore, the SET VARIBALE VALUE can only be used in the activation group in which the variable is used. By specifying a named activation...
6 months ago in IBM i / Db2 for i 2 Future consideration

Extension of the reference manual "DB2 for i SQL Reference"

We have noticed that specifying a record format name when creating an SQL index always creates a derived index. In our case, access paths were therefore created twice. We were able to solve this problem by not specifying the record format name in ...
8 months ago in IBM i / Db2 for i 1 Future consideration

External Tables

It would be very useful to have tables whose content is given by text files, such as Oracle's External Tables. in Oracle this functionality is obtained like this: CREATE TABLE my_ext_table ( id NUMBER, author VARCHAR2(30), created DATE, text CLOB ...
about 1 year ago in IBM i / Db2 for i 2 Future consideration

Provide FIELDPROC_ENCODED_COMPARISON QAQQINI function at column level

DB2 for i Field Procedures are primarily used for column level encryption. The defacto standard for encryption is AES. Ideally, encryption should not be deterministic. In other words, encrypting the same plain text multiple times should produce di...
over 1 year ago in IBM i / Db2 for i 3 Future consideration

Option to Normalize HTTP_RESPONSE_HEADER Fields (Key Names) in the QSYS2 HTTP Functions

The HTTP header fields are case-insensitive. That is, content-type, CONTENT-TYPE, and CoNtEnT-tYpE are all allowed uses of the IANA registered field Content-Type. Previously, when using the SYSTOOLS HTTP table functions (e.g., SYSTOOLS.HTTPGETCLO...
over 1 year ago in IBM i / Db2 for i 3 Future consideration

SQL query to report on RGZPFM history with same details shown in table reorganzation panes

Provides historical details of table reorganizations that would benefit support and application users
over 1 year ago in IBM i / Db2 for i 1 Future consideration

EDRSQL server requires QUSER *RWX authority to ROOT

We recently secured our ROOT directory in the IFS; however, when the EDRSQL server job (QXDAEDRSQL) starts up; MSG CPE3401 is shown in the joblog and the job ends. (see attached joblog) The Security Audit Journal records an Authority Failure (AF) ...
over 1 year 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...
almost 2 years ago in IBM i / Db2 for i 2 Future consideration