RE: Another method of changing logging on a database

1. Why is it so important to change the database from logging to non-logging? Is it to make processing faster? To avoid long transactions? ... Will >===== Original Message From "Lloyd AJ Wilson" <lwilson@harriscomputer.com> ===== >Hi All, > >Just a curious question .... > >Many of us run very large batch programs (mostly DML Statements) against >some of our databases. The problem is that I want the programmers to be >able to switch from logging to non-logging for their particular database >without running the ontape and modifying the TAPEDEV parameter which would >be set to a tape device and need to be modified to /dev/null to ensure that >they were not performing a level 0 archive on the system to tape when they >change their logging mode on their database back and forth (from logging to >non-logging and vice-versa). > >I know that you can change the logging mode using SQL with a logging >database from buffered to unbuffered logging using the SET LOG command but >this I am sure (based on the SQL Syntax Guide pdf) does not change from a >logging to a non-logging database and vice-versa. > >In order for you to properly do this (change logging on and off) .. you must >use the ontape utility ... right? ... and each time you do this requires a >system archive on the server ... right? I have done this many times... > >Is there any easier way that the programmers can make this modification >without going through all these steps outlined above to change thier logging >methods on their databases? Has anyone run into this situation and if so >... what did you do to make things more convenient for the user? > >Any help appreciated. For the record I am using 7.30 UC5 on LINUX 5.2 >(Redhat). > >TIA, > >Lloyd AJ Wilson. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com ------------------------------------------------------------