Number of extents per fragmets

Hi, I'm trying to make a query to get the number of extents per fragment. I know that i can get it with oncheck -pt, but i need to get the same with a query. I'm trying in the sysextents table, but just get the tabname, so i can see the number of extents per table, but i want per fragment. Any idea? ------------------------------ Rubén García Muro ------------------------------ #Informix

Ruben: Using the partnums for the fragments (from sysfragments in the database, query the sysptnhdr table sysmaster: > select nextns from sysptnhdr where partnum in (5242935,5242936,5244144,5244145,5244146);nextns 1 1 1 1 1 Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

Thank you so much Mr Kagel. That's exactly what i were looking for. Kind regards. ------------------------------ Rubén García Muro ------------------------------