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

IBM i

Showing 49

Add a warning when parameter markers are truncated

IBM i silently truncates parameters to prepared statements to match the length of the target. -----From https://www.ibm.com/docs/en/i/7.4?topic=statements-open, section "Parameter marker replacement" : However, unlike the rules for assigning a val...
about 1 year ago in IBM i / Db2 for i 1 Functionality already exists

XMLVALIDATE: when it found an issue, it doesn't inform in which number line inside XML is the issue.

Hello, At present we're using XMLVALIDATE (SQL-XML) to check if the file XML it's right or not with XSD files. When we use "XMLVALIDATE" and SQL founds an issue inside XML, then SQL throws a message error, but it doesn't inform to us in what line/...
about 2 years ago in IBM i / Db2 for i 2 Functionality already exists

Allow a SQL stored procedure to use 3 part naming without having to create a custom *SQLPKG on each target.

I created a sql stored procedure which looks like the following: CREATE PROCEDURE rob.PROPAGATE_QLNKOMT() LANGUAGE SQL MODIFIES SQL DATA SET OPTION DATFMT = *ISO P1 : BEGINDECLARE OMIT_LIST CHARACTER VARYING ( 32000 ) ; SELECT FSXCMD INTO OMIT_LIS...
about 1 year ago in IBM i / Db2 for i 2 Functionality already exists

CHGASPACT: new functionality (*BCD) i.e. best can do. Stay in SUSPEND state even if not everything could be suspended.

Hello IBM, I recently discussed options of CHGASPACT with IBM support (CASE TS014216210). We normally use chgaspact aspdev(*sysbas) option(*suspend) ssptimo(60) ssptimoacn(*END) In case, this is not successful, *CONT is not an option for us. We ne...
about 1 year ago in IBM i / Core OS 3 Functionality already exists

DBMS_OUTPUT (or alternative)

When writing compound statements and executing them interactively I would like to display certain output.
over 1 year ago in IBM i / Db2 for i 2 Functionality already exists

Enhance the QLIRNMO API so it updates SQL Catalogs the same as the RNMOBJ CL command

Today, the QLIRNMO API only updates the SQL Catalogs for SQL TABLE, VIEW, and INDEX objects. But for SEQUENCES, TRIGGERS, VARIABLES, etc. it does not and the association between the SQL Object long name, and the shorter System Object Name is lost,...
over 1 year ago in IBM i / Db2 for i 2 Functionality already exists

Add Authorization list to IFS Security

If we could add authorization list to IFS security then we could tighten security down by the list and not have to specify a list of users to that object/directory. This is extremely helpful when you have a file share available to everyone (no not...
over 1 year ago in IBM i / IFS (Integrated File System) and Servers 4 Functionality already exists

For queries requiring table scan agsinst of large, 100,000,000+ row tables, split the query into multiple threads based on a percentage of total table pages

WHY: Improved one off query performance against large, 100,000,000+ row tables. WHO: My customer has transaction log tables that can record millions of transactions per day. Peaking just above 58 million per month in the last 6 months. Maintaining...
over 1 year ago in IBM i / Db2 for i 1 Functionality already exists

OpenGpg full support for Gpg Encryption Ifs stream file

Create some easy script / Command to use OpenGpg. Case : I have to send to some supplier and Customer a gpg encrypted file created in Ifs, They gave me their GPG key. Now I have to encrypt. So the Ifs files sales.txt have to became sales.txt.gpg. ...
over 1 year ago in IBM i / Open Source and PASE 2 Functionality already exists

get REFFLD information from DB2 Catalog

For physical files, it is not possible to retrieve the REFFLD keyword information from the DB2 catalog views
over 1 year ago in IBM i / Db2 for i 2 Functionality already exists