Re: How does the Informix Online 7.23 backup process work?

dengelsen@my-dejanews.com wrote in message <6uq2q3$fic$1@nnrp1.dejanews.com>... >Hello, > >I don't have a lot of experience with Informix jet. Can someone explaine how >the backup process in Informix is Working? > >How can we free up the space for logical logs? Wat is a good, safe procedure >for backing up llogs and data? (and what if we use ontape -c) You should try to use ontape -c. It runs as a daemon and cuts in as required to back up full logs. ontape -a ("automatic") is something of a misnomer. It's difficult to think of any ways in which it might be described as "automatic". It's just a one-off dump of all logs that full and available to be backed up, and must be invoked manually. It follows that ontape -a overwrites the destination tape every time it is invoked. > Why is it >important that llog's are not full when creating a backup of the data with >ontape -s?It's always important to ensure that your logical logs are full. When the logical logs are full, the database engine will allow no further update activity on the database server until the situation is resolved. In the case of an archive, no system tables can be updated by the archive process. Were you given any Informix manuals with your installation? As manuals go, they really are very good. Neil Truby Londis Holdings London, UK