Re: Export/Import Database - Help??

In article <392a42$jhv@arcadia.informatik.uni-muenchen.de> spitz@ana.med.uni-muenchen.de writes: >Bill Ennis (ennis@ssd.comm.mot.com) wrote: >: Warning: If you are using Online you will lose the dbspace/extent >: information ;( However, it does fit all tables into one extent ;)). > >How can Online fit all tables into one extent? AFAIK, dbimport >uses the default extent size of 16k, so large tables will get >split into many little pieces, and performance will degrade serious- >ly if the number of extents exceeds 8 for a table. > Since the tables are loaded in a singlethreaded operation, even though the pages are built 16k (actually, for me, 32k) at a time, they remain a single extent, since they are contiguous. And since the table is first loaded and then, again in singlethreaded operations, the indexes are built, the data and indexes are all contiguous. I don't know when this happened, I dont remember hearing of it and seeing it when I first tested 2 years ago, but at the moment dbimport seems to determine the total pages used for a table, divide by 10, and do an alter table next with this figure. This means all you have left to do is create an sql that does an alter table lock mode (row) for each table. But if the question is 'how can informix put all tables in 1 extent' the answer is it cant, each table needs its own :-)