16.10 - ENABLE LOGONS/ ENABLE ALL LOGONS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Allows any new users to log on to the system.

Syntax



Usage Notes

ENABLE LOGONS and ENABLE ALL LOGONS are synonymous.

To use this command, the current logon state must be one of the following:

  • Logons are disabled - The system is quiescent.
  • Only user DBC logons are enabled - The system is quiescent.

To see the current logon state, use one of the following commands:

  • from DBW: QUERY STATE
  • from a Teradata Command Prompt: pdestate -a

Teradata Database must be running for the change to be applied. A database restart is not required for the new setting to take effect.

Users logged on to the system before ENABLE LOGONS or ENABLE ALL LOGONS is executed remain logged on, and their jobs continue to run. All sessions are reconnected if the system is restarted.

Both commands (ENABLE LOGONS or ENABLE ALL LOGONS) update the Start With Logons value in the PDE Control GDO, which is viewable using the Control GDO Editor (ctl) utility. For more information, see Control GDO Editor (ctl).

Example: Enabling all logons

The following example shows the current logon status is enabled for new users.

enable logons

12/02/12 10:04:29 Logons enabled.