I have couple of CLOB columns which is taking the 80% of the total db size. Now I wish to come up with new idea to convert it to different variable to reduce the storage space. Let me know for any questions...
Insufficient detail in your question. Post relevant facts, such as the DDL (from db2look) for the table(s) concerned, your DB2 version+fixpack+operating-system-platform. You may need to engage with your application developers and/or a data modeller to assess the impacts of any changes you propose.
I think i need to rephrase it. The CLOB has inline and outline.
I need to calculate how much is the size of a row for both columns.
then we need to check if it can be occomodated in VARCHAR if not what more options do we have to bring down the size.
May be xml ?
Just want to know what other option can bring these sizes low
Since you want to reduce the amount of disk space being used, I would suggest this. Since it appears that (based on the column names) that they contain XML data. Change the columns to type XML and turn compression on to have DB2 make them smaller on disk.
Obviously, you will need to work with the developers to change the data type.
Thanks for that great answer. Thats my doubt too. How do you think the CLOB conversion to XML will bring down the space utilization ? Turning on adaptive compression can surely bring down however I still wonder if XML variable will bring down the space utilization ?