DISPLAY FORCE - 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 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 Database 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