Property PermanentSpace

Namespace

YndigoBlue.Velocity.Data.Teradata

Assembly

YndigoBlue.Velocity.dll

PermanentSpace

Gets or sets the maximum permanent space in bytes allocated to a schema when it is created.

public int PermanentSpace { get; set; }

Property Value

int

Remarks

This value is used exclusively during schema creation (BuildSchema()), where it is passed as the PERM parameter in the Teradata CREATE DATABASE statement:

CREATE DATABASE {schemaname} FROM {connecteduser} AS PERM = {PermanentSpace}

The PERM value sets the maximum total disk space the new schema (database) is permitted to use across all of its tables. Space is sub-allocated from the connected user's own permanent space quota — ensure the connected user has sufficient quota available before creating schemas.

The default value of 100,000,000 bytes (100 MB) is suitable for small schemas. For production schemas with significant data volumes, increase this value to match your expected data size, including headroom for growth.

warning

If the connected user does not have enough permanent space quota to cover this value, BuildSchema() will fail with a Teradata "insufficient space" error. Verify the connected user's available quota with your DBA before creating schemas.