Set TimeZoneString value using tdlocaledef or dbscontrol utilities

Tools

Set TimeZoneString value using tdlocaledef or dbscontrol utilities

HI,

I want to set TimZone String value using the tdlocaledef utility. Current value is (got using 'dbscontrol' utility with 'display general'):

18. System TimeZone String         = Australia Eastern

I tried as below to set : 

# tdlocaledef -input sdf.txt

6766: Missing entries in SDF

the content of sdf.txt

-------------------------

TimeZoneString {"GMT-8"; "-8"; "0"}

even tried with other contents:

1)TimeZoneString {"GMT-8"; "-8"; "0"}

2)TimeZoneString {""}

3)TimeZoneString {"Australia Eastern"; "10"; "0"; "6"; "3"; "10"; "0"; "0"; "-1"; "02:00:00"; "4"; "3"; "15"; "0"; "0"; "03:00:00"; "1987"; "1990"; "10"; "0"; "11"; "0"; "3"; "10"; "0"; "0"; "-1"; "02:00:00";

"4"; "3"; "1"; "0"; "0"; "03:00:00"; "1991"; "1994"; "10"; "0"; "11"; "0"; "3"; "10"; "0"; "0"; "-1"; "02:00:00"; "3"; "3"; "0"; "0"; "-1"; "03:00:00"; "1995"; "2005"; "10"; "0"; "11"; "0"; "3"; "10"; "0"; "

0"; "-1"; "02:00:00"; "4"; "4"; "1"; "0"; "0"; "03:00:00"; "2006"; "2006"; "10"; "0"; "11"; "0"; "3"; "10"; "0"; "0"; "-1"; "02:00:00"; "3"; "3"; "0"; "0"; "-1"; "03:00:00"; "2007"; "2007"; "10"; "0"; "11";

"0"; "4"; "10"; "1"; "0"; "0"; "02:00:00"; "4"; "4"; "1"; "0"; "0"; "03:00:00"; "2008"; "9999"; "10"; "0"; "11"; "0"}

But getting errors, am i trying anything wrong here, whats the correct way to set the timeZone value.

thanks

Chandra


1 REPLY
Teradata Employee

Re: Set TimeZoneString value using tdlocaledef or dbscontrol utilities

You can't update just one entry in the SDF, you must supply a complete SDF. The recommended process is to extract the current SDF settings to a text file, edit the text file, and then apply to the updated file:

tdlocaledef -reverse current -source mySDF.txt

... edit the mySDF.txt file as desired

... double-check that there is no syntax issue

tdlocaledef -input mySDF.txt -output mySDF.bin

tdlocaledef -reverse mySDF.bin -source vfySDF.txt

... if mySDF.txt and vfySDF.txt match, then apply the changes

tdlocaledef -input mySDF.txt -output new

... restart the database to activate the changes