Re: Query to extract Initial & Next Extents

In article <34E467D2.6D23@bellsouth.net>, John Carlson <carlson1@bellsouth.net> writes >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> I think that only applies to open tables. Instead of looking in sysmaster look in the applications database select * from systables There is a first and next extent sizes in there. > >John Carlson >Informix DBA >WH Smith, Inc. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care