Has anyone has any (mentionable) issues with running NTP together with
Informix ? (I am still running IDS7.31 FD3)
Dirk Moolman
Database and Unix Administrator
Digicare Technologies (HealthCorp)
"People demand freedom of speech as a compensation for the freedom of
thought which they seldom use."
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
Thomas Ronayne - 27 Jan 2006 15:14 GMT
> Has anyone has any (mentionable) issues with running NTP together with
> Informix ? (I am still running IDS7.31 FD3)
You mean Network Time Protocol? NTP has nothing whatsoever to do with
Informix, it just keeps the system clock synchronized and Informix (as
far as I know) takes its time stamps from the operating system.
No, never ever had one problem with NTP and Informix on Solaris boxes
(30 of 'em) or Linux boxes (5 of those), all synced with NTP.
Everything works -- if you let it.
Dirk Moolman - 27 Jan 2006 15:27 GMT
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of Thomas Ronayne
Sent: 27 January 2006 05:15 PM
>> Has anyone has any (mentionable) issues with running NTP together
with
>> Informix ? (I am still running IDS7.31 FD3)
>You mean Network Time Protocol? NTP has nothing whatsoever to do with
>Informix, it just keeps the system clock synchronized and Informix (as
>far as I know) takes its time stamps from the operating system.
Yes, thanks. I just want to make 100% sure. I will be testing it
anyway, but just wanted to hear from the people who have experience with
this.
Thank you for your reply.
Dirk
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
Paul Watson - 27 Jan 2006 15:31 GMT
> -----Original Message-----
> From: Dirk Moolman [mailto:DirkM@caretech.co.za]
[quoted text clipped - 5 lines]
> Has anyone has any (mentionable) issues with running NTP together with
> Informix ? (I am still running IDS7.31 FD3)
Nope, not a single problem
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 North America Conference.
Tampa, Florida, USA. 7-11 May 2006.
Visit http://www.iiug.org/conf for more information.
david@smooth1.co.uk - 28 Jan 2006 01:42 GMT
The only time problem I have ever heard of is that ER does not work if
clock are more
than 15 minutes apart. NTP should avoid that!
try_and_err@web.de - 28 Jan 2006 08:47 GMT
Dirk Moolman schrieb:
> Has anyone has any (mentionable) issues with running NTP together with
> Informix ? (I am still running IDS7.31 FD3)
[quoted text clipped - 9 lines]
> >
> No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.
Be sure that your (critical) cronjobs run really once. With time
syncronisation it can be, that your cronjob start for example at 6 am,
ntp corrects the time from 06:00:01 to 05:59:59 - and the cronjob start
again...
Regards,
try_and_err
Paul Watson - 28 Jan 2006 12:02 GMT
> -----Original Message-----
> From: try_and_err@web.de [mailto:try_and_err@web.de]
[quoted text clipped - 8 lines]
> together with
> > Informix ? (I am still running IDS7.31 FD3)
[cutting]
> Be sure that your (critical) cronjobs run really once. With time
> syncronisation it can be, that your cronjob start for example at 6 am,
[quoted text clipped - 4 lines]
> Regards,
> try_and_err
Ntp should never apply a delta, it should work by drifting the 'clock'
i.e. slowing or speeding up. Once sync'd the changes tend to be a the
milliseconds level anyway
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 North America Conference.
Tampa, Florida, USA. 7-11 May 2006.
Visit http://www.iiug.org/conf for more information.
>
try_and_err@web.de - 28 Jan 2006 17:58 GMT
Paul Watson schrieb:
> Ntp should never apply a delta, it should work by drifting the 'clock'
> i.e. slowing or speeding up. Once sync'd the changes tend to be a the
> milliseconds level anyway
Correct - it SHOULD.
But:
How will NTP discipline my Clock?
- settimeofday(2) to step (set) the time. This method is used if the
time if off by more than 128ms.
For example (on Linux):
ntpd[1234]: time reset -1.081474 s
nagios: Warning: A system time change of 1 seconds (backwards in time)
has
been detected. Compensating...
In my experience cron doesn't compensating this change (on Solaris).
Regards,
try_and_err
Paul Watson - 28 Jan 2006 18:13 GMT
> -----Original Message-----
> From: try_and_err@web.de [mailto:try_and_err@web.de]
[quoted text clipped - 24 lines]
> Regards,
> try_and_err
Wonder how the date drift on Solaris works then, wonder if it applies X
x 128ms movements. But I never dug deep into it. Looked at some of our
prod Solaris boxes, the ntp adjust log shows a couple of millseconds
adjustement
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 North America Conference.
Tampa, Florida, USA. 7-11 May 2006.
Visit http://www.iiug.org/conf for more information.
david@smooth1.co.uk - 29 Jan 2006 00:22 GMT
"In my experience cron doesn't compensating this change (on Solaris)."
Is this when the time difference is large i.e. if you start ntp when
the
clock is out by more than a few seconds?
I would make sure that the time is correct on the machine BEFORE
you activate the NTP process for the first time.
Or it is that the NTP process is adjusting the time by one second and
this
causes a problem?
Thomas Ronayne - 29 Jan 2006 13:06 GMT
> "In my experience cron doesn't compensating this change (on Solaris)."
>
[quoted text clipped - 9 lines]
> causes a problem?
>
NTP should be started at system boot and left alone after that. In the
start script in rc2.d (or rc3.d or wherever you choose), stick a line in
before the daemon start like this:
<path_to>/ntpdate -v stratum_1_server stratum_1_server
(yes, two stratum 1 servers). That sets the clock dead on and then you
start the daemon. I use two servers at Argonne National Laboratories
just because they're close. Pick a couple close to you.
I use three pool servers in ntp.conf. Once the daemon has synchronized
(based on delay, offset and jitter -- execute nptq -p and look), the
system clock is, more or less, continuously nudged to stay on time. You
should not see many entries in your log file, but if you do you need to
find some better pool servers. I use 0.pool.ntp.org, 1.pool.ntp.org and
2.pool.ntp.org (check the web site for the pool servers available in
your area).
You really need to look at the log every so often and deal with any
problems that might crop up (problems meaning try other external servers
if you have large values in the ntpq -p display). You really won't see
adjustments of seconds in the log -- if you do, you've got a problem to
solve.
If you're really serious, get a radio clock, hook it up to one of your
servers and use that one as your timeserver for the whole internal
network... There are some nice GPS clocks available.

Signature
Everything works -- if you let it.
try_and_err@web.de - 29 Jan 2006 22:31 GMT
david@smooth1.co.uk schrieb:
>> "In my experience cron doesn't compensating this change (on Solaris)."
>
> Is this when the time difference is large i.e. if you start ntp when
> the clock is out by more than a few seconds?
No, it was weeks/months later (after reboot).
> I would make sure that the time is correct on the machine BEFORE
> you activate the NTP process for the first time.
Yes, this was done with 'ntpdate'.
> Or it is that the NTP process is adjusting the time by one second and
> this causes a problem?
Yes, NTP was changing (backwards) the time and cron has started the
same cronjobs a second time.
Maybe an another had have the same problem and knows, that a newer or
other cron daemon on solaris don't have this problem ?
Regards,
try_and_err
Dirk Moolman - 30 Jan 2006 11:17 GMT
-----Original Message-----
From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On Behalf Of try_and_err@web.de
>>> Is this when the time difference is large i.e. if you start ntp when
>>> the clock is out by more than a few seconds?
>No, it was weeks/months later (after reboot).
>>> I would make sure that the time is correct on the machine BEFORE
>>> you activate the NTP process for the first time.
>Yes, this was done with 'ntpdate'.
>>> Or it is that the NTP process is adjusting the time by one second
and
>>> this causes a problem?
>Yes, NTP was changing (backwards) the time and cron has started the
>same cronjobs a second time.
>Maybe an another had have the same problem and knows, that a newer or
>other cron daemon on solaris don't have this problem ?
Thanks for the feedback (and short discussion) on this - gave me some
food for thought :-)
I have started ntp (on my test servers), and will monitor it for a
couple of days before implementing on production.
Regards
Dirk
The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way.
No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd.