15.00 - ENABLE DBC LOGONS - 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

ENABLE DBC LOGONS

Purpose  

Allows only new DBC users to log on to the system.

Syntax  

Usage Notes  

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

  • Logons are enabled - The system is quiescent.
  • Logons are disabled - 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.

    New non-DBC users cannot log on to the system after the ENABLE DBC LOGONS command is executed.

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

    The ENABLE DBC LOGONS command 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 Chapter 7: “Control GDO Editor (ctl).”

    Example  

    The following example shows the current logon status is enabled for DBC users only. Non-DBC users cannot log on to the current system.

    enable dbc logons
     
    12/02/12 10:05:02 DBC Logons enabled.