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 360 of 4259

Prevent ALTER TABLE when field size expanded and there is a field procedure

When a field procedure is assigned to a field, in our case for purposes of encrypting the field data, and an ALTER TABLE is allowed to execute against the field to expand the field size, then data corruption occurs. Use Case: Example Create table ...
over 3 years ago in IBM i / Db2 for i 4 Not under consideration

Increase maximum file member size

Increase maximum file member size, currently limited to 1.7TB. Use Case: customer stores large binary objects in file using SQL and reaches file limit. Currently they do not want to separate objects to multiple tables or work with partitioning.
about 5 years ago in IBM i / Db2 for i 2 Not under consideration

CPYTOSTMF

The CPYTOSTMF does not have the functionality to create a "Native Excel" XLS or XLSX file when the FROMFILE is an Physical file . Currently the CPYTOSTMF creates a delimited file separating fields using a comma, tilde, semicolon, etc. Suggest the ...
over 3 years ago in IBM i / Db2 for i 6 Not under consideration

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...
6 months ago in IBM i / Db2 for i 1 Needs more information

Do not duplicate format identifier during CRTDUPOBJ processing

On the CRTDUPOBJ command there is an option to duplicate file identifers (FILEID). If set to *NO this will create unique file and member identifiers for the new object but will retain the format identifier. This format identifier makes the objects...
over 4 years ago in IBM i / Db2 for i 2 Is a defect

Retrieve AA macro result by SQL

Currently, the AA macro from STRSST were not able to retrieve by CL command or SQL. it is not possible to make automation / monitoring program. Hope ibm can develop API or SQL that we can retrieve the value.
about 1 year 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...
over 2 years ago in IBM i / Db2 for i 2 Is a defect

Inline code for SQL procedures/function

Today you can use inline code in SQL procedures/functions with the "include" statement , but need to write the code in a separate file like this: call qsys2.ifs_write( path_name => '/tmp/main.c' , file_ccsid => 1208, overwrite => 'REPLACE...
7 months ago in IBM i / Db2 for i 1 Not under consideration

Foreign Key enhancement

I would like to request an enhancement to DB2. Through the years, we have had various developers who have set up files and tables with different numeric data types, that hold the same data. For example, in one file, a Customer number might be defi...
about 1 year ago in IBM i / Db2 for i 1 Not under consideration

Add options to TRUNCATE to support clearing a single partition (member)

The SQL TRUNCATE statement currently only supports removing data from the entire table, even when run against an ALIAS created against a single partition. Use Case: Fast truncation of a single partition (member), just like CLRPFM with a specific m...
almost 4 years ago in IBM i / Db2 for i 2 Future consideration

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.