Re: Query to extract Initial & Next Extents

Posted in 1998

John Carlson — Fri, 13 Feb 1998 15:36:19 GMT — source: Informix-list mailing list archive (1991-1998)

Samuels David NTSE wrote: > > 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. > > Cheer > > Dave Samuels DBA > Siemens Microelectronics Ltd This might be of some help: dbaccess sysmaster select prof.dbsname, prof.tabname, prof.partnum, hdr.nextns, hdr.fextsiz, hdr.nextsiz from sysptprof prof, sysptnhdr hdr where prof.partnum = hdr.partnum order by 1, 2 John Carlson Informix DBA WH Smith, Inc.