Re: Next Extent Calc.

Hi! We have a utility from our application vendor which does this. It spits out all the tables which have over 8 extents (thus, requires defragging), the suggested next extent size and the current number of rows in the table at the time of the checking. Unfortunately, we received it as a binary executable (not sure if it's ESQL/C or 4GL C-Compiled), and I can't tinker with the code. I plan to write one in 4GL RDS that will do the same for all tables with more than 4 extents (or maybe make it configurable). When I do, I'll post it here or maybe someone could tell me who I should send it to for quality checking (maybe for eventual storage in the iiug or inx_util?). Right now, I'm completing a 4GL program to examine the fullness of index leaf nodes for all indexes in the database, and automatically drop and rebuild all indexes whose average free bytes are more than 60% of the page size. Will compile to 4GL C-Compiled when testing is complete. Let me know if anyone's interested! Thanks to all who responded on the Automatic Paging thread. I eventually worked out a plan with my paging company. At 10:01 AM 9/5/97 EDT, you wrote: } }Paul Mosser wrote: }> }> Mark, }> I think he's asking for a way to calculate what to set }> NEXT SIZE to in an ALTER TABLE stmt. At my former job, we }> obtained from an Informix consultant a little C routine called }> "ext_size". Based on user-specified growth factor(s), it would }> spit out all sorts of good stuff, including recommended NEXT SIZE. } }Okay, that's useful, but it still relies on the "... user-specified }growth factor..." as you say. That is the calculation not even the }client can normally give you. :-) } }> We were using this on OnLine v5.xx. Is the routine still around }> somewhere? Has it been updated for v7.xx? } }I haven't seen it. It should still apply to version 7.x. The BaaN Fast }Start package comes with a script (if you buy the package) which does }this job AFTER the event, i.e. de-frags your table. } }Cheers, }-- }Mark. } }+----------------------------------------------------------+-----------+ }|Mark D. Stock - Informix SA http://www.informix.com |//////// /| }|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| }| +-----------------------------------+//// / ///| }| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| }| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| }|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| }+----------------------+-----------------------------------+-----------+ } Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+