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 441

    Add options to TRUNCATE to support clearing a single partition (member)

    The SQL TRUNCATE statement currently only supports removing data from the entire table, even when run against an ALIAS created against a single partition. Use Case: Fast truncation of a single partition (member), just like CLRPFM with a specific m...
    over 5 years ago in IBM i / Db2 for i 2 Future consideration

    Have BCI jobs inherit the QAQQINI file library from the parent job

    A Web Application Server running PHP initiates SQL requests that run in a batch immediate job. The BCI job picks up the QAQQINI file in QUSRSYS. However, the application needs unique settings that cannot be applied system-wide. It is possible to s...
    over 5 years ago in IBM i / Db2 for i 2 Not under consideration

    Temporal Support For System Tables

    V7R3 of Db2 i introduced support for temporal tables. However, it is not possible for an end user to alter the system tables; such as QADBXREF / QADBIFLD, to be defined as temporal. Attempting to alter the table results in the following error mess...
    over 5 years ago in IBM i / Db2 for i 3 Future consideration

    Select into :dsArray

    It would be great to be able to select columns from a table directly into a data structure array instead of going through the process of creating a cursor. Because a lot of times you just want the list of matches and then your done. It makes even ...
    almost 6 years ago in IBM i / Db2 for i 6 Not under consideration

    Provide ARD Program(s) for non-Db2 Connect from IBM i

    WRKRDBDIRE supports *ARDPGM but none are provided, by IBM. The system needs the easy abilitty to connect to non-Db2 database systems, like MariaDB, SQL Server using SQL via *ARDPGM. Provide basic support (perhaps using ODBC or JDBC drivers) for re...
    almost 6 years ago in IBM i / Db2 for i 8 Not under consideration

    SQL DB2 change in the for system name

    When you create an SQL table and the object identifier specified is a valid system name you can not specifiy a different for system name. I would like to be able to specifiy a different name for compatibility with older programs while using newer ...
    almost 6 years ago in IBM i / Db2 for i 2 Not under consideration

    ifs_object_statistics with /QNTC

    We would have liked ifs_objects_statistics to report entries in the /QNTC file system. Our fall back is some IFS API's that will handle this. Use Case: We have a requirement to read the contents on a Windows server and then to pull .xml files from...
    almost 6 years ago in IBM i / Db2 for i 1 Future consideration

    have STRSQL inform user about *POINTER output in table functions

    playing around with new functions like qsys2.ifs_object_statistics.First was confused when using STRSQL that PATH_NAME is reported as *POINTER; using the iACS GUI execute SQL function the result was ok.Have STRSQL either display correct values (ev...
    almost 6 years ago in IBM i / Db2 for i 2 Not under consideration

    RPG IV extension regarding license program 5770SS1-27-DB2-Multisystem

    RPG IV provides a file information data structure with database specific feedback information. In position 397 of the FIDS there is an unsigned integer field for the relative record number. This field contains the RRN of the record which was affec...
    almost 6 years ago in IBM i / Db2 for i 2 Not under consideration

    Local scoped functions and procedures in UDTF and stored procedures

    For structural reasons you sometime need to encapsulate logic as locally scoped functions and procedure when you create UDTF and stored procedures - just like you would do in any other programing language. However SQL-PL does not allow that in the...
    about 6 years ago in IBM i / Db2 for i 3 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.