Re: Question: Changing DB Logging Mode

f_testa@yahoo.com wrote: > > In article <MPG.f6dcfbea880db04989683@news>, > leekb@post1.com (LeeKB) wrote: > > > > Can anyone enlighten me how to go about switching btwn the different db > > logging mode of a OnLine Database (Version 7.xx)? Can I do it online? or > > must I do it in Quiescent mode? > > > > Kok-Bin > > > You can be in online mode and use onmonitor (Logical-Logs, Databases) > selection to change a database from Buffered to UnBuffered mode and > vice versa. To change a database from no logging to logging, you would > typically set your TAPEDEV configuration parameter to /dev/null and run > ontape. > EX: ontape -s -U xxx to change database xxx from no logging to > unbuffered logging. > > Frank Testa > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/ Now offering spam-free web-based newsreading ..... Just a reminder..... All sessions that are using database xxx must be terminated before you can change the logging status of the database. So, if you get an error when running your "ontape -s -U xxx" command, do a "onstat -g sql | grep xxx" to see if someone is using database xxx. Tim Jones