GM,

I have couple of questions related to value compression feature in DB2
V8.2
[1] Any method to get the list of tables enabled/not enabled for value
compression in DB2 V8.2 ?. I think I can use db2look to generate the
DDL but I would prefer to use any system catalog table if available.

[2] Any method to estimate the space savings in value compression is
enabled in DB2 V8.2 ? ( I'm looking for a method similar to "inspect
rowcompestimate..." available in DB2 9)

Thanks,
Sam

On Aug 13, 11:46 am, Sam Durai <reachsamdu...@gmail.com> wrote:
> GM,
>
> I have couple of questions related to value compression feature in DB2
> V8.2
> [1] Any method to get the list of tables enabled/not enabled for value
> compression in DB2 V8.2 ?. I think I can use db2look to generate the
> DDL but I would prefer to use any system catalog table if available.
>
> [2] Any method to estimate the space savings in value compression is
> enabled in DB2 V8.2 ? ( I'm looking for a method similar to "inspect
> rowcompestimate..." available in DB2 9)
>
> Thanks,
> Sam

I think SYSCAT.TABLES.COMPRESSION column would fetch the answer for my
question [1]. But question [2] is still open.
Thanks.