Re: Cannot back up logical log with ON-Archive

In article <01bceeb3$bccf2520$64c8c881@isis>, Terry O'Brien <terry@eckhart.demon.co.uk> writes >the answer may be that the logs are freed, but the way informix 7 registers >the status does not appear as if they are freed, if you are used to >Informix 5. Essentially, they have changed the rules between 5 & 7, but I >am not sure why. > This was changed in a 7.1x Online release (7.10.UC1?/7.10.UD1?). In onstat (or tbstat) the logical logs do not show up are freeded. But as long as they are Used,Backed Up and no not contain an open transaction they will be reused. The reason was a) performance reasons b) so that more of the logical logs on disk can be examined by onlog. (Helps the customer and Informix Technical Support to examine past transactions). >Khemchart Rungchavalnont <khemchart_r@ucom.co.th> wrote in article ><648v38$rf3@cssun.mathcs.emory.edu>... >> Hello All, >> >> I have transported my database from old system to new system using >ontape. Both systems are >> SUN E3000 and running Informix 7.20. After transportation completed, I >cannot back up logical log >> on the new system using ON-Archive (but ontape works fine). Both output >produced by ON-Archive >> and messages in "archive.log" said that operation is successful, but all >logical logs are not freed. >> Did anyone can explain me what happen to ON-Archive and how to correct >it? >> >> Regards, >> Khemchart Rungchavalnont >> >> My email address: khemchart_r@ucom.co.th >> >> -- David Williams