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 409

JSON_UPDATE - Updating a true/false value

Whith JSON_UPDATE it is possible to modify existing JSON data. It is possbile to exchange a single value, to add a key/value pair, to exchange an existing Object, to add an existing Object, exchange an array and add a new array. ... but it is not ...
over 1 year ago in IBM i / Db2 for i 1 Not under consideration

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

DB2 Next Identity Value has incorrect value

The majority of new tables we create contain a record identity column defined as GENERATED BY DEFAULT, starting at 1, increment by 1. This column is also the primary key for the tables. Most inserts into tables do not specify a value for the recor...
over 8 years ago in IBM i / Db2 for i 2 Future consideration

Problem with CPYFRMIMPF command and file with CCSID = 1208 UTF-8

When using command CPYFRMIMPF FROMCCSID(1208) UTF-8 and *FIXED format, each national characters coded on 2 bytes are causing shifting of data in output file. As explained by iGSC in PMR 61492,001,822 when using *FIXED format and multi-byte code po...
over 8 years ago in IBM i / Db2 for i 3 Not under consideration

Optim Test Data Management - LOAD Feature -Db2 for i - Table columns with "Generated Always" constraint

Db2 for I does not support IBM InfoSphere Optim to load into a column with the 'Generated Always' constraint. Use Case: System: IBM InfoSphere Optim Test Data ManagementActor: Customer Use cases for the system: 1. Mask and load data into a Db2 tab...
over 5 years ago in IBM i / Db2 for i 2 Not under consideration

SQL Service qsys2.dns_lookup_ip() needs to return *all DNS name for given IP address

the new SQL service qsys2.dns_lookup_ip() should return all the DNS names. currently if only returns the first one found for your given DNS setup. the DIG command does return all associated names
almost 2 years ago in IBM i / Db2 for i 3 Future consideration

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,...
almost 2 years ago in IBM i / Db2 for i 2 Functionality already exists

Add skguard count to DB Health Center as System or Environment Limit

It turned out that hitting the maximum number of entries in skguard causes a major outage as no sqe optimization can take place. This requires an IPL to resolve. It seems reasonable to add the number of entries in skguard to DB Health Center to av...
over 7 years ago in IBM i / Db2 for i 1 Not under consideration

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...
almost 2 years ago in IBM i / Db2 for i 1 Functionality already exists

Implement an option to ignore trigger on update

Add an option that allows to ignore triggers on update/delete Use Case: I'm having a stored procedure that updates a technical field on tables. these updates are slow, because there are triggers on some tables. I know that these updates don't have...
over 7 years ago in IBM i / Db2 for i 2 Not under 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.