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 361 of 4269

Improve performance of REGEXP_xxx SQL functions

The REGEXP_SUBSTR and related SQL Regular Expression functions a great, but rely on external interfaces. The request is to figure out a way to make them perform better regardless of them being based on the eternal ICU library. In one-off situatio...
over 1 year ago in IBM i / Db2 for i 2 Future consideration

get_xml_file() need to be encoding agnostic

The get_xml_file() is a fantastic tool to load XML files from the IFS. However it will fail if data is stored in utf-16LE format.
over 1 year ago in IBM i / Db2 for i 1 Future consideration

Optimize sparse index build on partitioned table

The index build process is currently not using the information on a partitioned table when building the index: We have a big table partitioned by range on a column.When we build an sparse index on this table only including values in this column gr...
almost 3 years ago in IBM i / Db2 for i 2 Not under consideration

Change the default of CRTPF parameter SIZE

We are on 7.2, going to 7.3 soon. The default for CRTPF is SIZE(10000 1000 3). This means only 13000 records are required before escape message CPA5305 is issued. The default can be changed using CHGCMDDFT, but it's set back to the original IBM se...
over 4 years ago in IBM i / Db2 for i 5 Not under consideration

Materialized Query Table functionality

Add capability in SQL to create Materialized Query Tables (MQT) with the following:1. data initially deferred refresh immediate2. maintained by system3. set integrity for (MQT) immediate checked incremental (or Not Incremental) Use Case: create ta...
over 5 years ago in IBM i / Db2 for i 2 Future consideration

Have BCI jobs inherit the QAQQINI file library from the parent job

A Web Application Server running PHP initiates SQL requests that run in a batch immediate job. The BCI job picks up the QAQQINI file in QUSRSYS. However, the application needs unique settings that cannot be applied system-wide. It is possible to s...
almost 4 years ago in IBM i / Db2 for i 2 Not under consideration

Provide a QCMDEXC-Likc Stored Proc that uses CONTAINS SQL

Provide an NEW SQL Stored Procedure for QCMDEXC or QCAPCMD that is set to CONTAINS SQL instead of MODIFIEDS SQL DATA. Use Case: When creating user-written SQL Functions that only contain SQL statements or perhaps READS SQL DATA, the use of QCMDEXC...
about 2 years ago in IBM i / Db2 for i 6 Not under consideration

Add optional argument for XMLPARSE

To use XMLPARSE, the external encoding of the data need to be consistent with XML prolog. But, often, the encoding of the variable (in hosted langage or CLOB) isn't the same as original value. For example : when we receive an XML file by FTP or ot...
almost 2 years ago in IBM i / Db2 for i 1 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...
over 3 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...
over 3 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.