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 405

Provide an Obscure Parameter attribute to SQL Functions for security purposes

When running a UDTF or UDF or even a stored procedure, we may be passing in sensitive information, such as passwords, security codes or credit card numbers. Similar to CL Command's DSPINPUT (display input) parameter, we need a way to hide that sen...
almost 3 years ago in IBM i / Db2 for i 2 Not under consideration

Speed up qsys2.active_job_info -> client_ip_address

We using the UDTF active_job_info in bacth to control jobs (msgw etc). Sometimes our DNS is not responding and the UDTF active_job_info is a never ending story because this function makes a reverse DNS look up and will never finish without a reach...
almost 3 years ago in IBM i / Db2 for i 1 Future consideration

RPG IV extension regarding license program 5770SS1-27-DB2-Multisystem

RPG IV provides a file information data structure with database specific feedback information. In position 397 of the FIDS there is an unsigned integer field for the relative record number. This field contains the RRN of the record which was affec...
about 5 years ago in IBM i / Db2 for i 2 Not under consideration

Backport IFS source support for CRTPF & CRTDSPF to 7,2

Please backport the changes to CRTPF & CRTDSPF to support storing source in the IFS to 7.2. Use Case: From the description of SI66797: APAR Error Description / Circumvention -----------------------------------------------CL compiler does not s...
about 6 years ago in IBM i / Db2 for i 4 Not under consideration

Enhance SYSTOOLS.CHECK_SYSROUTINE & CHECK_SYSCST

Enhance SYSTOOLS.CHECK_SYSROUTINE & CHECK_SYSCST to include a "remote schema" parameter. Use Case: Allow easy comparison of SQL objects in test schemas & multi-tenant environments.
over 6 years ago in IBM i / Db2 for i 2 Not under consideration

File journals

When upgrading from V6R1 to V7R1 we are no longer able to associate journal receivers with the journal after making file changes. We never had an issue until the upgrade to V7R1 and we have made numerous file changes without issues on V6R1. Techni...
about 8 years ago in IBM i / Db2 for i 3 Not under consideration

Support derived keys on field procs

System: Customer Service Maintenance Actor: User needing a previously available feature. Description: Hiper group PTF SI39169, released on 04/21/2010, added a constraint that restricted the creation of logical files with derived keys (functions su...
over 8 years ago in IBM i / Db2 for i 3 Not under consideration

Allow Request Body (request-message) on HTTP_DELETE* functions

I have a third party delete method API I am trying to call with HTTP_DELETE_VERBOSE. This API has parameters that I need to pass in a Request BODY (request-message), however, HTTP_DELETE* functions do not have a parameter in which to pass this req...
about 15 hours ago in IBM i / Db2 for i 0 Submitted

Add SIRGAS 2000 as supported datum on DB2 for i

Since 2005, Brazil has adopted datum SIRGAS 2000 as its official Georeferencing System. Therefore, all information exchanged between government entities must adhere to this standard. It is also used by other Latin American countries. Thus, it woul...
13 days ago in IBM i / Db2 for i 0 Submitted

Sql Update using Common Table Expresions

Currently an UPDATE statement that attempts to update a field with the selected value from a Common table expression causes an SQLCODE -199 with SQLSTATE 42601: "Illegal use of KeyWord UPDATE. Token ( SELECT VALUES was expected" --or something sim...
21 days ago in IBM i / Db2 for i 0 Submitted

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.