Reboot necessary after changing timezone ?

[Franky Leeuwerck]

Hi to everyone,

I have an Ingres DBMS running on a HP-UX 11 9000/810/D280 in Turkey.

The Unix gives the wright time (eg. 13:00), but Ingres shows a wrong time (eg. 14:00).

I noticed the TZ variable was set to EET-2EEST but there is no entry for EET-2EEST in the /usr/lib/tztab file. There is an entry for EET-2EETDST which is the correct timezone.

So I changed the /etc/TIMEZONE file into :
TZ=EET-2EETDST
export TZ

Result : no changes. The dbms still shows an 1 hour difference with the OS.

I have 2 questions :
a) Do I have to reboot the Unix system in order to let Ingres show the correct time ?
b) There is a configurable kernel parameter timezone set on 420 (default). Must this be changed too ?

Thanks in advance

Franky Leeuwerck

[Franky Leeuwerck]

Also after restarting the DBMS, the DBMS shows another time.

[harry d brown jr]

Start and stop your database, or reboot your machine. But because you rolled your time back, I'd suggest a reboot immediately, because it could toast your ability to recover.


live free or die
harry

[James R. Ferguson · Accepted solution]

Hi Franky:

As for the use of the kernel parameters 'dst' and 'timezone', Knowledge Base document #KBRC00007429 notes that "As long as your application programs use standard libc functions to obtain timezone information, you do not have to set the timezone or dst kernel parameter.".

For more information, I've attached the full document.

Regards!

...JRF...

[Roger Baptiste]

<TZ=EET-2EETDST
export TZ
Result : no changes. The dbms still shows an 1 hour difference with the OS. >>

the /etc/TIMEZONE is read
during login process through
the /etc/profile file.
So, any change to it won't
get effected until you relogin
or restart the database (which
will relogin).

<a) Do I have to reboot the Unix system in order to let Ingres show the correct time ? >>

Restarting the db will
do it, but it is not a good
idea to do it that way.
You would be better off
rebooting the box and using
set_parms to reset it.

If you want to change
the TZ of just ingres
that you can just add
a TZ= setting in the ingres's
.profile (or .cshrc) file
and export it. That way
you dont need to reboot.
But, if this is systemwide,
then do set_parms and reboot.



This is ""minutes west
of Greenwich"" , whatever that
means. But, i have never changed it for changing timezones. It is default
on all my systems.

-raj

[Rita C Workman]

Once, many moons ago, I had to reset the timezone on a box. I used set_parms and did this and everything seemed to be ok. But noticed that the cron jobs weren't working right. Even though every file I checked showed correct and every command reflected right tz...still...
It was not until I rebooted the server that(everything) finally was together for the timezone.

Now..I routinely reboot the box whenever I have to fix a timezone issue...

Just my 2cents,
Rita

[Franky Leeuwerck]

Thanks all for replying.
It seems restarting Unix is the option I need.
Regards,
Franky