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:
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
Help IBM prioritize your ideas and requests
The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The product management team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.
Receive notification on the decision
Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.
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...
overrule the automatic CPU parallelism calculation of LOAD apart from command line
LOAD does an automatic CPU parallelism calculation, if not explicitly specified in the command by the user.To gain max performance, LOAD assumes, it is the only LOAD (and only application) running on the system and consumes nearly all available CP...
ADMIN_MOVE_TABLE should immediately fail or at least warn when source table is ineligible for SWAP
Even after upgrading the database to Db2 V11.5 and beyond, older tables with check constraints and/or generated columns that were created before V9.7 will still cause the SWAP phase of ADMIN_MOVE_TABLE to fail with SQL0668N reason code 10. The und...
LOAD / ADMIN_MOVE_TABLE COPY YES and LOB improvements
In an OLTP / TSA HADR environment .. When using the COPY YES on ADMIN_MOVE_TABLE it uses LOAD under the covers. When LOBs are involved howere it writes out the full buffer 64k up to several 100k is written out per column/per row to a file whic...
Inplace Reorg should be allowed on a table with an Expression Based Index
Expression Based Indexes (available since V10.5) are a great feature that can improve query performance without adding a new (generated) column and modifying existing code. But, you cannot do an Inplace Reorg on a table with an Expression Based I...
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 availabl...
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...
Do not place IBM confidential, company confidential, or personal information into any field.