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)
Please
have a look into 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 Yahoo! Search - Faster. Easier. Bingo.
