How can we see all the DBS control parameters?
Also if I need to modify two parameters below , will it necessarily require server restart?
Also can someone please guide on best practice to be followed to change above parameters.
re: How can we see all the DBS control parameters?
Use the dbscontrol utility to view and modify all DBS Control GDO values. This is explained in the Teradata Database Utilities reference manual
re: modification the time zone settings:
It is best to consult with the Global Support Center (i.e. open an incident) when the system tz needs to be changed.
System Time Zone String is actually changed via tdlocaledef. But as noted, if you intend to change TimeDateWZControl you should involve Teradata support. If this is a brand new system with no user data loaded yet, it's simple. But on a "live" system there are a number of other things you may need to change.