Hello,

If we change server time 2-3 hours ahead or behind, what is the impact on DB2 database?


Thank you!

Anything that uses the clock may cause confusion. For example, the db2diag.log file may seem out of order, even though it is not. The worst will be where you store a time or timestamp based on "current time" or "current timestamp". Someone will have to remember when the change occurred and thus comparing time from before to thos after need special consideration.

Andy

Typical problems are: Logs can run into serious problems and DB2 may not be able to find its built-in functions.

Therefore, you should never ever mess with the system time. I would set the system time to UTC and then work with timezones.