Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    3

    Unanswered: how calculate extent size table with tbcheck -pT

    Hello,

    I would like to know how to calculate extent size of a table starting from the order tbcheck - Pt database:table.
    Indeed I make already my table on a machine of test, and then I need extent size to put it in exploitation.

    table repor (
    rep1 serial,
    rep2 char(30),
    rep3 char(20),
    rep4 date)
    => size 58

    index idx1 on repor(rep1);
    index idx2 on repor(rep2);

    Number of rows = 500000

    Thank you very much.

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    It all depends on teh page size, the growth rate.
    Try to estimate the number of pages the table will grow.
    Set the extent size in that way that the table will not allocate every day a new extent. Play with it, monitor it. You probably don't need reorganizations.
    What version do you use?
    rws

  3. #3
    Join Date
    Feb 2003
    Posts
    3

    Wink

    Originally posted by Roelwe
    It all depends on teh page size, the growth rate.
    Try to estimate the number of pages the table will grow.
    Set the extent size in that way that the table will not allocate every day a new extent. Play with it, monitor it. You probably don't need reorganizations.
    What version do you use?

    Page size= 2048
    Growth : at the beginning 150000 and at the end of each month 500000 (when i do a reorganisation)
    In fact my table'size is 377 and the version of informix is 5.03.UC1
    Thanks

Posting Permissions

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