15.00 - LOGON - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

LOGON

Purpose  

The LOGON command establishes a Teradata Database session.

Syntax

Batch Mode

Interactive Mode

 

Syntax element …

Is the …

tdpid

identifier which is associated with a particular Teradata Database.

The default identifier is TDP0.

username

ID of the user on the corresponding Teradata Database.

The maximum length of username is 30 characters.

password

password associated with the username.

The maximum length of a password is 30 characters.

Note: In interactive mode, the password is accepted on the next line in a protected area.

acctid

account identifier associated with the username. The acctid can contain up to 30 characters.

Each doubled apostrophe, if any, counts as one character of the 30 characters.

Note: This describes the standard TD 2 (Teradata authentication) logon format. For more information about other logon formats and types of authentication see Security Administration.

Usage Notes  

The LOGON command is the first command you type in a dul session. The command establishes a session on a Teradata Database and identifies you and the account that is charged for system resources used during a dul operation. To ensure system security, the password is not displayed when dul is used interactively.

You must have CREATE, DROP, and SELECT privileges on DBC.SW_EVENT_LOG for Teradata Database, as well as on the dump table on the Teradata Database, to perform a load or unload operation.

After you log onto the Teradata Database, dul changes the default database to Crashdumps. The Crashdumps database is where the Teradata Database initially saves a dump. However, you can change the default database with the DATABASE command.

For additional information on granting privileges, see Database Administration. For more information on the Crashdumps database, see “DATABASE” on page 508.

Logon with Teradata Wallet

Teradata Wallet is a secure store for client credentials. It stores passwords for Teradata Database authentication, which can automatically be retrieved at run time and submitted to the database. Teradata Wallet must be configured with usernames and passwords before it can be used for logons using DUL and DULTAPE. For more information on configuring Teradata Wallet, see Security Administration.

Example - Batch Mode

To log onto a Teradata Database with a tdpid of TDP0, a username of Admin, and a password of abc, type the following:

LOGON TDP0/Admin,abc ; 

The following appears:

*** Logon successfully completed.
*** Teradata Database Release is 14.00.00
*** Teradata Database Version is 14.00.00
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.
*** Changing current database to crashdumps.
*** New default database accepted.
*** File Compression Enabled.
*** MultiFile option ON.
*** NoSpool option OFF.

Example - Interactive Mode

To log onto a Teradata Database with a tpid of crashdumps, a username of crashdumps, and a password of crashdumps, type the following:

1 Type your logon and press Enter. For example:

.logon crashdumps

Your logon is repeated, and you are prompted for your password:

.logon crashdumps
Password:

2 Type your password and press Enter. For example:

crashdumps

Your password will not appear on screen.

The following appears:

*** Logon successfully completed.
*** Teradata Database Release is 14.00.00
*** Teradata Database Version is 14.00.00
*** Transaction Semantics are BTET.
*** Character Set Name is 'ASCII'.
*** Changing current database to crashdumps.
*** New default database accepted.
*** File Compression Enabled.
*** MultiFile option ON.
*** NoSpool option OFF.
Dump Unload/Load to Tape - Enter your command: