Connecting to the Database - Teradata Workload Analyzer

Teradata Workload Analyzer User Guide

Product
Teradata Workload Analyzer
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2514
lifecycle
previous
Product Category
Teradata Tools and Utilities

Connecting to the Database

Before working with Teradata WA, a connection to the Teradata Database as user tdwm must be established. No local mode is available.

Note: User tdwm must be created before continuing. Create this user by running a DIP script. For more information about DIP scripts, see Utilities: Volume 1 (A-K) (B035‑1102).

To connect to the Teradata Database as user tdwm

1 Open the Connect to Teradata Database dialog box by doing one of the following:

  • Click on the Teradata Workload Analyzer window toolbar.
  • Select File > Connect.
  • Press Ctrl+L.
  • 2 In the Connect to Teradata Database dialog box, enter the database connection parameters. See Table 1.

     

    Table 1: Connect to Teradata Database dialog box 

    Option

    Description

    System (DBS) Name

    Name of the database to connect to; Teradata WA uses this to store workload definitions and related data.

    User Name

    Teradata WA requires the user to log on as user tdwm. The name in this field cannot be edited.

    Password

    Password associated with the user tdwm.

    Note: The default password for this user is tdwmadmin. To change this password, use the MODIFY USER statement. For information about using this statement, see Database Administration (B035‑1093).

    Session Character Set

    This option is not available. A DIP script creates a default character session set [ASCII for standard, KAJISJIS_0S for Kanji-enabled systems (Japanese)].

    By default, a UTF-16 character set is displayed.

    For more information about DIP scripts, see Utilities: Volume 1 (A-K) (B035‑1102).

    3 [Optional] Click More to reveal advanced login options. See Table 2.

     

    Table 2: Connect to Teradata Database dialog box Advanced Options 

    Option

    Description

    Authentication Mechanism

    Select the authentication mechanism value in the list box.

    Authentication Parameter

    Type the appropriate authentication parameter for the selected authentication mechanism.

    Default Database

    Select the default database used, if any.

    Account String

    Select the account string, if any.

    4 Click OK.

    When connected, the Teradata Workload Analyzer window displays the following:

  • In the lower left corner of the window: Ready
  • In the lower right corner of the window: Logged on to database_name as user_name.
  • To disconnect from the database

    ✔ Disconnect from the database by doing one of the following:

  • Click on the Teradata Workload Analyzer window toolbar.
  • Click File > Disconnect.
  • Press CTRL+G.