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 238

    change systools.special_authority_data_mart to have option where to place the files in user defined library

    need to make sure the data is "locked down" by being able to place the resulting SENSITIVE file in a different library, just like the audit journal data_mart SQL.
    over 1 year ago in IBM i / Db2 for i 2 Not under consideration

    SQL view to see files used and settings on report written in Query 400

    SQL view to see what files are used and what settings are used on a report written using Query 400. I realize DSPPGMREF can be used but this does not give all of the settings used in constructing the report such as the settings in the Select outpu...
    almost 7 years ago in IBM i / Db2 for i 2 Not under consideration

    directly enter SQL-Arrays as Input Arguments for Stored Procedures

    Our reporting systems calls Stored Procedues on a DB2/400 system via ODBC/JDBC. The SP receives for example one productID and then it collects the desired informations from our DB2400-tables and return it to the reporting system via a result set. ...
    over 3 years ago in IBM i / Db2 for i 1 Not under 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...
    about 6 years ago in IBM i / Db2 for i 2 Not under consideration

    Command to print Query Definitions without using WRKQRY option 6.

    Looking for a command line option to print a *QRYDFN instead of using option 6 from WRKQRY. I need to be able to get that output to provide to audit and I'm trying to automate it as much as possible. Need to be able to call it from CL program. Use...
    almost 8 years ago in IBM i / Db2 for i 4 Not under consideration

    Allow COALESCE to provide automatic CAST

    I have this line in a CREATE VIEW statement: coalesce(va.vaaddress1, '?Unknown') as vaaddress1, When the view is accessed using SQL embedded in ILEPRPG, the SQLSTATE becomes 01004. VAADDRESS1 is defined in a SQL TABLE as CHAR(40). It would save a ...
    11 months ago in IBM i / Db2 for i 1 Not under consideration

    Add temporal information to commands and not just the system catalog

    Add the ability to see temporal relations in the following:- DSPFD- DSPDBR It can be discovered with things likeRetrieve Database File Description (QDBRTVFD) APIhttps://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/apis/qdbrtvfd.htm#HDRTEMPOSys...
    almost 9 years ago in IBM i / Db2 for i 1 Not under consideration

    Include OBJATTRIBUTE in resultSet from OBJECT_STATISTICS when object name is *ALLSIMPLE

    If possible and without impacting performance, please include the OBJATTRIBUTE column with the results when OBJECT_STATISTICS is generating the fast list of objects due to *ALLSIMPLE being specified on the 3rd (object name) parameter. Use Case: Ne...
    over 5 years ago in IBM i / Db2 for i 2 Not under consideration

    Make PTF listing available in XML output

    I was looking at all the great "IBM i Services" and I thought of a new one:List the PTF's available at IBM which are not on my system.However I thought of doing it on my own. First I looked athttp://www-912.ibm.com/a_dir/as4ptf.nsf/WWWPTFBYDATE?Re...
    almost 10 years ago in IBM i / Db2 for i 4 Not under consideration

    Moving old data from production tables to historic tables in another library

    In an active production system such as we have being in a 24 hour service financial environment, we have an issue with old data that exists in many of our database tables. Every second new data is being recorded in this tables and old the old data...
    11 months ago in IBM i / Db2 for i 3 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.