Register | Login

Tech Center

Tech Tips

How would you adjust the time on a Teradata system if the 'get time' Ferret command shows the time as 03:06:11, whereas the exact time is 03:36:11?

Adjusting time across all the nodes in an MPP system is handled by a UNIX command. First, to view the time on each node, issue this UNIX command:

rallsh -sv date
To change all the nodes to a given time, issue this command from any node, and it will be proliferated out to all nodes that are BYNET connected:
rallsh -sv date mmddHHMM2002
mm=2-digit month
dd=2-digit day
HH=2 digit hour
MM=2d digit minute

Only months, days, hours and minutes are changeable, not seconds.

View All Tips >
Got a great idea? Share it with your peers!  >


Company Newsroom Site Help Site Map Privacy/Legal Contact Us