Re: Exporting Informix

On 7 Oct 97 at 12:20, Nick Oehler wrote: > Does anyone know of a good way to export an Informix database > version 6.01. I'm aware of the dbexport utility which works very > well, but it lock the entire database. I understand why the database > should be locked, but it does and/or couuld cause some problems. So, > two questions: > > 1. Can dbexport be run in such a way that is does not lock the > entire database? Perhaps only locking the current table. You could cause worse and more subtle problems by *not* locking the database. Here's an example: you have tableB referring to tableA. While you're unloading tableC, you add new records to A and B. But because you can't really control the order of the unload, tableA has already been unloaded, and tableB hasn't. Now what? > 2. Is there another utility that can export the database and > schemas that does not lock the database? Perhaps in the > onmonitor utility? You could manually use the UNLOAD command in dbaccess, but be aware of the above problem.... -- Ciao, Billy Nose to the ear in Johannesburg -- Murder City never looked so good! Get FAQ'ed at http://www.iiug.org/techinfo/faq/faq_top.html PISCES Feb. 19 - Mar. 20 You have a vivid imagination and often think you are being followed by the FBI or CIA. You have minor influence over your friends and people resent you for flaunting your power. You lack confidence and are generally a coward. Pisces people screw small animals and pick their noses.