Re: exporting/importing table from IDS 9.40

You would: dbaccess mydatabase - > unload to 'mytable_unload.unl' select * from mytable;> truncate table mytable; > load from 'mytable_unload.unl' insert in to mytable;> ^D > ^D The truncate will only work if you have a later version of Informix that supports that command (it's a VERY good idea to always post your version and platform information when you post). If not, you'll have to exit dbaccess, run a 'dbschema -d mydatabase -t mytable -ss mytable.sql' to get a schema of the table, drop it, recreate it with the schema, possibly recreate foreign keys on other tables that reference 'mytable', and then reload the data. (FYI - you can use my dbschema replacement utility, myschema, with its -F option that also outputs those referencing foreign keys - dbschema won't do it! Myschema is part of the package utils2_ak which you can download from the IIUG Software Repository or the Oninit WEB Site - www.oninit.com) or you can reload the file using dbload which may avoid long transaction and lock table overflow problems if the table is large. You may want to increase the table's NEXT SIZE to reduce future fragmentation. However, the best (and usually fastest) way to reorg a fragmented table is to use: ALTER FRAGMENT ON mytable INIT IN some_dbspace; The named dbspace can be the same one the table already lives in or a different one (or even a fragmentation expression). This command only needs sufficient logical log space to avoid a long transaction rollback and all indexes and constraints remain in place during and after the reorg. Have you checked that the table is badly fragmented first? Unless the table has several dozen fragments, it is unlikely that fragmentation is having a major performance impact. If you are having severe performance problems then it is more likely that your engine is not properly configured or tuned for your applications. I would recommend that you contact one of the several excellent consultancies that work with Informix users for a comprehensive server health check. I will shamelessly mention Oninit, the consultancy I work for, as one, but there are several others out there that a GOOGLE search for 'Informix consultant' will reveal. I only avoid naming them 'cause I'm getting old and if I forget one I'll insult some good friend or other. 8^) Art S. Kagel Oninit On Tue, May 20, 2008 at 3:38 PM, Gentian Hila <genti.tech@gmail.com> wrote: > I was told that to improve performance sometimes is a good idea to > export and import a table instead of sizing it (it's easier I've been > told) > > How do I export/import table in IDS 9.40? (table not database) > > Thanks > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >