Re: Cannot back up logical log with ON-Archive

In article <01bceeb3$bccf2520$64c8c881@isis>, Terry O'Brien }>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). } Output of onstat shows up all logical log files I configured as not backuped. Furthermore, I found that ON-Archive catalog (arc_file) did not record anything about my logical backup. I suspected that ON-Archive catalog may contain machine-dependent informations, so transportation database from one machine to another make ON-Archive confuse. If anyone know about this information, please let me know. }>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