FW: table space ..
Posted in 2000
If I am not mistaken, you can use
oncheck -pt db:tablename | grep "pages used"
This will give you the pages used by the table. I think this includes all
the indexes too.
Someone else might comment on that.
For the full extent you will just grep for "pages allocated"
Dirk
Reach Technologies
-----Original Message-----
From: owner-informix-list@iiug.iiug.org
[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Sinha, Niraj
Sent: Friday, December 01, 2000 6:09 PM
To: 'informix-list@iiug.org'
Subject: table space ..
Folks,
What would be the easiest way to find out the empty space in a DBSPACE.
What I am looking for is , even if I have given a huge extent for a
table in a DBSPACE, that table might not be occupying the whole extent.
So, essentially, how do I calculate actual space the data space for the
table
Thx,
Niraj