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
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...
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...
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...
Reduce size of LOAD COPY dataset for tables with LOBs and XML
A LOAD COPY where the table being acted on has one or more LOB columns is much larger than the original data / final table size / post load backup. From investigation it is based on the pagesize and extentsize of the underlying tablespace. This pr...
We use a VTL for our Tape Environment. For a VTL it is recommended by IBM to use UNIT=(TAPE,,DEFER) in all Jobs. DB2 uses templates to generate JCL. In this templates it is not possible to code a DEFER parameter. Is there a way to solve this dilemma?
Currently when using db2move utility to export from one system and load to another, there is no way to specify load options for any tables with Identity or Generated columns etc. for which we need to preserve the data values, and the db2move load ...
Do not place IBM confidential, company confidential, or personal information into any field.