17.10 - Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

Update Space presents a command-line environment that allows the entry of the UPDATE command, which has the following syntax.

UPDATE {
  { TEMPORARY | ALL } SPACE FOR { ALL DATABASES | dbname | ALL PROXYUSERS } |
  
  { SPOOL | PSPOOL } SPACE FOR { dbname | ALL PROXYUSERS }
} ;

Syntax Elements

TEMPORARY
Specifies to update only the temporary space.
ALL
Specifies to update all the space.
SPACE FOR
Specifies the name of the database(s) for which space is to be recalculated.
ALL DATABASES
Specifies all the databases in a system.
dbname
Specifies the name of a single database.
ALL PROXYUSERS
Specifies to update the specified space for all Trusted Sessions proxy users.
SPOOL
Specifies to update only the spool space.
Spool space can be calculated for a single database only.
PSPOOL
Specifies to update only the spool space that persists across restarts.