Skip to Main Content
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 162

Add NSLOOKUP type SQL service

I would like a service like those athttps://www.ibm.com/docs/en/i/7.4?topic=optimization-i-servicesThis service would allow me to doSELECT * FROM QSYS2.NSLOOKUP('www.mycorp.com', 'dns.google.com');I would also like it to not be dependent on having...
about 3 years ago in IBM i / Db2 for i 3 Delivered

Create a Standards Document for future SQL Services

Please create and follow a Standards Document for future SQL Functions (i.e., SQL "services") that are created. We are seeing each new published function has little regard for existing parameter names or sequences. Some UDtFs have Object followed ...
about 3 years ago in IBM i / Db2 for i 3 Delivered

Create an IBM i Service for command DSPSAVF

Create a new IBM i Service to make it possible to get information of the content in a Save File. Use Case: Save Files are great to use when delivering objects from on server to another. To be able automate a deployment process we need to know what...
about 3 years ago in IBM i / Db2 for i 8 Delivered

Link SQL procedure or SQL function as item in DSPPGMREF

DSPPGMREF does not identify any SQL procedure or function coded in programs. A program can be a *PGM or *SRVPGM object created from a source that is based on SQLxxx language and the usage is static in the source. Use Case: When attempting to use c...
about 3 years ago in IBM i / Db2 for i 8 Delivered

Add Workload Group to SQL Table TABLE ACTIVE_JOB_INFO

It would be very useful if the Workload Group (Workload Capping Group) WLCGRP could be added to the IBM i Services SQL table QSYS2.ACTIVE_JOB_INFO(). Use Case: This addition would allow the addition search criteria such as WHERE WLCGRP <> ''...
about 3 years ago in IBM i / Db2 for i 3 Delivered

SQL's HTTPxxxx-Functions should provide body data of the response

It is great that we can consume webservices with SQL functions. I have to consume a REST web service that answers in the case of an error with HTTP response code 401 and a JSON object with "error" and "error_desc" in the body of the response telli...
about 3 years ago in IBM i / Db2 for i 1 Delivered

Allow triggers to fire on records updated or deleted by Referential Integrity CASCADEs

Currently, when a dependent table record is deleted or updated because of a referential integrity CASCADE caused by the delete or update on a parent table, triggers do not fire on that dependent table. Please allow an option to fire off triggers o...
about 3 years ago in IBM i / Db2 for i 3 Delivered

Replace trigger while active

When there's a need to replace a high level language trigger, an exclusive lock is required to the program object. In a 24/7 system this is almost impossible what makes the use of triggers a no-go. Programs in use (apart from triggers) can be repl...
about 3 years ago in IBM i / Db2 for i 2 Delivered

Add TGTRLS on RUNSQLSTM OUTPUT(*LIST) Report

When creating a UDF or UDTF (SQL Function) using the RUNSQLSTM CL command, the resulting Output "Compiler Listing" does NOT including the TGTRLS (Target release) specified on the RUNSQLSTM command. The "current" VxRyMz does appear in the title of ...
about 3 years ago in IBM i / Db2 for i 3 Delivered

Monitor for Hardware Key expiration

We are trying to extract the firmware status to allow tracking of expired keys. There are some commands which will extract the key information (DSPFMWSTS) but no associated API's that we can find. We looked at monitoring for the messages when the ...
about 3 years ago in IBM i / Db2 for i 6 Delivered