Usage Notes - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
xha1591998860283.ditamap
dita:ditavalPath
xha1591998860283.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

The following table shows how scopes are interpreted.

Scope Type Interpretation
Table Specified subtables, which can be selected subtables, all subtables, or classes.
Although disk space allocated for TJ and WAL records is charged against the table 0 26, no actual TJ or WAL records are found in the subtables of this table. Instead, these records are in the WAL log. The only row that exists in any subtable of the table 0, 26 is the table header in subtable 0.

Table scopes imply cylinder scopes, and all-table scopes imply free CIs.

Cylinder All the specified cylinders.

Cylinder scopes can be specified by implication as subtable scopes. For the DEFRAGMENT command, this means all cylinders containing the specified subtables. An explicit cylinder specification is only meaningful to the DEFRAGMENT command. If you specify a free cylinder in CYLINDER cylid, Ferret SCANDISK will respond with an indication that the cylinder did not need to be defragmented.

Vproc All subtables, all free CIs, and the WAL log.
Map The AMPs associated with the specified maps.
WAL The entire WAL log.
Although disk space allocated for TJ and WAL records is charged against the table 0 26, no actual TJ or WAL records are found in the subtables of this table. Instead, these records are in the WAL log. The only row that exists in any subtable of the table 0, 26 is the table header in subtable 0.

The Ferret commands utilize SCOPE as follows, where classes are collections of tables and result in Table on AMP scopes.

Command Description
DEFRAGMENT The command uses Table on AMP scopes, or Cylinder on AMP or MAP scopes.

The scope can contain tables only, both tables and vprocs or maps, or both vprocs/maps and cylinders. For more information, see DEFRAGMENT.

PACKDISK The command uses AMP scopes, or Table on AMP scopes.

The scope selected must include either vprocs/maps or tables, but not both. For more information, see PACKDISK.

SCANDISK The command uses AMP scopes, or Table on AMP scopes, and WAL scope.

The scope can contain tables only, vprocs/maps only, both tables and vprocs/maps, or the WAL log. For more information, see SCANDISK.

SHOWBLOCKS The command uses Table on AMP scopes and WAL scope.

The scope can contain tables only or the WAL log. For more information, see SHOWBLOCKS.

SHOWFSP The command uses AMP scopes, or Table on AMP scopes.

The scope can include one or more tables, one or more vprocs/maps, or the entire system. For more information, see SHOWFSP.

SHOWSPACE The command uses AMP scopes, or Table on AMP scopes, and WAL scope.
Although disk space allocated for TJ and WAL records is charged against the table 0 26, no actual TJ or WAL records are found in the subtables of this table. Instead, these records are in the WAL log. The only row that exists in any subtable of the table 0, 26 is the table header in subtable 0.

The scope can contain tables only, vprocs/maps only, both tables and vprocs/maps, or the WAL log. For more information, see SHOWSPACE.

All scopes are not applicable to all commands. When a command is executed and the scope is not applicable to the command, either the command is rejected or the inapplicable portions of the scope are ignored.

The SHOWDEFAULTS command displays the various components of a recorded scope, which are interpreted individually by each of the commands: COMPRESS, DEFRAGMENT, PACKDISK, SCANDISK, SHOWBLOCKS, SHOWCOMPRESS,SHOWCYLALLOC, SHOWFSP, SHOWSPACE, SHOWWHERE, and UNCOMPRESS.

The scopes appear in the SHOWDEFAULTS output as tables on vprocs, cylinders on vprocs, vprocs, maps, or the WAL log. For more information, see SHOWDEFAULTS.