Re: unlogged database

good thing you guys are around. I would've made a real disaster. I did as robert said. It went smooth with /dev/null as tapedev... a slick buffered log database is the result. thanks. On Wed, 17 Feb 1999, RG wrote: > Don't do it!!!!!!!!!!!!!!!!!!!!!!!!!!! This will overwrite or "initialize" > your database instance. You will lose all data! You can easily change the > tape device to /dev/null in your onconfig file and then simply bounce your > engine (onmode -k followed by an oninit). I'm not sure if this is what you > really want to do anyway since you are just trying to turn on logging. To > change the logging status of a database you must do a level 0 archive: > > ontape -s -B dbname> > To turn logging off: > > ontape -s -U dbname > -- > Regards,> Robert > > Roberto Dircio Palacios-Macedo <is092756@cca.pue.udlap.mx> wrote in article > <7afda1$6lb$1@news.xmission.com>... > > > > > > ok, i tried it from the OS prompt.. it kept looking for the tape > > physically. So i decided to change it in onmonitor. At the > > "parameters/initialize" menu, settings appear like this... > > > > > > INITIALIZATION: Make desired changes and press ESC to record changes. > > Press Interrupt to abort changes. Press F2 or CTRL-F for field-level > help. > > DISK PARAMETERS > > Page Size [ 2] Kbytes Mirror > > [N] > > > > Tape Dev. [/dev/rmt/0n ] > > Block Size [ 16] Kbytes Total Tape Size [ 10240] > > Kbytes > > Log Tape Dev. [/dev/null ] > > Block Size [ 16] Kbytes Total Tape Size [ 10240] > > Kbytes > > Stage Blob [ ] > > > > Root Name [rootdbs ] Root Size [ 100000] > > Kbytes > > Primary Path [/export/home/sw/informix/etc/online_root ] > > Root Offset [ 0] > > Kbytes > > Mirror Path [ ] > > Mirror Offset [ 0] > > Kbytes > > Phy. Log Size [ 1000] Kbytes Log. Log Size [ 1500] > > Kbytes > > Number of Logical Logs [ 6] > > > > but changing the tapedev to /dev/null gives this scary warning: > > > > continue (y/n) > > This step will overwrite your existing primary/mirror cooked ROOT > DBspace. > > > > shall i continue? > > > > thanks. =O > > > > On Wed, 17 Feb 1999, Steve Romankiw wrote: > > > > > You can do the following: > > > > > > set TAPEDEV = /dev/null > > > > > > ontape -s -L 0 -U <dblist> # Creates an unbuffered log database > > > ontape -s -L 0 -A <dblist> # Creates an ansi logging database> > > > > > Steve Romankiw > > > > > > Roberto Dircio Palacios-Macedo wrote: > > > > > > > i have a big database, unfortunately it isn't logged, so I want it to > be > > > > on log mode ansi, how to?. I'm thinking about re-cerating it. =( > > > > > > > > thanx > > > > > > > > ____roberto dircio palacios macedo__________________________________ > > > > __ | | > > > > /\\_\\__ | Interactive and | http://ict.udlap.mx/people/roberto > > > > \\/_/\\_\\ | Cooperative | tel:(22)292431 > > > > /\\_\\/_/ | Technologies Lab. | mail: is092756@cca.pue.udlap.mx > > > > \\/_/ ict | UDLA-P, Mexico. | > > > > __________|____________________|____________________________________ > > > > > > > > > > > > > ____roberto dircio palacios macedo__________________________________ > > __ | | > > /\\_\\__ | Interactive and | http://ict.udlap.mx/people/roberto > > \\/_/\\_\\ | Cooperative | tel:(22)292431 > > /\\_\\/_/ | Technologies Lab. | mail: is092756@cca.pue.udlap.mx > > \\/_/ ict | UDLA-P, Mexico. | > > __________|____________________|____________________________________ > > Just for the sake of it make sure you're always frowning > > it shows the world that you have substance and depth. Tennant/Lowe > > ____________________________________________________________________ > > > ____roberto dircio palacios macedo__________________________________ __ | | /\\_\\__ | Interactive and | http://ict.udlap.mx/people/roberto \\/_/\\_\\ | Cooperative | tel:(22)292431 /\\_\\/_/ | Technologies Lab. | mail: is092756@cca.pue.udlap.mx \\/_/ ict | UDLA-P, Mexico. | __________|____________________|____________________________________ Just for the sake of it make sure you're always frowning it shows the world that you have substance and depth. Tennant/Lowe ____________________________________________________________________

Roberto Dircio Palacios-Macedo wrote: > > good thing you guys are around. I would've made a real disaster. I did as > robert said. It went smooth with /dev/null as tapedev... a slick buffered > log database is the result. You could have changed it on the fly using onmonitor. Just instead of going into the parameters submenu go into Logical-Logs submenu and select Tape-Parameters and change it there. This will not attempt to initialize the engine as the Parameters->Initialize screen does. As you discovered the engine does not reread the ONCONFIG file for the LTAPE parameters when ontape/onbar runs as it does do for the TAPE parameters. These must be changed in the ONCONFIG file but also in shared memory. Only onmonitor can do that using the method above. Art S. Kagel