Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Do We need to Restart DBS to Reset time on system
From:   Diehl, Robert


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.


Robert Diehl
Travelocity Data Warehouse DBA

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023