Hi Uwe, I tried just using "set log writer off"...until I discovered the database won't restart under Windows 2000, XP SP1 etc!!!!!!! Ouch!
Can you confirm that the "set log auto overwrite on" will NOT increase the log size - ie will just keep writing over it? many thanks, David "Hahn, Uwe" <[EMAIL PROTECTED]> on 06/06/2003 02:57:38 AM To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Subject: RE: How to turn off logging in sapdb ? Yes, you always have to define a log volume. If you used the command "set log writer off" the state is stored in the database. So you don't need to execute this at every restart. Please use additionally the command "set log auto overwrite on" (util_execute in admin mode). This is needed because switching of log writing does not prevent savepoint to write an entry into the log and if you want to run the database in this mode for a long time it can happen that the log becomes full with switched off log writing which would be amazing for. But perhaps you only need to use the auto overwrite feature ?! Regards, Uwe > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Mittwoch, 4. Juni 2003 19:10 > To: Hahn, Uwe > Cc: [EMAIL PROTECTED] > Subject: RE: How to turn off logging in sapdb ? > > > > We want to turn logging off permanently. > > Believe I have successfully done this with util_execute SET > LOG WRITER OFF > in my init script. > > Apart from backups etc. are there any other repercussions to > doing this? > We will move to transaction based stuff later, but for now > don't need it. > > Also, apparently I ***have*** to create a log volume of > atleast 2001 8K > pages? > > Many thanks, > > David > > > > > > "Hahn, Uwe" <[EMAIL PROTECTED]>@listserv.sap.com on 15/05/2003 > 02:34:38 AM > > Sent by: [EMAIL PROTECTED] > > > To: "'Sourabh Ahuja'" <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > cc: > Subject: RE: How to turn off logging in sapdb ? > > > Please have a look into http://www.sapdb.org/7.4/pdf/logsettings_eng.pdf < http://www.sapdb.org/7.4/pdf/logsettings_eng.pdf> If you have questions with this I will try to help you. kind regards Uwe -----Original Message----- From: Sourabh Ahuja [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 14. Mai 2003 22:40 To: [EMAIL PROTECTED] Subject: How to turn off logging in sapdb ? Hi, I want to turn off logging in sapdb for testing purposes. Can anybody tell me how to do that ? Here is my param file:: param_rmfile param_startsession param_init OLTP param_put LOG_MODE SINGLE param_put CAT_CACHE_SUPPLY 3000 param_put CACHE_SIZE 32768 param_put MAXDATADEVSPACES 5 param_checkall param_commitsession param_addvolume 1 DATA $HOME/$SID/DISKD0001 F 262144 param_addvolume 1 LOG /export/$SID/DISKL001 F 65536 quit Any kind of help will be appreciated. Thanks, Sourabh. _____ Do you Yahoo!? The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> Yahoo! Search - Faster. Easier. Bingo. (See attached file: C.htm) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
