15.00 - DISPLAY FORCE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DISPLAY FORCE

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” on page 664.

    Example  

    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