Re: Extent Upper Limit - The Ultimate Query!

Posted in 2007

Davorin Kremenjas — Tue, 6 Mar 2007 13:40:53 +0100 — source: Usenet: comp.databases.informix

> "fandelau" <fandelau@gmail.com> wrote in message > news:1172799315.909244.139840@31g2000cwt.googlegroups.com... > All: > I've been searching in the Group and the web for a SQL query to the > SMI (sysmaster database) that gives me the extent information needed > to monitor and prevent reaching the extent upper limit by fragment/ > table/database. The following is a query that I have come up with > based on all that I have seen out there. It works in both 7.3x and > 9.30 and above (although I have not tested on 10). Please feel free to > improve it. I hope this helps. > Ram'n. Thanks. Tested on v10. Syntactically correct. Haven't checked the semantics though. :)