Re: first extent and next extent

jjdai@pek-co.cn.dhl.com wrote: > Hi, > I want to know that is there a system table include > first and next extent size information ? > and how can i keep the origin extent size during > dbexport and dbimport easily ? > and how can i change the first extent size after > dbimport (for i know change next extent size by alter > table statement)? Hi, yes there is a system table including first and next extent size information :-) (The table you look for is called systables - look for the columns fextsize and nextsize) You can keep extentsizes in dbexport using the -ss parameter (server-specific?). You can't change first extent size after creating the table (i.e. after dbimport). There are however several scripts to calculate proper extent sizes. Read the FAQ at http://www.garpac.com/informix Peter ______________________ Mag. Peter Kolmhofer DBA Porsche Informatik (Austria) eMail: kop@porsche.co.at