Re: unlogged database
Posted in 1999
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
____________________________________________________________________