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 191

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...
over 4 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 <> ''...
over 4 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...
over 4 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...
over 4 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...
over 4 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 ...
over 4 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 ...
over 4 years ago in IBM i / Db2 for i 6 Delivered

db2 for service to list file members (like QUSLMBR)

Processing file members with SQL is a pain. We should at least have db2 for i service to find out what members actually exist. Pretty much like the QUSLMBR API . Use Case: Process perfomance data using SQL. All tables in QPFRDATA are multimember t...
almost 5 years ago in IBM i / Db2 for i 5 Delivered

Add UTF8-Support to RUNSQLSTM

If you create an SQL script via the ACS, it is saved in the IFS as UTF-8. If you now call this script via the RUNSQLSTM command, it can happen that incorrect characters occurs. Eg if the script starts with "--". Use Case: Example: -- This script S...
almost 5 years ago in IBM i / Db2 for i 3 Delivered

IBM i Services for defective PTFs installed

Currently the Must Gather Tool has an option for checking for any installed defective PTF's on an LPAR. The output of this is a spoolfile, which does more belong to the time when we still used the term AS/400 Use Case: An IBM i DB2 for i Services ...
almost 5 years ago in IBM i / Db2 for i 3 Delivered

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.