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 165

    Add new field in QSYSFILES

    Actuellement, il est impossible de récupérer le "Nombre actuel d'incréments" via une requête SQL sur QSYS2.SYSFILES. Cette information est présente dans le DSPFD. Currently, it is not possible to retrieve the "Number of current increments" by a SQ...
    about 2 years ago in IBM i / Db2 for i 2 Future consideration

    Improve performance of REGEXP_xxx SQL functions

    The REGEXP_SUBSTR and related SQL Regular Expression functions a great, but rely on external interfaces. The request is to figure out a way to make them perform better regardless of them being based on the eternal ICU library. In one-off situatio...
    over 3 years ago in IBM i / Db2 for i 2 Future consideration

    Using IBM I ACS ( Access Client Solutions ) Add more Helpful Hints in Visual Explain by Color Coding deficiencies

    When using Visual Explain in IBM ACS to look at query performance. When using the Side Panel with Atrributes and Values, can ACS Highlight worrisome results. For Example we learned that Percent Selectivity is a good metric to highlight. Can ACS hi...
    10 months ago in IBM i / Db2 for i 1 Future consideration

    SQL Services should support audit journal & authority collection

    Currently usage of IBM i Services (SQL) (e..g QSYS2.OUTPUT_QUEUE_ENTRIES_BASIC ) can fail with an authority failure without logging to the OS audit journal or showing up in authority collection. Per IBM support, this is working as designed. I'm co...
    over 4 years ago in IBM i / Db2 for i 4 Future consideration

    Allow *LIBL or omitted library on INCLUDE statement in SQL Stored procedures and Functions

    The INCLUDE statement used to include C code in an SQL LANGUAGE Stored Procedure or User Defined (Table) Function requires an explicit library name. Common software development practices will have different versions or levels of code in different ...
    over 4 years ago in IBM i / Db2 for i 2 Future consideration

    An IBM i Service for retrieving Netserver session details

    The QSYS2.SERVER_SHARE_INFO service shows various details about the existing shares including the share name, IFS path, read/write status, and current number of users that are connected. However it does not give a view of who those users are. This...
    over 3 years ago in IBM i / Db2 for i 1 Future consideration

    Provide an SQL service to retrieve same data as DSPFFD command to OUTFILE for non-db2 objects such as DSPF, DDM, etc

    When writing applications that utilize DSPFFD information, today you must code the command. An SQL service could provide flexibility and granularity to access this data for specific objects, similar to SYSCOLUMNS or OBJECT_STATISTICS.
    almost 3 years ago in IBM i / Db2 for i 1 Future consideration

    SQL constraint "FOREIGN KEY DEFERRABLE"

    One strength of relational databases is their constant vigilance over data correctness. The user can declare constraints that their data must obey, and then leave it to the database to enforce the rules. This saves a lot of procedural application ...
    almost 4 years ago in IBM i / Db2 for i 3 Future consideration

    Provide access to Null Indicator for SQL Variables in inline C code

    When creating SQL Functions, we have the ability to use the INCLUDE statement to include inline C code. However, when an SQL Variable is referenced in that C code, there is no practical method to set on or off the variable's NULL Indicator. We nee...
    almost 5 years ago in IBM i / Db2 for i 2 Future consideration

    Make it possible to also define SYSTEM NAME for short LONG NAME for tables

    When creating an SQL Table we define long descriptive names for them. We also define SYSTEN NAME that is used to name RPG Procedure Source files, Modules and Service Programs. When the descriptive "LONG NAME" is 10 letters long or shorter it is ...
    over 3 years ago in IBM i / Db2 for i 4 Future 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.