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

FILTER BY CATEGORY

Db2 for i

Showing 278 of 3624

New IBM i SQL Service to Retrieve Certificate Usage Information

Need a DB2 SQL Service equivalent to API : Retrieve Certificate Usage Information (QYCDRCUI, QycdRetrieveCertUsageInfo) Use Case: We already have the CERTIFICATE_INFO table function, this would allow to know the certificates used (by DCM applicati...
10 months ago in IBM i / Db2 for i 4 Future consideration

create SQL Service like WRKJOBLOG e.g. JOB_LOG_INFO and REMOVE_JOB_LOG

using JOB_INFO one is able to find about job status. If there is high activity on a server, a lot of job logs are created. To clean up, one can use WRKJOBLOG, use filtering, and F13 to delete. Please provide SQL service for a) filtering and gettin...
about 2 months ago in IBM i / Db2 for i 2 Future consideration

Support USER as Default for VARCHAR(10) Columns in Db2 SQL Tables

Currently if I have a table with a varchar(10) field in it, I cannot specify DEFAULT USER or any of the other user registers because they are 18 bytes or longer.However on IBM i, user Profiles are 10.It would save me having to write a Trigger for ...
10 months ago in IBM i / Db2 for i 1 Future consideration

Visual explain as a SQL - IBM i service

Visual explain is a vital tool to get the information about how a SQL statement is processed and to understand the nature of SQL queries. However, it can be quite complicated to oververview complicated queries and the graph can be quite chaotic. M...
11 months ago in IBM i / Db2 for i 2 Not under consideration

improve performances of DB2 sequences

I like the principle of DB2 sequences, but there is a big problem with the implementation of it on IBM i. Indeed, the command CREATE SEQUENCE does not generate a real DB2 object, It generates an IBM i object of DATA AREA type. However, DATA AREAs ...
3 months ago in IBM i / Db2 for i 3 Needs more information

DB2 SQL join with USING need to support nullable column

I have a problem with a JOIN when columns are nullable. summary: I ask for an correction of the USING feature : in the sql engine do a IS NOT DISTINCT FROM when the column is nullable, so USING will do its job. details: for a better explanation, y...
about 1 month ago in IBM i / Db2 for i 1 Not under consideration

Allow more than 1 level of qualified datastructures in SQLRPGLE

We get more and more embedded SQL code in our RPGLE sources but the compiler still only supports 1 level of qualified data structures. This is such a pain. See Use case for example. More practical examples are joins where you want to use the exter...
over 2 years ago in IBM i / Db2 for i 6 Future consideration

Add SQL URI_ENCODE / URI_DECODE Function

IBM i SQL URI_ENCODE / URI_DECODE Function required to provide native support for HTML entities conversion. Benefit: Enables decoded URI value to be stored in an IBM i table as UTF-8 and displayed in ACS. Especially useful when working with differ...
about 1 month ago in IBM i / Db2 for i 1 Future consideration

An IBM i Service for retrieving device status similar to WRKCFGSTS

A device's status is currently not available via SQL. This would be useful for tracking the status of devices such as virtual display/printer devices. It would be useful for System Admins. It could be partnered with QSYS2.OBJECT_STATISTICS to find...
6 months ago in IBM i / Db2 for i 3 Future consideration

QSYS2.JVM_INFO Timeout for bad JVMs

Hello, we are using the qsys2.jvm_info view very frequently. But there is an issue if one or more jvms running on the system are, for example, looping, blocked or any other other bad state but the jvms are not terminating.The select call to qsys2....
about 1 year ago in IBM i / Db2 for i 2 Future consideration