Re: upper limit on extents

On Aug 9, 12:03 pm, fl...@fwellers.com wrote: > Thanks. I think I found one that makes sense. To Zachi, I understand what you're talking about now. > Anyway, here's the script: Yes Floyd, and the 'max extents' is extents left plus num of extents. That value will be constant for all fragments of the table. The max extents is mostly determined by the number of 'special' columns in the table which is the same for all fragments, and the pagesize. Art S. Kagel > 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: vze2q...@verizon.net [mailto:vze2q...@verizon.net] > Sent: Thursday, August 9, 2007 11:44 AM > To: 'Zachi', fl...@fwellers.com, informix-l...@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: fl...@fwellers.com > >Date: 2007/08/09 Thu AM 09:49:07 CDT > >To: Zachi <zklop...@gmail.com>, informix-l...@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:zklop...@gmail.com] > >Sent: Thursday, August 9, 2007 10:33 AM > >To: informix-l...@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-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > >_______________________________________________ > >Informix-list mailing list > >Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list