16.20 - Setting Session Mode - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Node Software Migration Guide

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Administration
Configuration
Installation
featnum
B035-5942-162K
Set the session mode to Teradata mode for the rest of the migration.
  1. Start the DBS Control utility from the system console command line or from the Database Window console utility.
    • At the console command line enter dbscontrol.
    • In the Supervisor window command line, enter start dbscontrol
  2. At the DBS Control command line, enter display general to display the General settings. Check the setting for field 8, SessionMode. If it is set to 0 (Teradata mode) you do not need to change the setting. If it is set to 1 (ANSI mode) continue to change the setting.
  3. Enter modify general 8=0 to set the SessionMode field to Teradata mode.
  4. Enter w or write to save the configuration change.
  5. Enter quit to exit the DBS Control utility.