Step 2e - Set General Options - Teradata Administrator

Teradata Administrator User Guide

Teradata Administrator
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Use the following procedure to set the general options.

1 From the main window, click Tools > Options.

2 Click the General tab.

3 Set your general preferences by choosing the following:

  • Show Toolbar – Displays the two tool bars on the Teradata Administrator window. The tool bar displays can be enabled and disabled for the current session by using the ToolBar selection on the View menu.
  • Show Status Bar – Displays the status bar on the Teradata Administrator window. The status bar display can be enabled and disabled for the current session by using the Status Bar selection on the View menu.
  • Define KB, MB, GB as multiples of 1000, instead of 1024 – Specify the way the terms KB, MB, and GB are interpreted when working in Teradata Administrator.
  • Save the SQL History to a file at program termination – Automatically saves the contents of the SQL history file whenever the Teradata Administrator application is terminated.
  • The data is saved to a file named TAdm_YYYYMMDD.log where YYYYMMDD represents the current date. When running Teradata Administrator multiple times on the same day, the data is appended to the existing file.

    By default, the file is stored in your Windows personal directory under Teradata\Teradata Manager\Data. To change the location where the file is stored by, see “Step 2f - Set the Data Directory” on page 39.

  • Use only the X views (See help file) – Select if your user id has access to only the X views of the Teradata data dictionary. These views restrict your access to only your owned or controlled objects.
  • Notice:

    When this option is selected, database performance is impacted. X views are slower than the corresponding regular views.

    After selecting this option, restart Teradata Administrator. Before X views are used, the DBA must execute the XViews.sql script located in the \sql directory of the installation directory. This creates additional dictionary views in the DBC database. The DBA who is setting up the access rights to X views should read the setup.sql file also located in the \sql directory.

    Note: When this option is selected, creating and administering UDT functions are not available.

  • Use SQL Assistant instead of the Administrator Query window – Select to run the queries using Teradata SQL Assistant, leaving Teradata Administrator free to do other work.
  • Note: This option is only available if Teradata SQL Assistant is installed on your system. The initial display of Teradata SQL Assistant takes a few moments. However, after it is loaded, it operates with the same speed as the Teradata Administrator Query window.

    4 Continue setting operational preferences using “Step 2f - Set the Data Directory” on page 39, or click OK to save your changes and exit the dialog box.