Can we change the system time while the cluster and package is running?

[Jack007]

thanks a lot!

[Dennis Handly]

Are you talking forward or backward?

I assume you are not just changing the timezone?  Do you have NTP installed?

[Jack007]

Hi Dennis,

what's the differences?

My customer hasn't mention this.

[Dennis Handly]

>what's the differences?

There may not be but setting the clock back is always worse.

[Patrick Wallek · Accepted solution]

How big of a time change are you looking to make? Seconds? Minutes? Hours? Days?

Is there a database running?  If so changing the time can cause issues with the database as transaction times have the potential to suddenly not match.

Chaning the time backwards can really cause DB issues as the time is suddenly in the past.

[Jack007]

Dennis and Patrick,

Thanks for your advice, it's very helpful to me.

At last my customer stoped the DB and halted the MCSG cluster, then modified the system time.

I will ask talk about the impact of changing the time with the DBA.

Thanks again!