Re: Exporting Informix
On 7 Oct 1997, Bill Ennis wrote:
> I don't know of a utility that does what you want. You could
> script this by unloading all tables to unload files and
> dumping the schema with dbschema for the database.
One caveat to this approach... any data integrity is now shot. The reason
that dbexport locks tables is so that it can maintain point-in-time
accuracy. If this is not important to you, by all means do the table
unloads (and use DIRTY READ consistency to avoid locking problems).
If this is a really big deal, take a 0 level archive, restore it somewhere
else, and simply export from the other server. Sound drastic? If you're
implimenting a 24x7 solution (as opposed to a 23 1/2 X 7 solution) things
like this become mandatory.
-Richard