DAMHIKT, but it seems stuffing more in less space is popular (try going on vacation with a family). Fortunately, the next release of DB2 adds a lot of compression features. On the page for the Technology Sandbox (a.k.a. “beta”) the following compression functionality is mentioned in addition to DB2’s deep table compression:

• Multiple algorithms for automatic index compression.
• Automatic compression for temporary tables.
• Intelligent compression of large objects and XML.

AAF I can tell U that this is cool stuff.

Index compression saves you big because you usually have plenty of them and compressed indexes are still compressed when in the bufferpool. Compression of temporary tables is especially useful for analytics/warehousing. Sign up and test it yourself!

SIG2R.

CU, Henrik (DARFC)

BTW: I got some help coding parts of my blog using this abbreviation list.