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 450

    Preserve SQL view formatting

    When creating complex views their readability is highly dependent on the formatting of the complex SQL statement. When retrieving the SQL definition of an existing view (in order to update it), the majority of the formatting is lost however which ...
    over 4 years ago in IBM i / Db2 for i 4 Not under 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

    SQL-CLI Support "FOR" System names

    When creating SQL tables with the keyword "FOR" system names to support legacy code, then for "FOR" system name is not available in the SQL-CLI api's. The "SQLColAttribute" should support SQL_DESC_SYSTEM_COLUMN Use Case: We are in a situation wher...
    over 4 years ago in IBM i / Db2 for i 3 Future consideration

    Provide functionality to query RFE information via IBM i Service

    Provide an IBM i Service that allows users to query the RFE database from their IBM i server. All details shown on the website / available when downloaded, should be returned; including comments that could be "concatenated" into a (DB)CLOB column....
    over 4 years ago in IBM i / Db2 for i 1 Not under consideration

    Enable Global Override of Compiler Options for SQL Statements

    We are using SQL Functions and due to our security concept, those SQL Functions need to be created with the compile options USRPRF and DYNUSRPRF both set to *OWNER. This can be done by calling SET OPTIONS inside the CREATE OR REPLACE FUNCTION stat...
    over 4 years ago in IBM i / Db2 for i 3 Future consideration

    Enhance SQL UDTF LANGUAGE SQL INCLUDE statement to support user-written C functions

    When building new capability for the #IBMi platform, we use the CREATE TABLE FUNCTION and CREATE FUNCTION SQL statements with the "INLINE" statement, to pull in source code written in the C language.Today, one "block" of code is permitted per incl...
    over 4 years ago in IBM i / Db2 for i 4 Future consideration

    Correct accuracy of inline error location in ILE C compiler for SQL

    When using SQL to create a User Defined Function, the RUNSQLSTM and other interfaces generate C source code and compile it. When the developer also uses the INCLUDE statement in that same code, to pull in some "inline C" code, when there are error...
    over 4 years ago in IBM i / Db2 for i 2 Is a defect

    Optimize sparse index build on partitioned table

    The index build process is currently not using the information on a partitioned table when building the index: We have a big table partitioned by range on a column.When we build an sparse index on this table only including values in this column gr...
    over 4 years ago in IBM i / Db2 for i 2 Not under consideration

    Improve Performance of QSYS2.BOUND_SRVPGM_INFO

    The performance of QSYS2.BOUND_SRVPGM_INFO is really bad when you're using it in order to get all programs that use a specific BOUND_SERVICE_PROGRAM. More details can be found in the defined Use Case. However, using the same View with the given st...
    over 4 years ago in IBM i / Db2 for i 2 Not under consideration

    We need >99 QDBSRVnn tasks

    The current limit of QDBSRVnn tasks is 99. We need more such tasks. We need a three-digit number. Use Case: We need more tasks to rebuild access paths in parallel. The current limit of QDBSRVnn is 99. Only half of them (50) are used for rebuild. T...
    almost 5 years ago in IBM i / Db2 for i 2 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.