Configuring Teradata Database Parameters - Teradata Unity

Teradata® Unity™ Installation, Configuration, and Upgrade Guide for Customers

Teradata Unity
Release Number
October 2018
English (United States)
Last Update
Product Category
Analytical Ecosystem

Certain Teradata configuration parameters must be set the same on each Teradata system to be managed by Unity. The Unity Compatibility Advisor can discover differences between Teradata Database systems that can affect Unity behavior. The Unity Compatibility Advisor is available from Teradata Professional Services, and is run before Unity is installed.

Task List
Done Task
  Install the same character sets on all systems.
  Ensure that the default character set is the same on all Teradata Database and Unity systems.
  Install the same User Defined Types on all systems.
  Ensure that all Teradata Database systems and connected Unity servers have the same authentication mechanisms, which must be similarly configured to operate in a Unity environment.
  Ensure that all users that will connect through Unity are valid, have the same Teradata password and have the same default database across all systems.
  Ensure that the following database control settings are the same across all systems:
  • AcceptReplacementCharacters
  • AccessLockForUncomRead
  • Auto Reparse
  • DisableAnyNOPT
  • CasePromotesToFloat
  • CenturyBreak
  • CorrectTimeStampHash
  • Date/Timestamp conversion
  • DateForm
  • DBSDiagFlags
  • DefaultCaseSpec
  • DisableMsgWaitBlock
  • DisableSI
  • DisableTDWMSessionRules
  • DisableUDTImplCastForSysFuncOp
  • Disable Non-Deterministic UDF or UDM as Primary Index Value
  • DisworkerFaultMode
  • EnableAPHResp
  • EnabNonTempoOp
  • ExpInsertOff
  • Export Width Table ID
  • ExternalAuthentication
  • FixSRandomRange
  • HashFuncDBC - This value must also be the same as the Unity HashFuncDBC setting
  • IdCol Batch Size
  • InclNTforGrntOrRevokAll
  • LimitInlistCVal
  • MaxDecimal
  • MaxJoinTables
  • MaxLoadTasks
  • MLoadDiscardDupRowUPI
  • NoCharTruncErrInUsing
  • OptCNFLimit
  • ORDER BY Resolution
  • PMPC_TimeoutSecs
  • PrimaryIndexDefault
  • RevertJoinPlanning
  • RollForwardLock
  • RoundHalfwayMagUp
  • ROWIDEnabled
  • RowSize32k
  • SAM Attributes Storage Preferences
  • SessionMode
  • SPUseSessionColl
  • System Time Zone Hour
  • System Time Zone Minute
  • Systems Time Zone String
  • Temporal Purchased
  • TemporalDMLFlags
  • TimeDateWZControl
  • UseRevisedHash
  • WhiteTreeValidator parameter value