log auto overwrite

[Former Member]

Hello,

I am currently working with SAP DB 7.3 on AIX 4.3.3 and Database Manager 7.5.

Through Database Manager 7.5 I can set the LOG AUTO OVERWRITE by menu: Instance -> Configuration -> Log Settings.

However I need to do this by dbmcli.

I have tried the following:

dbmcli -d <database> -u dbm,<password> -uUTL -c util_execute set log auto overwrite on

Then I receive the following error:

ERR

-24988,ERR_SQL: sql error

-3008,Invalid keyword or missing delimiter

Any ideas or suggestions?

Thanks,

David

[Former Member]

Hi,

I'm sorry but it is not supported to switch off the database logging with DBMCLI command sequence.

You have to use DBMGUi or Database Studio.

Therefore You won't find any documentation about switch off the logging via DBMCLi commands.

Regards, Christiane

[Former Member]

HI,

Use of the DBM command util_execute SET LOG AUTO OVERWRITE ON is works online With version 7.4.03 and above.

regards,

kaushal

[Former Member]

For Version 7.3 ... "dbmcli -d ... -u ... util_execute set log mode demo"

I found it in the mail listing, posted by Uwe Hahn dating back to November 2002.

Thanks,

David