Online Problem

%UNIPLEX %TO informix-list@rmy.emory.edu %FROM wilson %SYSTEM DHLNET %SUBJECT Online Problem %VERIFY y %REGISTERED y %DATE 23/02/95 16:50 %REFERENCE 82494 Dear Informix users! Is there any ONLINE tools readily available to change the status of logical log files ? I had a problem yesterday. There was a long transaction and all the logical logs became full. Unfortunately at this stage the ONLINE was also aborted abnormally due to some reason. When I tried to bring the database it went into recovery mode ( indefinitely ). This process was going on and on. I tried to take a backup of the logical log files and this even could not free the logical logs. The flags in the logical logs were like U-B--- and on the last log it said U--C-L. I had no other option other than restoring from the backup and there was a lot of data loss. FYI We have ONLINE 4.10 Probabaly some one out there in the NET would have faced the same problem. If so what is the correct way to proceed ? Also if some one has any utility to change the status of logical log files, I am very much interested to get it. Thanks in advance for your help. Regards Wilson E-mail : wilson@bah-ro.dhl.com DHL INTERNATIONAL Fax : 0973-323301 PO BOX 5741 MANAMA BAHRAIN %UEND