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
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
Reorg blocking applications when using "allow write access"
While an "allow write acces" online reorg is running lock-wait contention can happen based on the number of rows being updated by an application. The locks for the application can escalate to lock an x lock. If this situation happens, the reorg sh...
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/...
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...
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...
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...
Hi, Currently, it is not possible to replicate data in a hadr cluster when you load data with "db2move -lo" and you use the registry variable DB2_LOAD_COPY_NO_OVERRIDE=COPY YES to <path> with blocklogged=yes on the database configuration.
For example, the customer wants to get the name list for tables which are in load pending status, he may issue a SQL statement "select tabschema,tabname from sysibmadm.admintabinfo where load_status='PENDING'", the statement will execute for a ver...
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...
Do not place IBM confidential, company confidential, or personal information into any field.