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

    Add Support for COMMENT ON to SQL VIEW, SEQUENCE etc.

    Add support to add OBJECT TEXT (COMMENT ON or LABEL ON in SQL terminology) to those SQL-created objects that are currently not supported. by the COMMON ON statement.Such as VIEWS, SEQUENCES, TRIGGERS etc. Use Case: Today, when you create (for exam...
    about 4 years ago in IBM i / Db2 for i 5 Not under consideration

    Obscure the RUNSQL and RUNSQLSTM Workfile names in QTEMP

    When using RUNSQLSTM in CL, a source file is created in QTEMP with the name QSQLSRC.Users with QTEMP on their library lists now have a "magically appeared" file on their library list that may cause corruption of tasks that previously ran normally....
    about 4 years ago in IBM i / Db2 for i 3 Not under consideration

    Support USER as Default for VARCHAR(10) Columns in Db2 SQL Tables

    Currently if I have a table with a varchar(10) field in it, I cannot specify DEFAULT USER or any of the other user registers because they are 18 bytes or longer.However on IBM i, user Profiles are 10.It would save me having to write a Trigger for ...
    about 4 years ago in IBM i / Db2 for i 1 Future consideration

    Improve the SET DESCRIPTOR statement

    The usage of the SET DESCRIPTOR statement is currently complex, tedious and error prone, this leads to hard to maintain code and the usage of anti patterns like user supplied strings directly inserted into dynamic SQL or complex case statements in...
    about 4 years ago in IBM i / Db2 for i 1 Not under consideration

    Eliminate the Propagation of READS SQL DATA in Caller Functions in SQL

    When creating User Defined Table functions in SQL, the CONTAINS SQL, READS SQL DATA and MODIFIES SQL DATA statements are currently propagated up the food chain. This means if a simple function calls another function, that called function's attribu...
    about 4 years ago in IBM i / Db2 for i 2 Not under consideration

    Enhance SQL *PRV Signature Support to be at least as good as *SRVPGM Signatures

    When creating an SQL VIEW that uses an IBM i Service or another SQL Table Function on release "N" and the restoring that SQL VIEW onto another system with release N-1, a Signature Violation occurs when attempting to query that SQL VIEW using SQL.T...
    about 4 years ago in IBM i / Db2 for i 1 Future consideration

    Add the "Command to Run" field to the JOB-INFO table query

    Please add the "Command to Run" parameter to the query. It has nearly all the commands parameters except this one. Use Case: We use a complex process at month end to prepare jobs to run at month end. I need to be able to view the jobs submitted to...
    about 4 years ago in IBM i / Db2 for i 4 Not under consideration

    Timestamp change when altering a partitioned tables partitions

    The good (smart) thing about partition table is that when you take a back up you can tell BRMS to take a back up only on changed partitions. When altering a tables partitions, the changed timestamp is changed on all partitions, not just only the o...
    about 4 years ago in IBM i / Db2 for i 2 Not under consideration

    Retain 132 Columns in DSPF CL command when switching to HEX (F10) Mode

    When using the IFS DSPF command to look at an IFS file, the F10=Hex key can be used to view the file in hex. However on 132x27 screens the Hex view is restricted to 80 characters and the addition 52 characters per line remain blank.It is important...
    about 4 years ago in IBM i / Db2 for i 1 Future consideration

    Visual explain as a SQL - IBM i service

    Visual explain is a vital tool to get the information about how a SQL statement is processed and to understand the nature of SQL queries. However, it can be quite complicated to oververview complicated queries and the graph can be quite chaotic. M...
    about 4 years 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.