RE: continuous logging
Posted in 1998
---------- From: ANTS[SMTP:sui@naseej.com] Sent: Tuesday, March 17, 1998 10:36 AM To: informix-list@iiug.org Subject: continuous logging Hi, I'm using Informix online 5 under AIX 3.25. 1. I have read the informix guide about continuous archive for logical logs and automatic one. I can't see the difference, cause for automatic once a log is filled it will put it to the tape, so as the continuous!! Did I miss anything? JL: Yes. The automatic backup stops when all the currently full logs are backed up. Continuous backup waits for more logs to fill up. 2. The Informix guide and Informix support told me that continuous logging cannot be done unless you dedicate a terminal for it. However, I tried the following and it worked. nohup tbtape -c & JL: Bully for you. How did you know when to change the tape? And how did you tell tbtape to continue after changing the tape? Yes, you had to drag it back into the foreground, somehow. 3. If someone is taking level 0 archive on daily basis, why archiving the logical logs is need? (Other than releasing the log files). I mean do I have to keep the logical log archives, if I have the next day level-0 archive or even level-1, 2...?? JL: So that you can recover the database changes between the time the level 0 archive starts and the time the system crashes on the day when it crashes. If you don't have those logical logs backed up, you lose the transactions. Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h>