16.10 - DISPLAY FORCE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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



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

Host Group 1 has 2 forced sessions

Session User TimeToLive
1002    DBC  916 secs
1004    DBC  922 secs