Re: Exporting Informix

Bill Ennis wrote: [SNIP] > 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. > } > } 2. Is there another utility that can export the database and > } schemas that does not lock the database? Perhaps in the > } onmonitor utility? I just have a set of awk scripts which read a dbschema output and create na SQL script of unload commands which I can then run from dbaccess. I can mail them to you if you want. Let me know via email. Art S. Kagel