Protect Transactions | Teradata Vantage - 17.00 - 17.05 - About Protecting Transactions by Reserving Cylinders for Perm Space - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

A transaction is aborted when it requires more space than is currently available for the requesting user. When you create a user or database, the system requests space on cylinders from the pool of free cylinders. To protect transactions, you can specify that a number of cylinders be reserved for transactions needing permanent space.

The number of free cylinders to keep in reserve for requests needing permanent space is determined by the File System field named “Cylinders Saved for PERM” in DBS Control (see “Cylinders Saved for PERM” in Teradata Vantage™ - Database Utilities , B035-1102 ). When a statement requires space, this field determines allocation as described in the following table.

IF the statement needs … AND there are… THEN the statement …
permanent space one or more free cylinders succeeds.
less than one free cylinder fails with a disk full error.
spool space more free cylinders than the amount specified in Cylinders Saved for PERM succeeds.
fewer free cylinders than the amount specified in Cylinders Saved for PERM fails with a disk full error.

This means that requests needing SPOOL space might fail more often than requests needing PERM space. This can be advantageous because failure of a request for spool space rarely involves a rollback.

To monitor and reallocate permanent disk space, you can use Teradata Viewpoint.