Skip to content

Turn off FallBackSetting in Teradata

Below are the steps to turn off FallBackSettings “ALWAYS FALLBACK” in Teradata Server on-Prem or cloud (Amazon 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 and enter Yon 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