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

auto-reorg OLR for cleanup of overflows

Auto-reorg should use online window to issue REORG CLEANUP OVERFLOWS (and also trigger a RUNSTATS afterwards).Problem to solve: SQL optimizer thinks overflow accesses are quite expensive and then might to start choosing different access plans that...
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

Performance penalty in LOAD when using large bufferpool

LOAD RESETDICTIONARYONLY and other LOADs take very long, if table resides in large buffer.The limitation also applies to LOAD on row based tables, but bufferpools on BLU systems tend to be much larger.
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 1 Not under consideration

Add Runstats Check functionality for DB2 LUW objects (similar to Reorgchk) to determine if a table really needs runstats or not

No description provided
almost 4 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Add db2move option to read/write compressed files

Sometimes during a migration diskspace runs low. It would be great to have an option for db2move, which reads/writes files compressed or pipe it through gzip/bz2/... This would lead to a storage reduction during migrations of roughly 80% plus redu...
almost 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

DBA needs control over Jobs from Automatic Maintenance

We recently had an outage due to automatic maintenance - reorg on a table to reclaim extents. Application A (db2hmon) was running a reorg reclaim on a table and Application B which was already connected to the database and was running a job, as a ...
over 7 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Redesign of cleanup on remote cursor load of LOB data

Customer migrated from DB2 9.1 on Solaris to DB2 9.7 onLinux. As restore is not supported between different endianarchitecture, load by remote cursor was used for datamovement. There was one single table storing about 400 GB ofLOB data (BLOB), tot...
almost 10 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Add the new IF EXIST functionality to db2look

The new syntax IF EXISTS for CREATE and DROP TABLES (see https://ibm-data-and-ai.ideas.aha.io/ideas/DB24LUW-I-259) should also be generated by db2look on demand. This would help and simplify migration scenarios with db2look. This should also be av...
about 5 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Perform rebuild of each index (for a table) in its own transaction

In the current design, all the index rebuilds for a table are performed within the same transaction (as the action that triggered them). If the transaction is interrupted (e.g. user interrupt or dropped session), then the entire transaction is rol...
about 10 years ago in Db2 / Utilities (Export Import Load db2look etc) 2 Not under consideration

support "fixed record length" for load/import with UTF8

Load and import do not support "fixed record length" for MBCS.The field offsets have to be specified in bytes only.There is no possibility to let the data movement tools "think in letters, instead of bytes".
about 8 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration

Enable 'db2move' to change definitions during COPY SCHEMA

Using a list of schemas with db2move COPY schema function allows to copy a database content including function and procedure definitions from one database to another,And in the default mode "DDL_AND_LOAD", it copies definitions and loads data usin...
over 6 years ago in Db2 / Utilities (Export Import Load db2look etc) 0 Not under consideration