Re: Change from Buffered log to no log locks databases

Melvin Mariney wrote: > > TASHKOP@kiwi.co.nz (Peter Tashkoff) wrote: > > >Informix ver 710.UC1 > >Solaris 2.4 > >Sparc 1000 > > >We have a number of test databases which we use to test cobol apps > >which data resides/will reside in informix. 16 in fact. > > >These were erroneously set up with buffered logging. Cobol requires no > >logging. > > >This morning I ran: > >ontape -s -N ..a list of 16 database names..> > >Change from buffered to no logging should have been immediate. > >Instead they are all locked error 178 pending changes to logging status. I > >think 16 was too many. > >Has anyone had this problem and know what to do. > > >thanks in advance > System: SunSPARC 5 with Solaris 2.4 and Informix 7.11 I experieced the same problem when I tried changing from no logging to buffered logging with a user active in the database. I performed a series of ontape commands to activate and deactivate the logging but nothing helped. The backups were sent to a DAT-device and went alright but I could never access the database. It was waiting to change logging status. In the end I had to reinitialize the system. Luckiely enough it was only a small developement system. -- -- Orjan Lindberg Naturv'rdsverket (Swedish Environmental Protection Agency) Blekholmsterrassen 36 S-106 48 Stockholm Sweden Tel: +46 8 698 1282 Fax: +46 8 698 1584 orjan.lindberg@environ.se