Previously, the Teradata 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 |
---|---|---|---|
SpaceProactiveAllocs | count | Total number of proactive allocations made in the AMP during the logging period. This field is populated by the spalocal task. | FLOAT |
SpaceGroupAllocs | count | Total number of group allocations initiated in the AMP during the logging period. This field is populated by the spaglobal task. | FLOAT |
SpaceMsgsCnt | count | Total number of allocations or de-allocation messages processed by the space accounting task managing the system limit for a database or user. This field is populated by the spaglobal task. | FLOAT |
SpaceAllocated | count | Total number of bytes of space allocated to the AMP. This field is populated by the spalocal task. | FLOAT |
SpaceDeallocated | count | Total number of bytes of space de-allocated from the AMP. This field is populated by the spalocal task. | FLOAT |