Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1

    Wink Unanswered: Space Usage in table informix

    Hi Gurus,

    I need know what is the currently space usage for a table in database.

    Thank you for you help.

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    You can choose between 2 ways:

    1) onstat -T , find the partnum of your table and get how much pages are used and multiply by page size...
    2) select * from systables where tabname = "xyz" ; get the column "npused" and multiply by page size too...
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Dec 2002
    Location
    Madrid - Spain
    Posts
    422
    Provided Answers: 1
    Thank you for you help.

    I have this doubt, the partnum for this table is 400368, I execute this command
    onstat -T |grep 400368

    and the output is this.
    1172 92cc54fc 2 0 400368 40:1603714 5242876 19478 19475 19475 1

    the column nused is 19478 this value is multiplicate for 4 (I HAVE AIX 5.2) then this value I to divide by 1024 for to convert to MB.

    If I execute unload for this table and then execute du -m file unloaded and the output is

    9.53 MB.

    I do not understand this outputs.

  4. #4
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    Take a look on this site:
    http://www.oninit.com/onstat/index.p...atidx.php&id=t

    It explains each columns of the command.

    Your output appear strange.
    You have 20GB of space allocated to table, but only 70kb of data...
    This remember me one thing, maybe you need run a update statistics low on the table to refresh this informations.
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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