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 174

    DB2 for i PTF services to use ESA configuration for internet access

    SYSTOOLS.GROUP_PTF_CURRENCY and SYSTOOLS.GROUP_PTF_DETAILS are great tools to keep track of missing PTFs on a system. When running SQL statement against this view, there is an internet connection from the system to PSP documents. This is a direct ...
    over 8 years ago in IBM i / Db2 for i 1 Future consideration

    Add FOR COLUMN or FOR SYSTEM NAME to Function Return Column Definitions

    For User-defined SQL Function, today we can define returned column name using up to 128 characters. There currently (as far as I know) is no way to also assign a shorter, more memorable "System Column Name" to the returned parameter. For example:...
    over 3 years ago in IBM i / Db2 for i 1 Future consideration

    Update cascade on constraints

    Update cascade is allowed in other databases but, is restricted in DB2 for i, as more developers are modernizing their tables and are using constraints, referential integrity etc. This is going to be needed more and more.
    over 3 years ago in IBM i / Db2 for i 2 Future consideration

    EDRSQL server requires QUSER *RWX authority to ROOT

    We recently secured our ROOT directory in the IFS; however, when the EDRSQL server job (QXDAEDRSQL) starts up; MSG CPE3401 is shown in the joblog and the job ends. (see attached joblog) The Security Audit Journal records an Authority Failure (AF) ...
    over 2 years ago in IBM i / Db2 for i 2 Future consideration

    SQL Service qsys2.dns_lookup_ip() needs to return *all DNS name for given IP address

    the new SQL service qsys2.dns_lookup_ip() should return all the DNS names. currently if only returns the first one found for your given DNS setup. the DIG command does return all associated names
    over 2 years ago in IBM i / Db2 for i 3 Future consideration

    Allow journal entry read (RCVJRNE) and native DB I/O with field proc encoded data.

    Consider a field proc used for field level encryption. When replicating database activity, the data must be decrypted as it is being read from the journal. It then must be re-encrypted when it is written to the database. It would improve performan...
    over 2 years ago in IBM i / Db2 for i 2 Future consideration

    ALTER SEQUENCE: ALLOW SUBSELECT

    It would helpful to use an expression like a subselect with DDL, such as: alter sequence XYZ.SEQ1 restart with (select max(ID) + 1from XYZ.TAB1) Use Case: It is common to add rows to a table. If one of the columns is not an identity column but ins...
    about 8 years ago in IBM i / Db2 for i 1 Future consideration

    SQL Add ANCHOR DATA To (%TYPE) functionality

    The lack of support for the %TYPE or ANCHOR DATA TO for data declarations affects our ability to port databases that use this functionality. We are looking at porting a Postgres based application to IBM i and have a large number of functions that ...
    almost 7 years ago in IBM i / Db2 for i 2 Future consideration

    Speed up table partitioning

    Databases are constantly increasing in size, and more and more IBM i customers are approaching or exceeding the limits for a single DB2 table: 1.7 TB storage or 4.2 billion rows. DB2 MultiSystem allows for a table to have up to 256 partitions inst...
    almost 3 years ago in IBM i / Db2 for i 2 Future consideration

    Remote User/Password in ARCN0100 (Connect format)

    An SQL Client Integration Exit Program (ARDPGM) receives remote DB credentials from the SQL system via the Connect format ARCN0100. Both User ID and Password parameters are limited to 10 characters each and the user ID contains only upper case cha...
    almost 3 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.