17.10 - DISPLAY DISCONNECT - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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