RE: Query to extract Initial & Next Extents

Posted in 1998

Leffler, Jonathan — Fri, 13 Feb 1998 08:53:45 -0800 — source: Informix-list mailing list archive (1991-1998)

Actually, the info is in 'informix'.SysTables in the actual database, not in the SysMaster database. Yours succinctly, Jonathan Leffler (jleffler@visa.com) #include <it.was.discussed.recently.h> ---------- From: Samuels David NTSE[SMTP:David.Samuels@nts.hl.siemens.de] Sent: Friday, February 13, 1998 5:43 AM I am currently writing queries for capacity planning and I need to be able to extract the initial and next extent values given to tables on creation. My problem is I cannot find the relevant fields in the sysmaster database, but I know it is there somewhere as oncheck -pt displays them.