Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
On Mon, 12 Oct 1998, Subhash wrote:
> I am using Informix Universal Server 9.14UC2 on Solaris 2.5.1. I have a database
> which has tables spread across 9 dbspaces and two of them are smart blob
> spaces.
>
> What I would like to do is to unload each dbspace, copy the file to another
> instance of online to restore into a dbspace which is setup with the same name
> and size.
>
> I cannot use ontape to restore the database because the chunk names are not the
> same and there is alreay a another instance of Online setup which has the same
> chunk names. Also I tried to dbexport the database but some the tables have
> corrupt data and the export crashes about half way through.
>
> Does anyone know which informix utility I can utilise to do this ?
> thanks in advance for any help.
Get my ul.ec program from the IIUG Software Repository in the file
utils2_ak. It unloads a table in binary format and can reload the file as
well. It was written for IDS 7.xx including BLOBS but you could easily
extent it to handle SBLOBS and improve error recovery to do something
intelligent and useful about the corrupted records.
Art S. Kagel, kagel@bloomberg.net
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.