15.10 - DiskSpaceErrorV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Accounting

DBC

 

View Column

Data Type

Format

Source Table.Column

Vproc

SMALLINT

NOT NULL

-(5)9

DatabaseSpace.Vproc

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

MaxPerm

FLOAT

NOT NULL

-,---,---,---,---,---,---,--9

DataBaseSpace.MaxPermSpace

CurrentPerm

FLOAT

NOT NULL

-,---,---,---,---,---,---,--9

DataBaseSpace.CurrentPermSpace

Use DBC.DiskSpaceErrorV to determine if any database has exceeded its maximum perm space. If so, you must manually adjust the maxperm space for those databases to prevent future database updates from exceeding the maximum and experiencing out of space errors.

Some applications (such as FastLoad, MultiLoad, and restore operations) may require more temporary space during processing.

Fields in DBS Control can be set to allow applications to exceed the maxperm space as long as there is physically enough disk space available. After the operation completes, reset the fields.

MaxPerm

The MaxPerm column specifies the amount of permanent space allocated to the database per AMP.

CurrentPerm

The CurrentPerm column value is the amount of permanent space currently being used by the database per AMP.

 

For more information on…

See…

Setting the DBS Control fields (OverflowMaxPermSpacePercentage and OverflowMaxPermSpaceKByteCount) to increase perm space

Utilities

Update Space utility

Utilities

Teradata Database space accounting

Database Administration