DISPLAY DISCONNECT - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

The DISPLAY DISCONNECT command returns a list of sessions that have disconnected and not yet reconnected.

Syntax

{ DISPLAY | DI } { DISCONNECT | DISC }

Usage Notes

The context for these sessions is maintained in the gateway control assign task. If the client associated with the session fails to reconnect in the time allotted, the session is logged off.

Before using the DISPLAY DISCONNECT command, you must select the host group from which the session is running using the SELECT HOST command. For information, see SELECT HOST.

Example: Displaying disconnected sessions

To display disconnected sessions, type:

di disc

The following report appears.

Host Group 52 has 5 disconnected sessions:

Session   PE           User      TimeToLive
1050      16383        DBC       1185 secs
1051      16383        DBC       1185 secs
1052      16383        DBC       1185 secs
1053      16383        DBC       1185 secs
1054      16383        DBC       1185 secs