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.
More and more SQL is stored in repositories and needs to be applied in odd places and orders. One syntax element that supports this is the "IF EXISTS" on a drop statement. This causes a statement to not count as a failure if it finds no object to ...
Executes external commandline-scripts from stored procedure.The stored procedure call should work like following:select * from (VALUES '`sh /tmp/test.sh`') AS TEMP(Testoutput);With the script i check if new created tables or views from developmen...
DB2Z-Allow for EXCHANGE DATA function on Clone table to NOT put packages in VALID status of 'A'
We have processes that use the clone table feature to allow for non disruptive load operations. When we do the exchange data the packages on the primary table move to a VALID STATUS of 'A' when they had a status of 'Y' previously. This creates iss...
Allow table compression to be disabled for DGTTs and CGTTs
In short: OLTP applications frequently encounter performance issues because DB2 enables table compression by default for all DGTTs / CGTTs.Details from a real-time example:When inserting 40K rows to a DGTT, it takes 2 seconds.When we immediately i...
New NOT NULL columns cannot be added to an empty table without a default value.
Submitted on behalf of Gregor Hack (email@example.com).New NOT NULL columns cannot be added to an empty table without a default value (WITH DEFAULT). Customer currently sets a dummy default value, which they drop afterwards.
Allow complete acces path in optimization hint (like db2 for ZOS)
We have the same cobol application that on both z/os and luw.We are using static sql in packages. We run 12 schemas using the same sets of tables in each for manual application parallelism.Occasionally a package for a given schema will flip acces...
This customer is receiving the SQL0437W warning when the DB2 optimizer changes strategies, this warning makes applications and scripts fail. He is one of many customers complaining that it makes application and script fail. This warning should not...
Do not place IBM confidential, company confidential, or personal information into any field.