17.05 - Space Accounting Columns for ResUsageSawt Table - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

Previously, the Teradata Database accounting system assumed an even distribution of rows to AMPs. The database and user space limits were set at the AMP level to the defined maximum limit values divided by the number of AMPs in the system. Space was managed and monitored at the AMP level.

Some features now allow tables on subsets of AMPs. The space accounting and space management infrastructure now manages the space limits at a global or system level and augments the AMP-level space management. These enhancements are referred to as global space accounting.

These columns report statistics for space accounting.

Column Name Mode Description Data Type
SpaceReactiveCnt track Number of AWTs waiting for space allocations as last tracked at the end of logging period. FLOAT
SpaceReactiveWaitTime count Total time in milliseconds that different worker tasks were in reactive mode waiting on space allocations during the logging period. FLOAT