17.00 - ExceptionValue Column - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

These values show up as an integer. A conversion to hex extracts the bit values. For example, a value of 1024 converted to hex is 400.

Value Description
0x00000001 Exception time limit exceeded
0x00000002 CPU time (AMP and PE) limit exceeded
0x00000004 Blocked time limit exceeded
0x00000008 Disk to CPU ratio exceeded
0x00000010 AMP CPU skew limit exceeded
0x00000020 AMP I/O count limit exceeded
0x00000040 AMP I/O skew limit exceeded
0x00000080 Max row count (for a step) exceeded
0x00000100 Max row count (for a query) exceeded
0x00000200 Spool space limit exceeded
0x00000400 Number of AMPS used in query exceeded
0x00000800 Disk CPU ratio value exceeded
0x00001000 I/O space value exceeded