17.10 - ABORTING - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

The ABORTING state indicates that the session is aborting its latest request.

The ABORTING state display is shown below.

State Details : ABORTING

Statements Code Time     CPU Usage Accesses
---------- ---- -------- --------- --------
         1 1043 14:22:09         2       22

The columns on the ABORTING state display provide the following information.

The column named... Contains the...
Statements statements, up to the number displayed, that are aborting.
Code error that caused the abort.
Time time that the abort step was sent to the AMP.
CPU Usage accumulated time in thousandths of a second that all AMPs spent processing the current request.
Accesses total number of segment access calls executed on all AMPs for the session request.