RE: logical log cannot be freed

Hello Peter ! I don't think that "UB" means free. When Informix stoppped processing, we backed up all logical log files and then brought it online again. We could not run our applicaiton again. The status of logical log files remains "UB" not "F". Infomrix stopeed processing again. Pranadjaja On 12 Jun 1997, Peter Wang wrote: } The logical log status flag "UB" really means the log is backed up and free to reuse. From version 7.x, OnLine would not flag a log that is backed up to "Free" immediately, thus, allowing more time for recovery if it is needed. } _______________________________________________________________________________ } From: Rudy Fernandes on Wed, 11 Jun 1997 23:21 } Subject: Re: logical log cannot be freed } To: informix-list@rmy.emory.edu } } In article <339CF8D2.34DE@rad.net.id>, Pranadjaja <prana@rad.net.id> wrote: } }Hello ... } } } }Does anyone know how to fix the following problem ? } <snip> } } }We then decided to start all over again. We installed the server using } }setup utility provided on CD-ROM distribution. We decided to save all } }logical log on disk. When Informix server was on online mode, we tried } }to make an archive level 0 and back up all filled logical log file. Even } }when there is no databases created, the status of logical log files } }remained UB and UBCL. } } } }Could you please tell us why this happened ? Thank you for all your help } }!! } } } } } } } }Pranadjaja } } } Maybe you just need to increase the number of logs you have. Use } onmonitor to add logs (while quiescent), do a level 0 archive to } make them available, and try running your task again. } } How may logs? Make at least 10. This gives Informix enough leeway } to rollback most 'long transactions'. } } HTH. } } ---------------------------------------------- } Rudy Fernandes } Frying Pan to the Freezer : Kuwait to Toronto } ---------------------------------------------- } } ------------------ RFC822 Header Follows ------------------ } }Received: by yes.optus.com.au with SMTP;11 Jun 1997 23:21:42 U } }Received: from happy.optus.com.au (firewall-user@happy.optus.com.au }[203.13.126.9]) by proxy.optus.com.au (8.8.3/8.8.3) with ESMTP id XAA18958 }for <peter_wang@yes.optus.com.au>; Wed, 11 Jun 1997 23:17:01 +1100 } }Received: by happy.optus.com.au; id XAA24247; Wed, 11 Jun 1997 23:18:50 }+1000 (EST) } }Received: from rmy.rmy.emory.edu(170.140.97.4) by happy.optus.com.au via }smap (3.2) } } id xma024240; Wed, 11 Jun 97 23:18:32 +1000 } }Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id }GAA20500 for informix-list-out; Wed, 11 Jun 1997 06:45:01 -0400 (EDT) } }From: rferdy@kuwait.net (Rudy Fernandes) } }Message-Id: <5nlpda$pps$1@gulfa.kuwait.net> } }Subject: Re: logical log cannot be freed } }Date: Wed, 11 Jun 97 08:02:56 GMT } }Reply-To: rferdy@kuwait.net (Rudy Fernandes) } }Organization: RUVAL } }Sender: informix-list-owner@rmy.emory.edu } }To: informix-list@rmy.emory.edu } }X-Informix-List-Id: <news.39039> }