DB2 V8.2 - Value compression question

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sam Durai
    #1

    DB2 V8.2 - Value compression question

    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

    Tags: None
    • Sam Durai
      #2
      Re: DB2 V8.2 - Value compression question

      On Aug 13, 11:46 am, Sam Durai <reachsamdu...@ gmail.comwrote:
      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.C OMPRESSION column would fetch the answer for my
      question [1]. But question [2] is still open.
      Thanks.

        Comment

        Previous template Next
        Working...