Re: Backup and Restore Help!!!

Neal Leitner wrote: > > I have a problem, which I thought was a simple one to fix, but after > consulting with Informix, there is no current Informix utility to solve > my problem. > > My problem is: I want to backup my On-Line database each night to tape > and be able to selectively restore tables if needed. Ontape does a good > job of backing up the whole database and restoring individual database > spaces, but I don't want to have to restore the entire space, just a > table or two within that space. > > I thought about a dbexport, but my users complained each night when I > kicked them off the system since dbexport requires exclusive access to > each of the tables. > > Does anyone have any ideas or experience with my problem. > > All help is appreciated!! > > Neal Leitner > WFS Services, Inc. You don't say which version of OnLine you have, but v7.xx has utilities, onarchive or onbar, that allow restore of dbspacesets. By judicious placement of your tables you could restore a set of tables without affecting others. Could you onunload your database, then reload it elsewhere, THEN export the tables you want? A bit long-winded, I know. Neil Truby Chase Manhattan Bank Bournemouth, UK