Re: Next Extent Sizes

Posted in 1999

Yuri Dovgart — Wed, 16 Jun 1999 15:54:16 GMT — source: Informix-list mailing list archive (1991-1998)

In article <7k8h44$nqi$1@nnrp1.deja.com>, Yuri Dovgart <y_dovgart@tci.ukrtel.net> wrote: > In article <7k8blf$4fr$1@news.xmission.com>, > Phil Allen <phil.allen@uk.hboc.com> wrote: > > > > Hi all, > > Excellent list, keep it up. > > > > How can I find out what the next extent size is for any given table? > > > > Thanks. > > > > Phil. > > > > > > So much ways... Try this query : > > select nextsize from systables where tabname='tabname'. Output inpages. Ooops! I'm sorry. Output in Kbytes. > > -- > With best regards, Yuri Dovgart, > SAP R/3, Informix consultant, > "Telecominvest" company. > E-mail y_dovgart@tci.ukrtel.net > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.