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

Db2 for i

Showing 361 of 4288

Allow partitioning of DDS created tables

As of today, a DDS created table cannot be partitioned by ALTER TABLE ADD PARTITION. In many cases, a DDS table can be converted to an SQL table, however some keywords like DATFMT are not available in SQL. Which means that those tables cannot be c...
6 months ago in IBM i / Db2 for i 1 Not under consideration

Add new field in QSYSFILES

Actuellement, il est impossible de récupérer le "Nombre actuel d'incréments" via une requête SQL sur QSYS2.SYSFILES. Cette information est présente dans le DSPFD. Currently, it is not possible to retrieve the "Number of current increments" by a SQ...
6 months ago in IBM i / Db2 for i 2 Future consideration

In SQL JSON_TABLE, add an option on timestamp columns to take into account or not the timezone offset

In the SQL function JSON_TABLE, when a timestamp value indicated with a time zone offset (e.g.: "yyyy-mm-ddThh:mm:ss.nnnnnn<+/-Offset>") is retrieved to produce a timestamp column, the resulting value is always an UTC value (by adding or sub...
11 months ago in IBM i / Db2 for i 3 Future consideration

Enhancements to RPGLE SQLTYPE

I would like to be able to define an SQLTYPE field as a TEMPLATE. I would also like to be able to use a named constant for the SQLTYPE size parameter. An example: dcl-c $len_rcCLOB 2000000; dcl-s t_rcCLOB sqltype(CLOB: $len_rcCLOB) template; dcl-s...
about 1 year ago in IBM i / Db2 for i 2 Future consideration

Improve tracking of what job is the client job for QSQSRVR jobs with ability to review over time

Today, a CPF9898 message is logged to the QSQSRVR job log with the server mode connecting job information. This is useful while the client is actively using the job, but it is insufficient to assess the overall workload on QSQSRVR jobs by the vari...
over 1 year ago in IBM i / Db2 for i 1 Future 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 ...
over 1 year ago in IBM i / Db2 for i 5 Not under consideration

Support *LIBL on RUNQRY QRY()

Hi, When creating a query definition, the library is resolved at creation time and not at runtime. This method is unlike any other function on IBM i and doesn't allow the query to be used with another library list as it is ignored. This way you ca...
over 1 year ago in IBM i / Db2 for i 3 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...
almost 2 years ago in IBM i / Db2 for i 1 Future consideration

Add does-not-contain option in SQL Plan Cache Statements

Access Client Solutions SQL Performance Center has a button "Show Statements..." that displays a "SQL Plan Cache Statements" window. You have a variety of filters, including "Statements that contain the following text". I think it would be incredi...
about 2 years ago in IBM i / Db2 for i 1 Not under consideration

Correct accuracy of inline error location in ILE C compiler for SQL

When using SQL to create a User Defined Function, the RUNSQLSTM and other interfaces generate C source code and compile it. When the developer also uses the INCLUDE statement in that same code, to pull in some "inline C" code, when there are error...
almost 3 years ago in IBM i / Db2 for i 2 Is a defect

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.