Re: Re: upper limit on extents

Thanks. I think I found one that makes sense. To Zachi, I understand what you're talking about now. Anyway, here's the script: select {+ ordered, index(a, syspaghdridx) } -- necessary c.dbsname, -- the database c.tabname, -- the table or index b.name, -- the dbspace c.partnum, -- necesary to get the count and sum right trunc(a.pg_frcnt / 8) frext, -- extents left in the fragment count(*) num_of_extents, -- num of extents allocated in this fragment sum( pe_size ) total_size -- total size of the extents in the fragment from sysmaster:sysdbspaces b, sysmaster:syspaghdr a, sysmaster:systabnames c, sysmaster:sysptnext d where a.pg_partnum = sysmaster:partaddr(b.dbsnum, 1) and sysmaster:bitval(a.pg_flags, 2) = 1 and a.pg_nslots = 5 and c.partnum = sysmaster:partaddr(b.dbsnum, a.pg_pagenum) and c.partnum = d.pe_partnum and c.dbsname = "sentryprod" -- use these 2 in case you want to --and c.tabname = "stsubhst" -- filter them, but would not recommend group by 1,2,3,4,5 order by 4 -----Original Message----- From: vze2qjg5@verizon.net [mailto:vze2qjg5@verizon.net] Sent: Thursday, August 9, 2007 11:44 AM To: 'Zachi', floyd@fwellers.com, informix-list@iiug.org Subject: Re: Re: upper limit on extents I assume we are talking about the max number of extents for a table? It will vary according to how "complicated" the table definition is - as that definition eats up space in the table header. I posted a script to the group a year or so ago that figured it out what tables were in danger of running out. I think others posted their scripts as well. Try googling c.d.i. for 'Max extents'. j. >From: floyd@fwellers.com >Date: 2007/08/09 Thu AM 09:49:07 CDT >To: Zachi <zklopman@gmail.com>, informix-list@iiug.org >Subject: 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 > > >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list