How to obtain log overwrite mode from DBMCLI?

[Former Member]

Hello,

in case I have no DB studio at hand and need to use DBMCLI to connect to a MaxDB:

How can I get the status of the log overwrite mode?

I'm able to set it via

db_execute SET LOG WRITER OFF/ ON

Regards,

Jens

[former_member188883 · Accepted solution]

Hi Jens,

Use the below command

To enable log overwrite

dbmcli -d <DBNAME> -u SUPERDBA,<pwd> -c db_execute set log auto overwrite on

To disable log overwrite

dbmcli -d <DBNAME> -u SUPERDBA,<pwd> -c db_execute set log auto overwrite off

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak Kori,

sorry, I had a copy&paste error and actually wanted to refer to

db_execute set log auto overwrite off/on

Stil my original question was:

How can I get the status of the log overwrite mode?

Regards,

Jens

[former_member188883 · Accepted solution]

Hi Jens,

Please use command

dbmcli -d <DBNAME> -u SUPERDBA, <pwd> -c db_execute autolog_show

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

this statement always shows "AUTOSAVE IS OFF".

I have found the solution in the meantime.

The following SQL shows whether the Overwrite Mode is activated:

select automaticoverwrite from loginformation

Regards,

Jens