AGS Server Studio - Extent Calculator

Posted in 2013

Sean Baker — Tue, 14 May 2013 14:08:16 -0700 — source: Usenet: comp.databases.informix

IDS 11.50.FC6 running on Linux RHEL 5.3 We're in the process of moving our production databases (about 200GB) to new disk space, so I wanted to take the opportunity to recalculate the extent sizes for some of our larger tables. I'm planning on using the Extent Calculator in AGS Server Studio (version R.9) to determine the new extents. It takes row count, monthly growth %, index fill % and est. fill % for varchar columns into consideration to determine optimal extent sizes to accommodate 6 months of growth in the "next" size. Does anyone have any experience using this calculator? Were you happy with the results? Thanks, Sean.