Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. 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

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea


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.

IBM Employees should enter Ideas at https://ideas.ibm.com


ADD A NEW IDEA

Db2

Showing 1338

MERGE INTO statement failed with SQL0104N (inconsistent with DB2 Z/OS)

he following query, which works well on DB2 Z/OS, failed with the syntax error(sql0104n) ................................................ MERGE INTO SME.MEC_GNRL_PRDT_BRNH_BLNC A USING ( VALUES ( :H_iinou_date, :w_irltvr_enty_id, :w_iprdt_id, :H_i...
about 7 years ago in Db2 / Application Development 0 Not under consideration

use of wildcards for table selection with REORG,RUNSTATS etc

Certain utilities that most of the time operate on a (sub)set of tables like REORG and/or Runstats would be much easier to operate if the set of tables to be processed could be selected by means of wildcarding. The wildcarding should be enabled on...
about 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration
133 VOTE

export data from tables out of a backup image

Introduce a new parameter to the export utility to be able to export data from a table that is in a backup image.This functionality is especially useful for data extraction without touching/impacting the source system
about 7 years ago in Db2 / Backup/Restore/ Rollforward/ Recover / Utilities (Export Import Load db2look etc) 2 Future consideration

Enable classic reorg with "allow write access"

Many customers want to REORG their tables quickly and efficiently. The classic REORG is by far the fastest option but puts the table in read only mode. Inplace reorg allows write access but is much slower and not suitable for tables that have a hi...
about 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 3 Future consideration

allow external UDFs to be precomputed by the DB2 compiler

what reported in PMR 14482.227.000 treated as expected and a RFE suggested to help address the need
about 7 years ago in Db2 / Federation 0 Not under consideration

CASE with EXISTS in UPDATE returns SQL0582N, which is inconsistent behavior with db2 z/OS

db2 "update test_tab set c1=case when exists (selectc2 from test_tab where c2=1) then 'A' else 'B' END" DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it retu...
about 7 years ago in Db2 / Application Development 1 Not under consideration

Support compilation of PL/I and COBOL programs without an active DB2 connection

The compilation of PL/I and COBOL programs on the z/OS mainframe is possible without an active database connection.This does not work on the AIX platform, which requires a database connection during compilation and a DB user withsufficient privile...
about 7 years ago in Db2 / Application Development 0 Not under consideration

purescale support HADR ROS

System: DB2 LUW pureScaleActor: User needing HADR read of standby on pureScale environmentNow db2 V10.5 and above had provided HADR component for pureScale but missed Read of standby feature. Description: some customer had used HADR ROS feature on...
about 7 years ago in Db2 / High Availability and/or Disaster Recovery 2 Future consideration

BLU Load message improvement for SQL3119W

DB2 BLU load on LUW provides a less than optimal message for SQL1119W. It reports that an input data value has been replaced by NULL but does not indicate which specific input row caused the error resulting in no good way to troubleshoot the issue...
about 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Grant 'create, drop and alter a tablespace' authority to specific user

The Sysctl group can create, drop and alter a tablespace in db2 and also have all authorities of SYSMAINT and SYSMON. Customer just want to give tablespace control authority to specific user.
about 7 years ago in Db2 / Security 0 Not under consideration