Turn off FallBackSetting in Teradata

Below are the steps to turn off FallBackSettings “ALWAYS FALLBACK” in Teradata Server on-Prem or cloud (AWS EC2 or Azure)

Login to Teradata NodeLogin to Teradata Node and run sudo su –

Run command dbscontrol from command prompt

In DBSControl window

Run “mod systemfe=T” (without double qoutes) and enter Y on prompt

Run “display internal” and note FallBackSetting parameter number

Run modify internal <FallBackSetting parameter number>=1

e.g. modify internal 113=1

Run “write“

Run “quit“

Restart database from command prompt:

/etc/init.d/tpa stop

/etc/init.d/tpa start