Defining the Teradata QS Database Logon Parameters - Query Scheduler

Teradata Query Scheduler User Guide

Product
Query Scheduler
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2512
lifecycle
previous
Product Category
Teradata Tools and Utilities

Defining the Teradata QS Database Logon Parameters

Although the Teradata QS database password or the DBS Name can be viewed or modified, the Teradata QS database user name (tdwm) should not be changed. The DBS Name identifies the Teradata Database to which the server connects.

Changing the Teradata QS database password periodically provides additional security. If the password is changed, the Teradata QS database password must also be changed on the Teradata Database, and the Teradata QS Server must be restarted so it can detect the new password.

If any of these parameters are incorrect for your database, the Teradata QS Server will not start.

To define the Teradata QS database logon parameters

1 From the Teradata Query Scheduler Operations window, click Configuration>Server.

The Server Parameters dialog box appears.

2 Change the following options as desired:

 

Table 22: Server Parameters Dialog Box: Option and Control Descriptions 

Option/Control

Description

Database Name box

Specify the Teradata Database to connect to.

Note: There must be an entry in the HOSTS file on the server system that corresponds to the DBS name. This entry should have the form xxx.xx.xxx.xxx sssCOP1; where xxx.xx.xxx.xxx is the IP address and sss is the Teradata Database name. See Teradata Query Scheduler Administrator Guide (B035‑2511) for instructions.

User Name box

This is the user/database name of the Teradata QS database, created as tdwm. This box is unavailable and cannot be changed.

Password box

Specify the password of the Teradata QS database that is initialized to tdwm. If it is changed here, it must also be changed in the database itself or the Teradata QS server will not log on correctly. If the password is changed, a prompt appears to verify the change before it is saved.

Mechanism list box

Select the authentication mechanism (for example, TD2) used for logon. The default is blank, representing the standard Teradata (TD2) mechanism.

Parameter box

Specify the logon string for authentication under the specified mechanism. If the specified mechanism does not require this string, leave the box empty.

3 Continue with “Changing Server Configurations” on page 68 or click OK to close the Server Parameters dialog box.