DST - did not bounce my DB2 server

[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

[Jonathan Leffler]

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/

[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.

[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