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 votes: Db2 for i

Showing 236

RGZPFM option MBR(*ALL )

Enable the use *ALL on option MBR for the RGZPFM command for a hash partitioned table.
over 1 year ago in IBM i / Db2 for i 2 Not under consideration

Full support of Field Reference File (FRF) in SQL

When creating tables via SQL it is not possible to use the concept of a FRF to define fields in a consistent way and especially query the catalogs later on to find the origin of a field. A workaround is a CREATE TABLE AS however this doesn't suppo...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

Provide a QCMDEXC-Likc Stored Proc that uses CONTAINS SQL

Provide an NEW SQL Stored Procedure for QCMDEXC or QCAPCMD that is set to CONTAINS SQL instead of MODIFIEDS SQL DATA. Use Case: When creating user-written SQL Functions that only contain SQL statements or perhaps READS SQL DATA, the use of QCMDEXC...
almost 4 years ago in IBM i / Db2 for i 6 Not under consideration

Improve the SET DESCRIPTOR statement

The usage of the SET DESCRIPTOR statement is currently complex, tedious and error prone, this leads to hard to maintain code and the usage of anti patterns like user supplied strings directly inserted into dynamic SQL or complex case statements in...
almost 4 years ago in IBM i / Db2 for i 1 Not under consideration

Include OBJATTRIBUTE in resultSet from OBJECT_STATISTICS when object name is *ALLSIMPLE

If possible and without impacting performance, please include the OBJATTRIBUTE column with the results when OBJECT_STATISTICS is generating the fast list of objects due to *ALLSIMPLE being specified on the 3rd (object name) parameter. Use Case: Ne...
over 5 years ago in IBM i / Db2 for i 2 Not under consideration

Journal entry needed when statistics removed from file

During upgrade from 7.2 to 7.3 we got serious performance degradation for some SQL queries. Trying to improve performance we request and remove some file statistics on the source (production) system. It help for some issues. Unfortunately on the t...
about 6 years ago in IBM i / Db2 for i 1 Not under consideration

IBM DB2 Connect 11.5 VSAI (Visual Studio Addin) for VS 2019 using deprecated API's

IBM DB2 Connect 11.5 VSAI (Visual Studio Addin) for VS 2019 using deprecated API's (synchronous loading apis). This needs to be updated for VS 2019 to use Asynchronous loading to remove the warning notices everytime you launch Visual Studio 2019. ...
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

CHGPF with SRCFILE option causes all Field Procedures to decrypt all the data encrypted in the file

when a CHGPF with SRCFILE option is ran over a Physical file with a Field Procedure on one or more fields the data is automatically decrypted to the the full value. Use Case: When file XFILE contains a field SOCIAL that has a field procedure on it...
over 8 years ago in IBM i / Db2 for i 2 Not under consideration

JSON Store access with .Net API

You created the JSON Store Technology for DB2 for i. Therefore you have the Command Line Processor, Java API and SQL User Defined Functions. What is missing is a .Net API. Can you please insert that too? Use Case: More and More .Net Backend Applic...
about 9 years ago in IBM i / Db2 for i 2 Not under consideration

Add Program/Library and Job to Index Advised Table

The index advised table (and the according Navigator interfaces) should be enhanced by adding the (last) program and job identification that caused that specific index advise to be added/updated. Use Case: In order to perform general application p...
over 9 years ago in IBM i / Db2 for i 1 Not under consideration