Re: upper limit on extents

If I'm understanding the admin guide, what you say doesn't make sense. Because basically the number of extra extents boils down to the frcnt output divided by 8 that is obtained by doing an oncheck -pP of different parts of the Physical Address. I quickly tried that forumula manually on 2 different tables and got two totally different numbers. -----Original Message----- From: Zachi [mailto:zklopman@gmail.com] Sent: Thursday, August 9, 2007 10:33 AM To: informix-list@iiug.org Subject: Re: upper limit on extents On Aug 9, 10:17 am, fl...@fwellers.com wrote: > Does anybody have a script that can determine the upper limit of extents as described in the Admin Guide ? > It's easy for me to do on a table level, but I get stumped when doing it on a fragment level. I would need to find the Physical Address on the fragment that contains the most number of extents, or possibly on each and every fragment in a table. > > Thanks. > > Floyd > > ======================== > email: fl...@fwellers.com > Home: 703-430-0805 > Cell: 703-477-6045 > ======================== > > www.one.orgwww.myspace.com/onepriority As all fragments have to use the same page size, they all have the same max number of extents. You only need to find one. Zachi _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list