IBM Data and AI Ideas Portal for Customers


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:

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,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. 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.

Additional Information

To view our roadmaps: http://ibm.biz/Data-and-AI-Roadmaps

Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases

IBM Employees:

The correct URL for entering your ideas is: https://hybridcloudunit-internal.ideas.aha.io


Status Future consideration
Workspace Db2
Components Data Types
Created by Guest
Created on Jul 20, 2021

Improve XML length/sizes determination

One of the frequent questions I receive from application teams, when dealing with XML data is :

  • What is the max size of my xml documents in database ?

  • What is the average size of them ?

Today, Db2 has no easy answer for that.. the LENGTH() function does not support XML types, and you are forced to serialize it to a CLOB type in order to get it's length()/size.

This idea is to improve this gap, by making the LENGTH() function to work against XML data types.

Instead of serializing it, for each row, the serialized length could be saved in the XDA area, as meta-data information, together with the xml real content. Every time a xml column is updated or inserted, db2 could compute it's serialized length, and save this value in a meta-data section, together with the xml doc.

This should improve performance to retrieve such information in the future, and the length() function could grab that information, instead of having to compute the xml size at run time.

Today, is almost IMPOSSIBLE to retrieve that information for BIG tables. Db2 consumes a LOT of TEMPSPACE area to serialize the documents to CLOB types, in order to retrieve the max/avg values present in any given column for the entire table.

Just to give you an idea, Db2 consumed more than 20 GB of TEMPSPACE, in order to determine the max XML length for a table which had around 30 million rows.
I support databases with xml columns on tables having more than 1 Billion rows, and we don't have enough space to compute their sizes.


This new approach would avoid the need to serialize it, improving the overall performance and remove completely the need to use large amount of TEMPSPACE just in order to determine xml doc sizes in behalf of customers requests.



Needed By Yesterday (Let's go already!)