Pages used per table
>yes there is an easy answer.
run oncheck -pt <datbase>:<table>
this will show you complete table space info.
Russ....
From ellis.oncontact.com!rmy.emory.edu!informix-list-owner Mon Dec 18 10:25:44 1995
> Date: Mon, 18 Dec 1995 10:43:47 -0500
> From: Bruce Cota <cota@dpg.rnb.com>
> Message-Id: <9512181543.AA28826@dpg.rnb.com>
> To: informix-list@rmy.emory.edu
> Subject: Pages used per table
> Sender: informix-list-owner@rmy.emory.edu
> Reply-To: Bruce Cota <cota@dpg.rnb.com>
> X-Informix-List-To: russell@oncontact.com
> X-Informix-List-Id: <list.8246>
>
>
> Hi, I think (hope) this has a simple answer ...
>
> With Online-7.1, what is the easiest way to find the number of pages
> allocated to *each* of our tablespaces, *including* pages allocated to
> indexes. We are about to reload all our tables and we're trying to
> determine the appropriate extent sizes...
>
>
> Thanks in advance,
> -Bruce
Russell P. Kahler |||||/// ----------
Internet: russell@oncontact.com ======== / Uh...
on!contact Software . | O O | /Just reboot
W67 N250A Evergreen Blvd | v_' / --> that will /
Cedarburg, WI 53012 # _| |_ fix it /
(414) 375-6555 (#) ( ) ----------
# //|* *|
#//( * )/
# =====
# ( )
Blah, Blah, Blah. # || ||
.#---'| |----.
#----' -----