Re: Log with incomplete transaction. How to get around?

In a previous article, manmetha@gauss.rutgers.edu (Rajesh Malhotra) says: > I was in the midst of a long transaction, and somehow the process >got killed. Now when I bring up informix, it comes up in Recivery mode >and stays there. I keep getting messages in my Online.log that the logs are >full and a backup is needed. If I try to backup the logs, it just hangs there >with no activity on the tape drive. > > I cannot take informix into Quiescent mode. I can only take it >offline or in Recovery mode. The status of most of my logs is > U-B---- > >but one has > > U---C-- > >I dont care if I drop the log or loose the transaction. I tried dropping or >adding a log and get the message that Online must be in Quiescent mode. Is >there any workaround this? > I hope you have a service contract. You need the tbzero utility to clear out the log file(s) and this utility is only available from Informix Advanced Support (to the best of my understanding). Good luck. Dave Lutz INFORMIX DBA, Store Systems The Kroger Co. -- --------- Dave Lutz - awaiting witty insight for my .sig