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