Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    Unanswered: impact on database when server time is changed


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

    Thank you!

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    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.


  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts