Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184

    Unanswered: Size of table when BLOB colums exist

    How do we calculate the table size when LOB/LONG columns exist in the table?

    Without LOB/LONG, we can use TSIZE of 'reorgchk' output. However, this does not hold good if the table has LOB/LONG columns.

    TIA.

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi,

    You need not consider LOB and LONG data size while sizing the tables. Table data pages do not contain the data for columns defined with LONG VARCHAR, LONG VARGRAPHIC, BLOB, CLOB, or DBCLOB data types. The rows in a table data page do, however, contain a descriptor for these columns which i guess takes 16 bytes of space. So while calculating row size add 16 bytes for such columns.

    But remember to consider disk space for such columns as they are stored on disk anyway.
    Prashant

  3. #3
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Quote Originally Posted by dahalkar_p
    Hi,

    You need not consider LOB and LONG data size while sizing the tables. Table data pages do not contain the data for columns defined with LONG VARCHAR, LONG VARGRAPHIC, BLOB, CLOB, or DBCLOB data types. The rows in a table data page do, however, contain a descriptor for these columns which i guess takes 16 bytes of space. So while calculating row size add 16 bytes for such columns.

    But remember to consider disk space for such columns as they are stored on disk anyway.

    Thanks for the input. I need to know the table size for 'BLOB column tables' also as I'm working on 'growth trend' - capacity planning - of the database over a period of few months.

    When TSIZE is considered, the size of the database is 15 GB. However, the full backup image of the database is 200 GB.

    TIA.

  4. #4
    Join Date
    Sep 2005
    Posts
    9
    Any solution to this issue? I'm looking for the same thing.

  5. #5
    Join Date
    Aug 2002
    Location
    Chennai, India
    Posts
    184
    Check out the following URL:

    https://www-128.ibm.com/developerwor...m=291#13777316

    HTH.

Posting Permissions

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