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
use of wildcards for table selection with REORG,RUNSTATS etc
Certain utilities that most of the time operate on a (sub)set of tables like REORG and/or Runstats would be much easier to operate if the set of tables to be processed could be selected by means of wildcarding. The wildcarding should be enabled on...
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...
LOAD with COPY=YES and TSM needs similar resilience feature like log archiving with VENDOR_ARCHIVE_TIMEOUT
FI has set of LOAD jobs (with COPY=YES and use of TSM) which run in parallel against the Db2 data warehouse.FI experienced failing LOAD jobs in the LAN-free TSM backup environment for the Db2. FI sees risk for the LOAD jobs when TSM is not availab...
timeout option for log archiving sessions / db2vend on WINDOWS
We work with DB2 on WINDOWS and an external vendor (EMC Networker) for backups and archive logging. If network or the vendor have a problem, the archive logging forever tries to use the vendor process and in the meantime writes to a FAILARCHPATH o...
Our Application:24x7. HADR synchronous. LOGINDEXBUILD=ON because of HADR. We have large tables with lots of indexes required for performance reasons. Current problem:We are unable to run online REORG indexes for large tables as this overwhelms our...
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...
Online Reorg takes 10 times the size of the table in logs to complete
Note - case id TS000861837 (it won't let me inter this in the pmr)See example provided in pmr.Some table take more than 10 times the size of the table in logs to complete.There seems to be very little in the way of documentation that I or the pmr ...
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...
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...
Do not place IBM confidential, company confidential, or personal information into any field.