Re: Logical Logs full, can not be freed!!! Need Help, Urgent!!!

Er...could you check the LTAPEDEV parameter in tbconfig ? Try /dev/null if not. Cheers Valery Shen Xiaohui <sxh@project-hope.cydf.edu.cn> wrote in article <333C5ABB.37C4@project-hope.cydf.edu.cn>... > Dear Sir, > > Our Informix Online 5.0 server's logical logs got full abnormally and frequently, > the whole system was then stopped and we can do nothing to continue but restore > the whole system and data from Level 0 tape!!! At first, we suspected the > "inadequate" logical logs. But, when we add logical logs from 20 to 60, the > situation was the same. We then adjusted Long Transaction high-water mark for 80% > to 40% and Long Transaction exclusive high-water mark from 90% to 45%, but we can > not solve the problem. From Administrator's Guide, we know that a logical log can > be freed only when 1) it has been backed up; 2) All records within the log file > are associated with closed transactions; 3) The log file does not contain the > most recent checkpoint record. We suspected the existence of Long Transaction > which was not closed. But how can we deal with them? Are there any ways that we > can force the logs cleared? > > Any of your suggestions will be greatly appreciated! Also, please tell me the > email or fax number of Informix headquarters or technique supporter in the US > that I can contact. > > Thanks in advance > > Xiaohui Shen > email: autodept@public2.bta.net.cn >