SESSION KILL - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Requests termination of the specified session.

Syntax

SESSION KILL unitysessionid ;

Parameters

unitysessionid
Specifies the session ID for termination.

Usage Considerations

For sessions associated with managed routing rules, this command does not abort in-flight requests. If there is an in-flight request, the session kill occurs once the current request is complete. Session kill commands are tracked in the audit log.

For sessions associated with passive routing rules, the command issues an async abort if there is an in-flight request. The session is closed when the current running query (if any) returns.

Example

SESSION KILL 1001;