W dniu 2014-11-28 o 12:53, Peter Hunkeler pisze:
Our current process:
When time comes to switch back from daylight saving time to standard time,
we're stopping our DBMS and middleware softwar for one hour. Reason being that
we cannot get commitment from the application side that each and every
application is either using UTC or that it can cope with duplicate time stamps.
Our current "problem":
Someone has put the idea in our managment's head that there is a software soltution which
avoids the one hour pause. The software would "slows down" the (local time)
clock so that one software hour will take two real hours to pass by.
Does anyone know about such a solution?
Does anyone use one?
Does anyone use other processes?
We'd like to be able to argue with management about this idea.
IMHO "slow down the clock" is the worst possible solution, if techically
possible at all.
I guess your DBMS is using UTC, so local time shift should be
transparent to it. From the other ahnd your business application can
record events (i.e. transactions) with the local time. Change can be
costly, but in many cases the application can tolerate overlapping
timestamps.
BTW: is you business ready to accept events which occured at "02:31, but
we don't care whether it's winter or summer time"?
--
Radoslaw Skorupka
Lodz, Poland
---
Tre tej wiadomoci moe zawiera informacje prawnie chronione Banku
przeznaczone wycznie do uytku subowego adresata. Odbiorc moe by jedynie
jej adresat z wyczeniem dostpu osób trzecich. Jeeli nie jeste adresatem
niniejszej wiadomoci lub pracownikiem upowanionym do jej przekazania
adresatowi, informujemy, e jej rozpowszechnianie, kopiowanie, rozprowadzanie
lub inne dziaanie o podobnym charakterze jest prawnie zabronione i moe by
karalne. Jeeli otrzymae t wiadomo omykowo, prosimy niezwocznie
zawiadomi nadawc wysyajc odpowied oraz trwale usun t wiadomo
wczajc w to wszelkie jej kopie wydrukowane lub zapisane na dysku.
This e-mail may contain legally privileged information of the Bank and is
intended solely for business use of the addressee. This e-mail may only be
received by the addressee and may not be disclosed to any third parties. If you
are not the intended addressee of this e-mail or the employee authorized to
forward it to the addressee, be advised that any dissemination, copying,
distribution or any other similar activity is legally prohibited and may be
punishable. If you received this e-mail by mistake please advise the sender
immediately by using the reply facility in your e-mail software and delete
permanently this e-mail including any copies of it either printed or saved to
hard drive.
mBank S.A. z siedzib w Warszawie, ul. Senatorska 18, 00-950 Warszawa, www.mBank.pl, e-mail: [email protected]
Sd Rejonowy dla m. st. Warszawy XII Wydzia Gospodarczy Krajowego Rejestru Sdowego, nr rejestru przedsibiorców KRS 0000025237, NIP: 526-021-50-88. Wedug stanu na dzie 01.01.2014 r. kapita zakadowy mBanku S.A. (w caoci wpacony) wynosi 168.696.052 zote.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
