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 233

    Add Job Date Column as SPOOL FILE CREATION JOB DATE to OUTPUT_QUEUE_ENTRIES UDTF

    The CREATE_TIMESTAMP column of the QSYS2.OUTPUT_QUEUE_ENTRIES UDTF is the System Date/Time that the SPOOL file was created. However, the need for the Job Date/Time on which the SPOOL File was created is needed. Need a new column JOB_RUN_DATE that ...
    over 7 years ago in IBM i / Db2 for i 5 Not under consideration

    Use of unqualified objects in SQL-based triggers

    When connecting to db2 on our iSeries we are used to using jt400/jdbc property naming=system, which enables us to use unqualified objects like tables, stored procedures and such. This brings great flexibility. When a trigger containing unqualified...
    over 8 years ago in IBM i / Db2 for i 2 Not under consideration

    AES Crypt

    Make the AES algorithm compatible with AES calculated by different software platforms. The ENCRYPT_AES sql function can encrypt a DB column. Unfortunately the algorithm is IBM proprietary [The internal encryption algorithm used is from the CLiC To...
    about 2 years ago in IBM i / Db2 for i 1 Not under consideration

    Severe problem with command RCLDBXREF while trying to rebuild the system catalogues tables.

    We recently ran into severe problems with command RCLDBXREF & as a result would like to see a few changes made. Last week (11/01/18) we noticed that system catalogue table QADBFDEP was missing entries for certain joint logical files on our pro...
    almost 8 years ago in IBM i / Db2 for i 3 Not under consideration

    Allow variables defined with like(...) to be used as embedded SQL host variables

    Variables defined with like(...) should be usable as embedded SQL host variables. Allowing only variables defined with a specific datatype makes for more difficult application maintenance.
    over 2 years ago in IBM i / Db2 for i 2 Not under consideration

    Column Heading for CPYTOIMPF

    I had a client requesting an enhancement for column heading in cpyto/frmimpf. He wants to be able to import text or alias via the ADDCOLNAM parameter. He was expecting *SQL to give him the results but he was using a DDS file with text. He pointed ...
    about 9 years ago in IBM i / Db2 for i 1 Not under consideration

    Disabled the looging of negative sql codes in the JOBLOG of a JOB

    In RGP developments embedding SQL when we encounter a Negative SQL code, even if it is managed in the program, it returns lines in the processing JOBLOG.So a log of several thousand lines is generated if the program returns a lot of negative SQL c...
    about 8 years ago in IBM i / Db2 for i 5 Not under consideration

    Allow APYJRNCHG and RMVJRNCHG to use remote journal receivers

    APYJRNCHG and RMVJRNCHG do not allow remote journal receivers to be used, however after saving the receivers and restoring them into the receiver library of the local journal, they can be used without a problem. This however needs manual steps and...
    over 2 years ago in IBM i / Db2 for i 1 Not under consideration

    Add &SYSTEM as option in Query Manager Report

    Query Manager Report Forms currently has three variables that can be used in Page Heading section: &DATE, &TIME, &PAGE. &SYSTEM would be very helpful addition. Use Case: We make wide use *QMFORM objects for presenting SQL reports i...
    over 8 years ago in IBM i / Db2 for i 3 Not under consideration

    LISTAGG - Add parameter for length and allow less than 4000

    The new LISTAGG function is very convenient. Two things that have us scratching our heads though:(1) Why does the length have an arbitrary minimum of 4000?(2) Why is setting a different length done by a CAST of the input instead of just adding a 3...
    over 8 years ago in IBM i / Db2 for i 2 Not under 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.