Re: logical log cannot be freed

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 ----------------------------------------------