ENABLE LOCAL DBC LOGONS - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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

Syntax

ENABLE LOCAL DBC LOGONS

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

Vantage 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 and non-local DBC users cannot log on to the system after the ENABLE LOCAL DBC LOGONS command is executed.

Users, other than the DBC, logged on to the system before the ENABLE LOCAL 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 LOCAL DBC LOGONS command updates 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).