autolog with time interval

[Former Member]

Any one know how to set up autolog with 900 seconds interval?. We are on 7.5.00.44 (recently upgraded from 7.5.00.39 to just get this autolog interval feature). I know there is DBM command: autolog_on [<medium>] [INTERVAL <interval in seconds>],

But I am unable to see this option with DBMGUI. I remember i have seen this option earlier at other site. Any thoughts?

[former_member229109]

Hello,

-> As of MaxDB version 7.5.00.40 a time interval may be set to launch

the automatic log backup along this interval.

The explain text for command autolog_on as of 7.5.00.44 MAXDB version added, you could run u201Cexplain autolog_onu201D dbm command to see more details on autolog_on options.

Some fixes released as of 7.5.00.45 database version <PTS 1147699 u2013 www.sapdb.org/webpts>.

-> What is the version of your DBMGUI?

-> Using the DBMGUI 7.6.03.10 and database version 7.6.03.15 I could set autolog on using option

u201CCreate a log backup every XXX minutesu201D

Connect to database, top menu:Instance

Thank you and best regards, Natalia Khlopina

[Former Member]

Hi Natalia, Thanks for answers.

We are using DBMGUI 7.5.00.12 and maxdb 7.5.00.44 (with SCM 4.1). Is this option dependent on MaxDB version or DBMGUI version or combination of both?

Thanks

Gopala

[former_member229109]

Hello Gopala,

-> As I wrote above that as database version 7.5.00.40 a time interval could be set using

autolog_on.

As you are running 7.5.00.44 database version, you could use dbm command

u201Cexplain autolog_onu201D dbm command to see more details on autolog_on option:

dbmcli u2013d <SID> -u control,<pwd> explain autolog_on

Syntax:

autolog_on [<medium_name>] [INTERVAL <interval>]

Options:

<medium_name>

Name of the backup medium

<interval>

The maximal time interval in seconds until a log entry that was written

to the log area is backed up by the automatic log backup. A value of 0

seconds for parameter <interval> deactivates interval handling by the

automatic log backup. Automatic log backups are then only triggered by

completed log segments. The default value for this option is 0.

-> You have to update the DBMGUI to be able to use the new database feature like

set autolog on using option

u201CCreate a log backup every XXX minutesu201D

< Update DBMGUI, then Connect to database, top menu:Instance >

Thank you and best regards, Natalia Khlopina