Re: Adjust the extent number

Yes, a default dbexport/dbimport will readjust all tables to have one extent. Specifically, not providing an extent size in the table creation script is what does this. Having verison 7.12 you have the option of using the -ss option of dbexport which preserves server specific information such as extent sizes, lock mode, and dbspace. Using -ss option is probably the safest way to go. However, you may want to edit the .sql file generated to remove (or modify) the extent sizes cince you want them to be different. If you want to remove them you can do so manually, or write a script if you have lots of tables. No, you will not destroy the whole engine with dbexport/dbimport. In fact you will need to explicitly drop (or rename) the database so that you can even run the dbimport. Do you have problems with extents on all tables? If not you may want to consider concentrating on the problem tables. If you provide more information I can give better suggestions. -Bill > > Hello : > > I'd like to know how to adjust the extent number of database, > sysmaster. Can I use commands 'dbexport' and 'dbimport' ? > If I drop the database and import it, will I 'destroy' the > whole engine. I am using the Informix 7.12 ONLINE. Thanks for > any comments..... > > Jung-Hui Cheng > cheng@dbtel.com.tw > DBTEL > -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net