RE: more AUTOLOG

I am running 7.6.00.25. My mistake. I'll keep it in mind for when I get =
their.

Thanks

-----Original Message-----
From: Heinrich, Tilo [mailto:[email protected]]=20
Sent: Tuesday, July 24, 2007 11:48 AM
To: [email protected]
Subject: RE: more AUTOLOG

Hello John,

What version of MaxDB are you using? As stated below, you need MaxDB =
7.5.00.40, 7.6.02.00 or newer versions of 7.5 and 7.6.

Best regards,
Tilo

Tilo Heinrich
Senior Developer
MaxDB&liveCache
SAP AG
http://www.sap.com <http://www.sap.com/>=20

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai =
Agassi, L=E9o Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, =
Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: =
Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Gesch=E4ftsgeheimnisse oder sonstige =
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail =
irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, =
eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich =
untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die =
empfangene E-Mail. Vielen Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or =
otherwise confidential information. If you have received this e-mail in =
error, you are hereby notified that any review, copying, or distribution =
of it is strictly prohibited. Please inform us immediately and destroy =
the original transmittal. Thank you for your cooperation.


-----Original Message-----
From: Cappellano, John J=20
Sent: Dienstag, 24. Juli 2007 17:34
To: Heinrich, Tilo; [email protected]
Subject: RE: more AUTOLOG

Hi Tilo,
If I understand your reply the INTERVAL option can force logs to be =
created (cut) without the LOG_SEGMENT_SIZE being reached. This is what I =
am after. We want to try to push log activity out on a more frequent =
basis.=20

When I execute the command you specified:
dbmcli -d ... -u ...,... -uUTL -c autolog_on <medium_name> INTERVAL 3600

I get:
-24946,ERR_TOOMANYPARAM: too many parameters

Any suggestions. I also tried it without the -uUTL -c syntax and get the =
same error returned.

Thanks

-----Original Message-----
From: Heinrich, Tilo
Sent: Tuesday, July 24, 2007 10:08 AM
To: [email protected]
Subject: RE: more AUTOLOG

Hello John,

I'm not sure what you understand by cutting a log backup. The INTERVAL =
option is in effect forcing a log backup, if there exist log entries, =
that were written to the log volume before the length of the INTERVAL =
but not backed up since. In other words, if your database has not =
created LOG_SEGMENT_SIZE many log entries for the length of the INTERVAL =
option after the last automatic log backup, the backup of the partial =
"log segment" is started at the end of the interval. No running log =
backup is cut.

In times with high activity on the log the automatic log backup creates =
log backups in the size of LOG_SEGMENT_SIZE as in previous versions. In =
times with low activity on the log the INTERVAL option ensures the =
backup of log entries after a certain amount of time.

Best regards,
Tilo Heinrich
Senior Developer
MaxDB&liveCache
SAP AG
http://www.sap.com <http://www.sap.com/>=20

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai =
Agassi, L=E9o Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, =
Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: =
Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Gesch=E4ftsgeheimnisse oder sonstige =
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail =
irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, =
eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich =
untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die =
empfangene E-Mail. Vielen Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or =
otherwise confidential information. If you have received this e-mail in =
error, you are hereby notified that any review, copying, or distribution =
of it is strictly prohibited. Please inform us immediately and destroy =
the original transmittal. Thank you for your cooperation.

-----Original Message-----
From: Cappellano, John J=20
Sent: Dienstag, 24. Juli 2007 14:38
To: Heinrich, Tilo
Subject: RE: more AUTOLOG

Tilo,
Are you stating that every 3600 seconds a log backup will be cut and =
written to the backup medium location?

Thanks

-----Original Message-----
From: Heinrich, Tilo=20
Sent: Monday, July 23, 2007 10:58 AM
To: [email protected]
Subject: RE: more AUTOLOG

Hello Joerg,

If you use MaxDB 7.5.00.40, 7.6.02.00 or newer versions of 7.5 and 7.6 =
you can specify an interval while starting the automatic log backup, =
e.g.:

dbmcli -d ... -u ...,... -uUTL -c autolog_on <medium_name> INTERVAL 3600

This would ensure, that the backup of a log entry is started at least =
3600 seconds after the log entry was written onto the log volumes. The =
interval option does not ensure log backups to fixed points in time but =
sets a time limit to the log entries lost, if the log volume is lost.

Best regards,
Tilo Heinrich
Senior Developer
MaxDB&liveCache
SAP AG
http://www.sap.com <http://www.sap.com/>=20

Sitz der Gesellschaft/Registered Office: Walldorf, Germany
Vorstand/SAP Executive Board: Henning Kagermann (Sprecher/CEO), Shai =
Agassi, L=E9o Apotheker, Werner Brandt, Claus Heinrich, Gerhard Oswald, =
Peter Zencke
Vorsitzender des Aufsichtsrats/Chairperson of the SAP Supervisory Board: =
Hasso Plattner
Registergericht/Commercial Register Mannheim No HRB 350269

Diese E-Mail kann Betriebs- oder Gesch=E4ftsgeheimnisse oder sonstige =
vertrauliche Informationen enthalten. Sollten Sie diese E-Mail =
irrt=FCmlich erhalten haben, ist Ihnen eine Kenntnisnahme des Inhalts, =
eine Vervielf=E4ltigung oder Weitergabe der E-Mail ausdr=FCcklich =
untersagt. Bitte benachrichtigen Sie uns und vernichten Sie die =
empfangene E-Mail. Vielen Dank.

This e-mail may contain trade secrets or privileged, undisclosed, or =
otherwise confidential information. If you have received this e-mail in =
error, you are hereby notified that any review, copying, or distribution =
of it is strictly prohibited. Please inform us immediately and destroy =
the original transmittal. Thank you for your cooperation.


-----Original Message-----
Sent: Dienstag, 17. Juli 2007 14:18
To: [email protected]
Subject: more AUTOLOG

Hello,

how can i have AUTOLOG every hour, without  AUTOLOG OFF and backup?
Sorry but will not resize the LOG area. The LOG area will be a standard
on our systems. :-(

Kind regard
Joerg


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]