RE: Can't free logical logs

Hi Diane, Once I entered in a situation exactly like that and I was able to perform an emergencial logical log back-up using ondatartr utility (But my version is 7.x and I don't know if it exists in version 5). I was told that Informix Support has a utility to "bypass" the logical logs and resolve problems like that. If none of the above options resolve, you can always restore your last back-up. :-( Regards, Ivan ---------- From: Diane Houston[SMTP:diane.houston@bbc.co.uk] Sent: Terca-feira, 19 de Maio de 1998 14:41 To: informix-list@iiug.org Subject: Can't free logical logs I am running OnLine 5.01 UDS on HP-UX 9.04. I had a problem with all logical logs full due to long transaction. I was unable to resolve problem by methods from manual and unable take off-line so I rebooted the system. OnLine now stuck in Recovery mode although log shows: Tue May 19 17:43:17 1998 17:43:17 INFORMIX-OnLine Initialized -- Shared Memory Initialized 17:43:18 Physical Recovery Started 17:43:18 Checkpoint Completed 17:43:18 Physical Recovery Complete: 0 Pages Restored 17:43:18 Logical Log Files are Full -- Backup is Needed 17:43:19 Logical Log Files are Full -- Backup is Needed 17:43:20 Logical Log Files are Full -- Backup is Needed 17:43:21 Logical Log Files are Full -- Backup is Needed OnLine seems to think user dianeh still logged in USER INFORMATION Locks Disk Disk User PID User Held Reads Writes Status 383 root 0 6 2 ------D 0 root 0 0 0 ------D 0 dianeh 0 0 0 --T---- 595 root 0 0 0 ------M 571 root 0 0 0 ------M I have tried tbmode -c since status of log was U-B-L. Any other suggestions before I restore. Thanks in Advance Regards Diane Houston MedAS OASIS Application Support Villiers House, Room 135 Tel: 19575