Backing Up INFORMIX-Online Databases

Path: emory!wupost!spool.mu.edu!munnari.oz.au!metro!dbsm!ralph From: ralph@dbsm.oz.au (Ralph Michael Gyoery) Newsgroups: comp.databases.informix Message-ID: <1991Nov25.045603.8960@dbsm.oz.au> Date: 25 Nov 91 04:56:03 GMT Reply-To: ralph@dbsm.oz.au (Ralph Michael Gyoery) Organization: SBC Dominguez Barry Ltd Informix : 4.00.UH1 Online Platform : SUN 4/490 SunOS 4.1.1 I would like to take a checkpoint / snapshot of individual databases residing on a common raw partition. The reading I have done so far let's me take an archive of the whole partition onto tape or to unload a database (using tbunload) to tape. The second option seems the closest thing to a checkpoint however it has a few shortcomings: -> has to go to tape -> doesn't save privileges or synonyms This is unacceptable, what I would like is to be able to do is: -> take a complete image of a database that can be used to replace the database, without having to rebuild it (indexing, privileges) -> the image / checkpoint can be saved to a file on disk -> the image dump can be done in batch mode (a command that can be run via a shellscript) -> is anyone is familiar with INGRES, my request is for a 'ckpdb' command. Could you please mail me your responses. Thankyou Ralph. Ralph Gyoery. SBC Dominguez Barry MHSnet : ralph@dbsm.oz.au INTERNET GATEWAY : ralph%dbsm.oz.au@munnari.oz.au -- Ralph Gyoery. Midland Montagu Australia Limited.