RE: current next extent size

select tabname, fextsize, nextsize from systables;. Unless an alterstatement has been run these values will be unchanged from the originals. They are not affected by additions to the tables size. The question is what SHOULD they be given the output of oncheck -pe or (in the case of XPS, onutil ->check space display;) cheers j. > -----Original Message----- > From: M. Kvching [mailto:koeching@landwirtschaftsverlag.com] > Sent: Wednesday, December 13, 2000 5:12 AM > To: informix-list@iiug.org > Subject: current next extent size > > > Hi, > > how to query the sysmaster-db to get the current > next_extent_size for all > tables. I have to compare this values with the original ones. > Is there a way with a sql-statement? > > Thanks for advices. > > Matthias > > Informix Version 7.24 > >