By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,721 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

DST - did not bounce my DB2 server

P: n/a
aj
DB2 LUW v8.2 FP 14 RHAS 2.1

Regarding DST:
My OS and java were successfully patched for DST, but the DB2 instance
was never bounced.

The OS returns the correct time, but a 'values current time' in DB2 is
an hour behind. If the OS is correct, shouldn't DB2 also be correct?

To fix it, do I only need to bounce the DB2 instance so that it sees the
correct time from the OS? Will anything else break? Recommendations?

TIA

aj
Mar 14 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
aj wrote:
DB2 LUW v8.2 FP 14 RHAS 2.1

Regarding DST:
My OS and java were successfully patched for DST, but the DB2 instance
was never bounced.

The OS returns the correct time, but a 'values current time' in DB2 is
an hour behind. If the OS is correct, shouldn't DB2 also be correct?
Only if it is restarted so it re-reads the DST files.
To fix it, do I only need to bounce the DB2 instance so that it sees the
correct time from the OS? Will anything else break? Recommendations?
Yes. No.

Bounce DB2.

(OK: I'm applying the rules that apply to IDS - but I'd be surprised if
they differ for DB2).

--
Jonathan Leffler #include <disclaimer.h>
Email: jl******@earthlink.net, jl******@us.ibm.com
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
Mar 15 '07 #2

P: n/a
Ian
aj wrote:
DB2 LUW v8.2 FP 14 RHAS 2.1

Regarding DST:
My OS and java were successfully patched for DST, but the DB2 instance
was never bounced.

The OS returns the correct time, but a 'values current time' in DB2 is
an hour behind. If the OS is correct, shouldn't DB2 also be correct?

To fix it, do I only need to bounce the DB2 instance so that it sees the
correct time from the OS? Will anything else break? Recommendations?
Didn't you reboot after applying the DST patches? Generally that's
required, because all processes need to be restarted in order to "pick
up" the changes to the timezone file.

Mar 18 '07 #3

P: n/a
aj
Ian wrote:
aj wrote:
>DB2 LUW v8.2 FP 14 RHAS 2.1

Regarding DST:
My OS and java were successfully patched for DST, but the DB2 instance
was never bounced.>>
The OS returns the correct time, but a 'values current time' in DB2 is
an hour behind. If the OS is correct, shouldn't DB2 also be correct?>>
To fix it, do I only need to bounce the DB2 instance so that it sees
the correct time from the OS? Will anything else break?
Recommendations?>
Didn't you reboot after applying the DST patches? Generally that's
required, because all processes need to be restarted in order to "pick
up" the changes to the timezone file.
No, I did not reboot the linux server, and the OS picked up the changes
just fine. I guess my sysadmin just restarted all relevant
services/processes...

As an aside: I bounced the DB2 instance last weekend, and DB2 picked
up DST just fine...

thanks

aj

Mar 20 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.