Re: Erratas and questions.

Posted in 1998

Art S. Kagel — Wed, 14 Oct 1998 17:38:39 -0400 — source: Informix-list mailing list archive (1991-1998)

On Tue, 13 Oct 1998, Luis A. Fuente Sim'n wrote: > Hi all. > > I am a sysadmin, not a DBA, an looking at the Joe Lumbley's > "Survival Guide" (Informix Press), I've found to apparent > contradictions. > > 1.- About default number of pages per extent: is it 4 pages/ext. > or 8 pages/ext? (maybe the default is 16 KB/extent and then, > depending on page size of 2 KB or 4 KB, the number of > pages/extent varies?) The default is 8pages or 16K for EXTENT SIZE and NEXT SIZE. > 2.- It says tables can be allocated some initial size with > the "CREATE TABLE" statement. But some times he refers to > the "FIRST SIZE" and "NEXT SIZE" options, other times to > "EXTENT SIZE" and "NEXT SIZE". EXTENT SIZE nnn NEXT SIZE mmm This will be corrected in Joe's second addition I'm sure. Art S. Kagel, kagel@bloomberg.net