Connect to a Teradata QS Server
Before scheduling SQL requests using the Teradata Query Scheduler Viewer, connect to a Teradata QS server.
To connect to a Teradata QS server
1 Click Command>Connect or click .
The Teradata Query Scheduler Connect dialog box appears.
2 Complete the options as follows:
|
Control/Option |
Description |
|
Database Name |
Enter the name of the Teradata Database to use for scheduled SQL requests. |
|
User Name |
Enter your user name associated with the Teradata Database entered in the Database Name box. |
|
Password |
Enter the password associated with the user name entered in the User Name box. |
|
Default Database |
[Optional] Usually, the DBA sets up a default database associated with your user name and password. However, the name of another database can be entered as the default database. |
|
Account String |
[Optional] Usually, the DBA sets up a logon account string associated with your user name and password. However, a different account string can be entered instead of using the default. |
|
Mechanism |
Select the appropriate authentication mechanism (for example, TD2) in this list box. The default is blank, representing the standard Teradata (TD2) mechanism. |
|
Parameter |
Type the authentication string to be used with the mechanism specified. If the specified mechanism does not require this string, leave this option empty. |
|
Server |
Displays the name of the Teradata QS server (read-only). |
3 Click OK.
Teradata QS validates the Teradata Database logon parameters and attempts to obtain information about active Teradata QS servers using a CLIv2 connection.
If an active server is found, a connection is established.
If a CLIv2 error occurs, Teradata QS attempts to establish a connection using the Teradata QS server name configured with the Teradata QS Operations tool. See “Managing the Teradata QS Server” on page 65 for details on configuring the Teradata QS server.
If this is unsuccessful, the Server box becomes available. Continue with step 4.
4 [Optional] Enter the name or IP address of the system the Teradata QS server is running on in the Server box.
The parameters are validated and the Teradata Query Scheduler Viewer opens.
If the Teradata QS server has not been started, a message appears stating the following:
There are currently no Scheduled Requests Servers active.
After opening the Teradata Query Scheduler Viewer and connecting to a Teradata QS server, it is ready for use. See Chapter 4: “Scheduling Requests” to learn about scheduling SQL requests.
See “Navigating the Teradata Query Scheduler Viewer” on page 29 to find out about the GUI. To find out how to set up the Teradata Query Scheduler Viewer, go to “Customizing the Teradata Query Scheduler Viewer” on page 35.
At any time disconnect and then reconnect as the same user or a different user. See “Disconnect from a Teradata QS Server and Exiting Teradata QS” on page 29 to learn how to disconnect.