Results 1 to 10 of 10
  1. #1
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Smile Unanswered: Compression table

    Hi All,

    I have done row and value compression for a table and uncompress for an another table.
    But , compression table is not compressed and both tables are showing same table size.

    Can you understand what am asking?

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Always post your DB2-version and Fixpack and Operating-system name for each new thread.

    What DDL did you use for the compressed table?

    What is the size of data in the table (to be compressed)?

    What query are you running to prove whether or not compression happened?

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    have a look at
    Row compression
    and this chapter "Turning row compression on or off"
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Table size

    Hi,

    This is two table one is compressed and another is uncompressed.TABNAME CARD NPAGES FPAGES COMPRESSION
    T21 48960 171 171 N
    T12 48960 171 172 B

    ddl structure for both table :
    Data type Column
    Column name schema Data type name Length Scale Nulls
    ------------------------------- --------- ------------------- ---------- ----- ------
    C1 SYSIBM SMALLINT 2 0 Yes
    RESUME SYSIBM CLOB 1048576 0 Yes


    Details :windows server 2003----Db2 Express C 9.7

  5. #5
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Is row-compression available with Express-C ?
    Study this:
    Compare the distributed DB2 9.7 database servers

  6. #6
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    from my experience Express-C has all the features as the enterprise edition. Your just not allowed to use them. ( During a License-Audit it's going to be expensive, because IBM want's to see the "db2licm -g" Reports).

    Regarding OP issue: Only Inline-LOBs can be compressed. If your CLOBs ar not inlined there would only be the SMALLINT to be compressed. And there won't be a good compression-ratio!
    Row compression - IBM DB2 9.7 for Linux, UNIX, and Windows -> "What data gets compressed?"

  7. #7
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45
    Hi,

    So, Is it compress or not in Exprees C.

  8. #8
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    sowndharya, check out this link to the Information Center for
    DB2 features and functions by edition - IBM DB2 9.7 for Linux, UNIX, and Windows

    According to this, row level compression isn't even available in the Enterprise Server Edition unless you also buy the DB2 Storage Optimization Feature.

  9. #9
    Join Date
    May 2012
    Location
    Chennai
    Posts
    45

    Smile Compression

    Hi,

    Thanks, compression is not support for Express-C

  10. #10
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Stealth_DBA View Post
    sowndharya, check out this link to the Information Center for
    DB2 features and functions by edition - IBM DB2 9.7 for Linux, UNIX, and Windows

    According to this, row level compression isn't even available in the Enterprise Server Edition unless you also buy the DB2 Storage Optimization Feature.
    You have to be careful because sometimes they allow it, but throw a license warning error in db2diag.log, so when you get audited by IBM you will have pay up. Those new Oracle compatibility features in DB2 also seem to include Oracle marketing tactics.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •