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

Utilities (Export Import Load db2look etc)

Showing 121

Provide a documented and supported procedure to generate ddl (db2look as SP - like db2lk_generate_ddl)

db2lk_generate_ddl is a stored procedure that provides functionality to generate DDL via SQL (similar to db2look which is a tool as db2llok cannot be executed througha SQL client tool. This function already exists but is not documented and I am no...
over 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration

Use package collection other than NULLID for CLP and Db2 Utilities

Db2/zOS colleagues want to get rid of lock issues with rebind of packages in schema NULLID, thus the decided to have Db2/zOS release specific package collections to provide actual and rebound packages for every Db2 release to the distributed (Db2/...
over 3 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

db2look with -printdbcfg must support parameters with "automatic" value

To clone a database and all its objects IBM recommend to use the db2look utility. If you use the -printdbcfg to clone the db configuration too the db2look utility generate the parameter values in the update commands but without the "automatic" val...
over 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

Allow a WHERE clause for ADMIN_MOVE_TABLE to delete data while moving a table

One of the most painful things to do is to delete a huge amount of data. One workaround for this is to export the data needed and then LOAD/REPLACE back into the same table, but this requires an outage of the table to accomplish. If a WHERE clause...
about 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

overrule the automatic CPU parallelism calculation of LOAD apart from command line

LOAD does an automatic CPU parallelism calculation, if not explicitly specified in the command by the user.To gain max performance, LOAD assumes, it is the only LOAD (and only application) running on the system and consumes nearly all available CP...
about 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

LOAD / ADMIN_MOVE_TABLE COPY YES and LOB improvements

In an OLTP / TSA HADR environment .. When using the COPY YES on ADMIN_MOVE_TABLE it uses LOAD under the covers. When LOBs are involved howere it writes out the full buffer 64k up to several 100k is written out per column/per row to a file which is...
about 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Inplace Reorg should be allowed on a table with an Expression Based Index

Expression Based Indexes (available since V10.5) are a great feature that can improve query performance without adding a new (generated) column and modifying existing code. But, you cannot do an Inplace Reorg on a table with an Expression Based In...
almost 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

LOAD with COPY=YES and TSM needs similar resilience feature like log archiving with VENDOR_ARCHIVE_TIMEOUT

FI has set of LOAD jobs (with COPY=YES and use of TSM) which run in parallel against the Db2 data warehouse.FI experienced failing LOAD jobs in the LAN-free TSM backup environment for the Db2. FI sees risk for the LOAD jobs when TSM is not availab...
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Log Failed LOADS in db history file

Please refer to IBM CASE TS012541333 for further details Db2 database history file registers several SUCCESS and FAILED operations. If a backup has been executed, and if it failed or completed ok . if a restore has been done, and if it failed or c...
over 1 year ago in Db2 / Utilities (Export Import Load db2look etc) 3 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...
almost 8 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration