Chris, Thank you (and to the other that replied to my original message)!
Item 'a' below makes quite a bit of sense so I will set myself a reminder to stop the system during the DST switches. Item 'b' is also very helpful. Currently our config is setup for just one local time source so I will add a few external ones as a backup. Thanks again, Joe On Wed, 2006-01-04 at 10:26 +0100, JUNG, Christian wrote: > Hi Joe! > > We're running here NTP on all SAP DB/MaxDB-Servers without any known > problems. But you should take care of > > a) Daylight-Saving-Time (this could be a problem maybe) > Our productive SAP R/3 systems - running with MaxDB - are shut down for the > period of DST-changes. There is also a SAP note for this issue. > Test instances of SAP DB (for internal applications) are NOT stopped during > this period. But I don't know if there were any missing records. But > actually no developer complained about missing records. Okay - normally they > don't work on Sunday at 02:00 AM. > > b) Time hopping > You should verify, that your time-source is ALWAYS reachable, stable and > correct :-). For more information about this issue: http://www.ntp.org. > > Hope this helps a bit... > > > Bye > Chris > > >-----Original Message----- > >From: Joe Haynes [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, January 04, 2006 12:11 AM > >To: MaxDB Mailinglist (E-Mail) > >Subject: Managing Time on MAX DB Systems > > > > > >I was wondering if anyone else on the list has > >experienced any issues with MAXDB while running > >NTP to keep the time in sync. > > > >We were running SAP DB last summer and experienced > >some strange issues while running NTP (missing > >records being one). Right now we are stopping the > >DB and updating the time manually (instead of > >running NTP). But I'd like to setup some sort > >of nightly update to sync up the time without > >having to shutdown the DB. > > > >Would that be possible or has anyone found it > >better to create a script that calls dbmcli? > > > >Thanks in advance for any info. > > > >- Joe Haynes > >Helena, Montana, US > > > >http://www.terrafirmasolutions.com/ > > > > > >-- > >MaxDB Discussion Mailing List > >For list archives: http://lists.mysql.com/maxdb > >To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
