Re: Extents

Posted in 1998

david.ashby@workcover.nsw.gov.au — Tue, 24 Feb 98 12:12:16 +1000 — source: Informix-list mailing list archive (1991-1998)

Thuc, Do an alter table of the next size on sysprocbody and probably sysprocedures. This will keep the extents to 2. I do not know if there is a way to change the initial allocation for system tables. Regards David ______________________________ Reply Separator _________________________________ Hi I have installed ODS 7.23 on HP 10.20 I have an ODS 7.23 on other HP10.20 with a database. I have noticed that a few sys tables have more than 80 extents like sysprobody has 87 extents. 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? Thanks thuc