Changing date\time on Linux server while progress DB is running

C

cpalace40

New Member
Hi,

Is there any problems changing the time on a linux Server while there are progress v9.1E DB's running?

A colleague told me that in previous versions of progress it uses the timestamp in some way within the DB, so if you change the time it can cause a corruption of the DB. Is there any truth in this?

Thanks
 
We are updating our servers hourly using ntp and that does not create problems.

It might be a problem if you change the date from today to 1-1-1990.


However do not change the hostname while the db is running. :awink:
 
NTP drifts the clock in the background which is harmless for trivial adjustments.
Most unix "date" functions contain an adjustment "date -a" function which drifts the clock. This is safe with Progress for time adjustments of a few minutes.
Do not put an absolute date in with unix "date" without stopping the database because it will crash your database.
If you need to adjust the clock backwards by any significant amount it is safer to stop the database, adjust the clock, and wait until the real time catches up with the last database timestamp before starting the database again.
 
Actually, forward adjustments are no problem.

I might also note that daylight savings adjustments are also no problem since they are a layer above the actual clock.
 
You must log in or register to reply here.
Back
Top