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 183

Improve performance when filtering QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC

Improve performance when filtering QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC (or QSYS2.OUTPUT_QUEUE_ENTRIES) using only a qualified job name. If compared with QGYOLSPL Api both views are very slow. Use Case: Handling job's spools.
over 3 years ago in IBM i / Db2 for i 3 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 <> ''...
almost 4 years ago in IBM i / Db2 for i 3 Delivered

Enhance Performance of USER_INFO DB2 SQL View

The QSYS2.USER_INFO SQL View is nice to have. However, the performance on systems with thousands or even hundreds of User Profiles means a lot of waiting. Providea faster version of USER_INFO that returns only the User Profile Info and not the OBJ...
over 4 years ago in IBM i / Db2 for i 2 Delivered

Provide API to retrieve journal cache wait interval

For IBM i servers with journal caching available there is no method / API available that allows the current cachewait value to be retrieved / reported. It would be useful, see Use Case below, to have this functionality via an API; even if the valu...
almost 5 years ago in IBM i / Db2 for i 4 Delivered

Provide schema parameter on RUNSQLSTM

Allow a SCHEMA parameter on RUNSQLSTM so that statements don't need to be qualified, contain a set schema instruction or the current library needs to be changed. This allows the script to be generic so that it can be run against different environm...
over 5 years ago in IBM i / Db2 for i 5 Delivered

SQL enhancement - allow mixed case in unqualified external names

Please allow the use of mixed case in unqualified external names when defining stored procedures or user defined (table) functions. Currently it is not possible to specify an unqualified external name where the routine name is in mixed case. The f...
about 6 years ago in IBM i / Db2 for i 3 Delivered

Generated Column Client IP return no value when updated via 5250 UPDDTA Command

Generated Column Client IP return no value for 5250 command line altered rows. e.g. DFU of a file. Use Case: If you issue the following Alter Table then DFU the altered table, the database will not return an IP address in the Generated Column ALTE...
over 6 years ago in IBM i / Db2 for i 3 Delivered

SSD Fuel Gauge SQL Service

Add a new IBM i service to return the SSD Fuel Gauge information. Use Case: Allow writing monitoring tools using SQL instead of having to run the SSD Fuel Gauge command (https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/IBM%20...
almost 7 years ago in IBM i / Db2 for i 4 Delivered

qsys2.parse_statement function should return table on create index statements

qsys2.parse_statement function should return table on create index statements. When processing a 'create view' statement through the parse_statement function, the result set correctly returns tables used in the statement. When processing a 'create...
almost 7 years ago in IBM i / Db2 for i 2 Delivered

Implement Change Data Capture Technology in IBM DB2 for i

I would request you add Change Data Capture technology to the IBM i. Currently IBM i has the ability to journal changes, and there are some basic capabilities for viewing that data. However viewing it via a 5250 screen is very challenging, and oft...
over 7 years ago in IBM i / Db2 for i 1 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.