Re: unloading a dbspace

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