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 419 of 4726

Add something like IF EXIST for a table, view, procedures, etc.

In SQL, I often need to check if a table exists and either delete or create it. I opened a case and was told the functionality does not exist. If a file exists, I need to delete/DROP it. Sometimes, I need to create the table.
almost 2 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

Enhnance XMLROW by adding an OPTION of "OPTION EXCLUDE XMLDECLARATION" to this function

When using the XMLROW function, it addes the XML header tag to each returned row. So you end up with <?xml version="1.0" ENCODING="IBM037"?> prefixing each and every row. IBM ACS and other interfaces strip off that header tag internally. But...
almost 2 years ago in IBM i / Db2 for i 1 Not under consideration

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 ...
almost 2 years 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.
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

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

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...
almost 8 years ago in IBM i / Db2 for i 2 Not under 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

FIELDPROC - Missing record informations

Field procedures need a possibility to get field values beside the current field in the same record.So there should be additional parameters for the field procedures like a pointer to the current record or, if not possible the current record numbe...
almost 8 years ago in IBM i / Db2 for i 1 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.