Fred Claypool wrote:
> we've had Auto Logging enabled on all of our MaxDB
> databases. (We're currently running 7.5.00.31 on
> HP-UX & Linux.)
[...]
> them onto tape. Is there any triggering or event
> mechanism built in to MaxDB that I could configure
> that would notify the backup tool to start working
> when MaxDB calls it (as opposed to waiting until
> the next regularly scheduled backup)?
7.5 is the critical factor here. In 7.6 there is a mechanism, there's something called Eventing.
This
http://blog.ulf-wendel.de/?p=19 is on german, but it gives you some code pieces and pointers in the examples. We've also put a very basic example in here
http://dev.mysql.com/tech-resources/articles/maxdb-sap-hosting.pdf which is written in english. Search for "Hands on: Using Eventing for pro-active actions, for example: updating statistics" in that text.
You'll learn that the feature appeared in 7.5.00.8 but has not been declared final before 7.6. So, you might need to experiment a little bit with the syntax. It's kind of late beta in 7.5 - should work most of the time, but no documentation and use at your own "risk".
However, there should be some backup events and it should be possible to trigger an action once the automatic log backup has been done. Note that the online documentation is on 7.6 and has almost no 7.5 notes in it. The 7.5 documentation is in the archive:
http://dev.mysql.com/downloads/maxdb/7.5.00.html#docu .
If it works, let the forum know about your solution.
Ulf
Ulf