The correct command for switching off redo log writing is:
util_execute SET LOG WRITER OFF
^^^^^^
The syntax has changed but your GUI uses the old form.
Btw, you cannot change the LOG_MODE directly from SINGLE to DUAL.
Newer releases will not allow you to change this parameter directly.
Because setting the log parameters changed within 7.4.2 to 7.4.4
a document will be plublished which describes the changes.
So, please excuse this confusing situation.
regards
Uwe
p.s.
In my opinion this option is very dangerous because a commit does not assure that
your changes became persistent. It's a high price for the convenience not to backup
log.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Freitag, 14. M�rz 2003 13:04
> To: [EMAIL PROTECTED]
> Subject: sql error [util_execute SET LOG DEVSPACE OFF];
>
>
> Hello list,
>
>
> during the test of the SAPDB database Version 7.4.3 Build
> 014.120.037.952
> Runtime Environment W32/Intel 743 Build 014-120-037-952 with the
> GUI SAPDB Manager 7.4 File Version 7.4.3.10 i get the
> following problem:
>
> If i want to change the logmode to SINGLE/OFF i get get the message:
>
> sql error [util_execute SET LOG DEVSPACE OFF]; -3008,Message
> not available
>
> The database is now in the admin-mode, with logmode single.
> If i restart the database then there is a undefined logmode
> in the GUI.
>
> If i connect with dbcli param_directget LOG_MODE, then the logmode is
> single.
>
> Please can you tell me why i cant change the logmode with the GUI?
>
> With kind regards Jens K�nig
>
>
> Viele Gr��e von
>
> Jens K�nig
>
> ******************************************************
> TDS Informationstechnologie AG
> Dipl. Physiker
> Jens K�nig
> SAP Basis-Implementation
> Konrad-Zuse-Stra�e 16
> 74172 Neckarsulm
>
> Tel: +49-71 32-3 66-1336
> Fax: +49-71 32-3 66-2336
> Mobil:+49 - 174 - 309 3482
> mailto:[EMAIL PROTECTED]
> ******************************************************
> http://www.tds-global.com
>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
