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
LOAD should allow collecting STATISTICS without USE PROFILE option for row based tables
LOAD collects "default" statistics like auto-runstats when loading into BLU (RUNSTATS ... WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL).I assume this got not changed because the fear of incompatibility with existing behavior. Therefore pleas...
Add CLP commands not supported by ADMIN_CMD to CLPPlus
Some CLP commands are neither supported by CLPPLUS or ADMIN_CMD. BIND, REBIND and the various REGISTER commands for XSR are particularly troublesome examples. This means that we have to revert to CLP processing rather than doing everything in CLPPLUS
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".
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 ...
Preserve table creation timestamp after reorg-finsished using admin_move_table procedure (online table move)
Following Knowledge Center, https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0024850.htmlwe perform table reorg using admin_move_table . The issue is, after run admin_move_table command, the original...
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...
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...
Add option in db2look to not extract LBAC every time
All of the LBAC definitions are extracted and printed every time the -e option is specified. If one just wants the DDL for a single table, all of the LBAC definitions are printed, even if that table has nothing to do with LBAC. A -nolbac option wo...
Do not place IBM confidential, company confidential, or personal information into any field.