Archives of the TeradataForum

Message Posted: Mon, 07 Nov 2011 @ 20:49:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sravan,

I am not an SSR so I may get some details wrong. I have never run the commands myself as I have an Teradata SSR perform this type of maintenance.

You really should consult your SSR before performing this type of activity.

Below command are for MPRAS. LINUX commands may be different.

To set the clock on all servers you can logon as root to the adjust time slowly by how many seconds you adjust

     psh date -a -+ seconds

I believe you can also set the data on all servers with a command something like (numbers are in this order mm dd HH MM ccyy)

     psh date -u 011320012011

to determine if you are using NTP run the following command.

     psh "ps -ef |grep ntp"

Teradata will automatically pick up the date values so you don't need to restart the system. However, you better know how your application handles date changes before you change it while your applications are running.

NTP is Network Time Protocol. This is used to sync up the time on many servers to one "time server".

Basically here you have to tell your Teradata servers to get their time form the "time server".

I do not know how to set up NTP. However, we use it here. It is best practice as you probably want to keep many servers at the same time for better correlation of events across many servers.

Thanks,

Robert Diehl
Travelocity Data Warehouse DBA

	<Prev	Next>		<<First	<Prev	Next>	Last>>