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

    Unanswered: impact on database when server time is changed

    Hello,

    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
    Posts
    4,292
    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.

    Andy

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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
  •