Releasing VC LOB space

After you upgrade to IBM® UrbanCode® Deploy 7.0.5 and later, you can compress the amount of large object (LOB) storage space that IBM UrbanCode Deploy uses in the vc_persistent_record database table.

Releasing the LOB storage space is optional. If you don't release the space, it is reused when new records are added. You can decide whether you want to release the LOB storage space for the following reasons:

  • You can reduce storage space by 75%.
    Reduce the size of one of the largest tables in IBM UrbanCode Deploy where the text data decreases by 50-75%.
    • A 2-byte character to an average of 1-byte per UTF-8 character which is up to 50% reduction.
    • XML might compress by 87% or more because XML data contains many repeated keywords.
  • You can achieve up to a 50% reduction in read time.