17.10 - DISPLAY FORCE - 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 FORCE command displays sessions that have been forced off by Gateway Global, Performance Monitoring and Production Control (PMPC), or a security violation.

Syntax

{ DISPLAY | DI } { FORCE | FO }

Usage Notes

The Teradata system displays this information:
  • Host group number
  • Number of sessions
  • Session ID number
  • User name associated with the session
  • The length of time before the session information is discarded

The gateway retains the session information for the standard timeout period after the client has been logged off. The gateway returns an 8055 error when the client reconnects:

Session forced off by PMPC or gtwglobal

After the timeout period expires, the gateway discards the session information.

Before using the DISPLAY FORCE 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 sessions that have been killed or aborted

To display a session that has been killed or aborted, type:

DI FO

The following appears.

Host Group 1 has 2 forced sessions

Session User TimeToLive
1002    DBC  916 secs
1004    DBC  922 secs