Re: Logical log could not be freed !

In article <339D20E0.691@rad.net.id>, Pranadjaja <prana@rad.net.id> writes >Hello ... > > > >Does anyone know how to fix the following problem ? > > > >We have installed Informix Online Workgroup Server 7.2 on Sun Solaris > >2.5. We are building database application that can be accessed via Web > >using Netscape Live Wire Pro 1.0. > > > >At one time while developing application, we received database error > >stating that the logical log was full and needed back up. The problem > >happened after we had backed up all logical log using ontape utility. > >The status of logical log remained UB (Used and Backed up). It couldn't > >be changed to F (Free). After consulting the reference books, we knew > >that the only possible reason was long transaction (there was still bug No! From Online 7.10.UD1 logical logs are NEVER marked F (Free) they stay UB (Used and Backup) but are reused anyway as long a currently open transaction is not using the logical log. > >in our program or some operations that needed more log than space left > >in logical space). So, we restored the database using our level 0 > >archive ( we took our archive after we created the database structure; > >the archive contained the last logical log file). We did not roll > >forward our logical log. Later, the problem happened again. This time, > >we try to take the server to quiscent mode first with the hope that all > >transactions would be rolled back thus closing the transaction. The log > >remained UB after we took Informix online again. > > > >We then decided to start all over again. We installed the server using > >setup utility provided on CD-ROM distribution. After installation, we >tried to make a level 0 archive and then backed up all logical log. Even >when there were no databases created, the logical log still could not >be freed. > >Could someone explain why this happened ? Thank you for your help ! > > > > > >Pranadjaja >Radnet Staff >prana@rad.net.id -- David Williams