Hi Gurus,

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

Thank you for you help.

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...

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.

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.