When table extent was added

Posted in 2004

Topics: Storage & Space Management, Versions, Editions & End-of-Life

Dirk Moolman — Mon, 8 Nov 2004 13:07:37 +0200 — source: Usenet: comp.databases.informix

Is it possible to see from the system tables when a table extent was added ? I have a couple of tables with large extents, and want to be able to see when the extents were added to them. IDS 7.31 FD3 Solaris 9 Dirk Moolman Database and Unix Administrator MXGROUP "People demand freedom of speech as a compensation for the freedom of thought which they seldom use." -Kierkegaard sending to informix-list

↪ replying to Dirk Moolman

rkusenet — Mon, 8 Nov 2004 09:10:42 -0500 — source: Usenet: comp.databases.informix

"Dirk Moolman" <DirkM@mxgroup.co.za> wrote in message news:1099919444.a8uFITUrA7W+qiViP5/gWQ@teranews... > > Is it possible to see from the system tables when a table extent was > added ? > > I have a couple of tables with large extents, and want to be able to see > when the extents were added to them. > > > IDS 7.31 FD3 > Solaris 9 I am looking for this for a long time. A history of when an extent was added to the table helps immensely in capacity planning and the rate of growth of a table. However it seems Informix does not maintain any history of extent allocation of a table. So the only recourse I have is to take an automated table extent snapshot every week and then manually compare the result to check when an extent got allocated. Needless to say the result is only an approximation to the nearest week.