Re: Pages used per table
Bruce,
Russ' answer is partially. If you want the index info too, then
run 'oncheck -pT <database>:<table>'
This will give you the info you require, the lowercase 't' option just
gives the tablespace info. Have fun,
Tracy
=========================================================================
= Tracy W. Nedd =
= Banctec Inc. - DBA =
= Silver Spring, Md =
= tracyn@asd.banctec.com =
=========================================================================
= ALL RIGHTS RESERVED. =
= This posting is copyright and may be used only for the purposes =
= of professional study. Use of this posting in any commercial =
= environment is explicity prohibited. This posting may only be =
= reproduced for personal archival purposes. =
=========================================================================
}
}
} >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. # || ||
} .#---'| |----.
} #----' -----
}
}