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 378

Preserve SQL view formatting

When creating complex views their readability is highly dependent on the formatting of the complex SQL statement. When retrieving the SQL definition of an existing view (in order to update it), the majority of the formatting is lost however which ...
about 3 years ago in IBM i / Db2 for i 4 Not under consideration

Allow *LIBL or omitted library on INCLUDE statement in SQL Stored procedures and Functions

The INCLUDE statement used to include C code in an SQL LANGUAGE Stored Procedure or User Defined (Table) Function requires an explicit library name. Common software development practices will have different versions or levels of code in different ...
about 3 years ago in IBM i / Db2 for i 2 Future consideration

Provide access to Null Indicator for SQL Variables in inline C code

When creating SQL Functions, we have the ability to use the INCLUDE statement to include inline C code. However, when an SQL Variable is referenced in that C code, there is no practical method to set on or off the variable's NULL Indicator. We nee...
almost 4 years ago in IBM i / Db2 for i 2 Future consideration

PTF tool to identify missing co, prereq, and delayed ptf

Create application and supporting API to allow a user to query and compare PTF co/prereq and other information to what is installed on an LPAR versus what is available on fix central. Use Case: Use case would be to simplify PTF research. When ther...
about 4 years ago in IBM i / Db2 for i 3 Not under consideration

documentation for the journal entries MC

the " F MC" journal entries: https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_71/rzaki/rzakivarlength.htm#rzakivarlength__TBLOBJLVL contain information about table changes however the details of the table structure are not documented. The tab...
about 4 years ago in IBM i / Db2 for i 2 Not under consideration

Increase maximum file member size

Increase maximum file member size, currently limited to 1.7TB. Use Case: customer stores large binary objects in file using SQL and reaches file limit. Currently they do not want to separate objects to multiple tables or work with partitioning.
over 5 years ago in IBM i / Db2 for i 2 Not under consideration

Need SQL Procedures to allow the ownership to be changed and to allow the use of adopted authority

We would like to have an SQL statement way of changing the ownership of a stored procedure. The TRANSFER OWNERSHIP SQL statement does not support stored procedures.In addition, there needs to be a SQL statement way of allowing a stored procedure t...
over 6 years ago in IBM i / Db2 for i 2 Future consideration

Logging / Monitoring SQL activity after and within a DRDA connection session

The IBM i O/S does not have the ability to monitor SQL transactions via DRDA connection from a remote system. This would be from the exit point DDM/DRDA request access in the network attributes (DSPNETA). Use Case: I would like to have the ability...
about 7 years ago in IBM i / Db2 for i 4 Not under consideration

Add Metaphone 3 (or better) to SQL to supplement SOUNDEX() UDF

SoundEx() (in SQL) is dated and returns too many false-positives. For example "COMFORTER" and "COMPRESSOR" return the same SoundEx index. There is a updated routine called Metaphone 3 that is supposed to provide better results. Please implement th...
about 7 years 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...
over 7 years ago in IBM i / Db2 for i 1 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.