Step 2e - Set General Options
Use the following procedure to set the general options.
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:
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.
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.
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.