Re: INFORMIX-RESTORE

David Williams wrote: > > In article <727uq8$nfu$1@news.xmission.com>, John Harman > <harmanj@agric.nsw.gov.au> writes > > > > > > > >On Mon, 9 Nov 1998, Javier Puente wrote: > > > >> Hi Informixers, I am looking for a tool for backup/restore of databases.= > > I have tried : ontape and dbexport but ontape don=B4t let me get a restore= > > of a database (i know using arcunload, but it is carefully doing that). On= > > the other hand dbexport requires an exclusive lock of all the databases to= > > backup them. > >>=20 > >> If somebody knows a third party tool or an Informix tools, please let me = > >know > >> thanks in advance for any comment > >>=20 > >> Javier Puente > >> Corporacion Noboa > >>=20 > >=09Onunload/onload is the standard utility for single databases. > > > > ontape, run Online 7.3 and keep each database in a separate dbspace. > Then you can restore each dbspace i.e. database separately. My ul.ec program unloads a single table into a binary file and can reload the table from the same file format. It currently handles all data types except BLOBs which I am working on now. It would be trivial to build a driver program (I use an awk script that reads dbschema/myschema output) to run ul for every table even in parallel. Ul.ec is part of my submission to the IIUG Software repository named utils2_ak. Art S. Kagel PS - If you want the awk scripts let me know.