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 updateson 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,
Post an idea
Upvote ideas that matter most to you
Get feedback from the IBM team to refine your idea
Specific links you will want to bookmark for future use
Db2 load ALLOW READ ACCESS support for column organized table
Currently, if a db2 load is happening on a column organized table, users are NOT able to read the data from same table until the load is finished. It's inconvenience for the customer and its users in their daily operation. Thus, the customer wants...
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...
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 red...
db2look should offer an option to sort the generated objects
When generating db2look in different server, databases, configuration, the order is not the same (probably because the creation order was different) and it is difficult to compare objects in different databases.
Allow REPAIR CATALOG on indexes to reset version numbers
In Db2 Cloning Tool, index version mismatches cause indexes to be rebuilt on the target rather than using the physical copy. Some of these indexes are very large. Corrective measures would be to drop and recreate the index on the source which woul...
Ability to append to a file when performing an export
When exporting data to files, every export should be in a different file. And it the business requirement is to have all data in the same file, then it is necessary to do that manually with something external to db2.
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 a...
Do not place IBM confidential, company confidential, or personal information into any field.