Re: problem with changing logging mode

Velghe, Ronald wrote: > > I have a server with some dbspaces, often when I import a database , I do > it without logging and then I change the logging mode to unbuffered with > onarchive.That works fine. > > Recently I have created new dbspaces, and I have imported without logging > a database on them. But when I try to change the logging mode with > onarchive, it doesn't work, the archive (level 0) containing the new > dbspaces ends (completed) but the request to change mode is still > pending. > No need for onarchive to do this. Simply: ontape -s -L 0 -B mydatabase 0 = zero -B = Buffered Logging, other mode available check your docs. On NT, ondblog is also available to turn on/off logging, but I believe it still requires a Level-zero backup to turn logging on. Haven't used it in a while, so off the top of my head can't confirm. It doesn't require the backup to turn logging off. As I mentioned in another post about this, using dbimport without the logging is faster, and won't cause problems with large tables. One feature I'd like to see with dbimport/dbexport is the ability to load just a group of tables, or unload just a group of tables, and manage the constraints, etc. just like it does for a whole data base. This would allow me to unload sub-systems based on logical or physical models. Anyway, I hope this helps, Happy Holidays, Tim > I have checked that the database is created in the archived dbspaces. > Moreover, I created 2 databases ( 1 table, 1 field) without logging, the > first in a old dbspace, the second in a new one. I requested both to > change logging mode to unbuffered and I archived (level 0) both dbspaces, > the first database turned its logging mode, the second did not. There was > no error message. > > I can see the logging change for the first database in ONLINE.LOG , > nothing for the second one. > > I created the new dbspaces the same way than before: onspaces -c -d name > -o offset -s size -p dev > > I can't see any difference between these new dbspaces and the others. > > Before the creation of these new dbspaces, I change the configuration of > the server: I create a dbspace for the physical log and I put it in. I > set ONDBSPACEDOWN to 2. > > Thanks for all ideas. > > Ronald. -- Tim Schaefer \\\\|// tschaefe@mindspring.com 6 6 -------------------------------oOOo---( )---o00o---------------------- http://www.inxutil.com http://www.informix.com http://www.iiug.org news://comp.databases.informix mailto:majordomo@iiug.org no subject body: subscribe linux-informix ======================================================================