Re: Extents

Posted in 1998

Bill Ennis — Tue, 24 Feb 1998 10:47:50 CST — source: Informix-list mailing list archive (1991-1998)

I have seen obsene amounts of extents for the systables. Is there a substantail penalty for this. I contacted tech support and was told not to worry about it. Any comments otherwise? -Bill > > > Thuc Nguyen wrote in message <6csn4o$dbl$1@news.xmission.com>... > > > >Hi > ><chomp>. > > > >Since I have recently installed new Informix 7.23 on another HP 10.20, how > can I increase extent size in sysprobody before we create new empty > database? > > > > > You have to adjust the next extent size. The best time to do this is > immediately after you create a database but before installing any tables. > systables, syscolumns, sysprocbody are all candidates. You cannot alter the > initial extent sizes of sys-tables > > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com