Do we have to shutdown sap database before updating timezone file

[smg_atlas]

Hi Gurus

I am in the middle of updating the package PHCO_37720.depot which will update the timezone file /usr/lib/tztab for new timezone for Melbourne in April 2008.
Just a query, do I need to stop sap database first or leave it running?
And once after rebooting the system does how does the sap get the time stamp?

regards
smg_atlas

[Dennis Handly]

You don't need to shut it down.
You may need to stop it when the DST transition occurs if your application uses local time instead of GMT or time_t time.

>And once after rebooting the system does how does the SAP get the time stamp?

You will have to ask SAP.

[Dennis Handly]

Here are some other threads on this issue:
http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1104449
http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1216997

[AL_3001 · Accepted solution]

Hello,
It is always safe to dtop the database and than update the timezone. By doing this you will ensure that the database will not get corrupt, if had if you leave it running. I would always prefer to stop the database ,thn do the updation and than restart the database.

Cheers,
Ashish

[AL_3001]

Hello,
It is always safe to stop the database and than update the timezone. By doing this you will ensure that the database will not get corrupt, if had if you leave it running. I would always prefer to stop the database ,thn do the updation and than restart the database.

Cheers,
Ashish

[Shibin_2]

Hi,

As per HP-RC, no need of rebooting the box. But, if you want to make the daylight saving effects on SAP, you need to shutdown the SAP and keep offline for 80min (for Melbourne) and start it.

We have already created some script for the same, to which it shutdown SAP and sleep for 80min, then start.

Thanks.

[Shibin_2]

== Some additions ==

Patch can be applied any time on the box. But when the effective date of daylight saving starts, you need to do the recycle (stop.. sleep and start..) of SAP to be done.

[Yogeeraj_1]

hi,

Normally as long as, the timezone change will affect the time so that the new time is in the future, you can proceed "safely" without having to stop the SAP database. If this is not the case, it is very important to stop the database and assess the implication at the application level of the changes before starting the database again.

good luck!

kind regards
yogeeraj

[smg_atlas]

Thanks everyone who participated.
I did stop the SAP database to be on the safe side, then I swinstall the patch and then rebooted the system.

Today I logged into the box and can see the time as per the new timezone file.
I haven't had any complains from the SAP team so I think everything is ok.

regards,