Skip to Content
avatar image
Former Member

How to obtain log overwrite mode from DBMCLI?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 25, 2014 at 02:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Deepak Kori

      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