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.