17.10 - Syntax Elements - 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)
/Y
Prevents Ferret from displaying a confirmation message.
/S
Scans the MI and WMI.
/M
Scans the MI, CIs, WMI, and WCIs.
/L
Scans the MI, CIs, DBs, WMI, WCIs, and WDBs.
CI
Scans the MI and CIs. If the scope is AMP or all subtables, rather than selected subtables, the free CIs are also scanned.
DB
Scans the MI, CIs, and DBs. This is the default for the normal file system, which can be overridden by the CI, MI, or FREECIS options. If the scope is AMP or all subtables, rather than selected subtables, the free CIs are also scanned.
FREECIS
Scans CIs of cylinders that the allocation map indicates are free. Reports any cylinder for which the CI does not also indicate that the cylinder is free.
MI
Scans the MI only.
WCI
Scans the WMI and WCIs.
WDB
Scans the WMI, WCIs, and WDBs. This is the default for the WAL log, which can be overridden by the WCI or WMI options.
WMI
Scans the WMI only.
SKIPDECOMPRESS
SKIPDECOMP
Prevents SCANDISK from uncompressing block-level compressed data blocks. This skips some validation checks, but can speed SCANDISK when there are many compressed data blocks in the system.
WITHSPOOL
Causes scandisk to check all spool data in addition to checking non-spool data.
If WITHSPOOL is not specified, only the first few spool cylinders are checked. If the scope of the command is limited to the MI, the entire MI is always scanned including non-spool and spool data.
inquire_opt
Displays the lowest tid and rowid being scanned among the AMPS involved. This option also reports SCANDISK progress as a percentage of total time to completion and displays the errors encountered so far.
NOCR
Specifies to use regular data block preloads instead of cylinder reads. This is the default.
CR
Specifies to use cylinder reads instead of regular data block preloads.
MAXERRCNT n
MAXERR n
Specifies the maximum number of errors SCANDISK should show per subtable per vproc. SCANDISK stops when it finds the specified number of errors. Use this setting to reduce the SCANDISK running time when there are an excessive number of errors reported.
NONE
Specifies that only one INQUIRE request is sent for the SCANDISK job.
number
An integer that defines the time interval to send to an INQUIRE request to display SCANDISK progress.
timeopt
One of the following:
  • SECONDS, SECOND, SECON, SECO, SECS, SEC, S
  • MINUTES, MINUTE, MINUT, MINU, MINS, MIN, M
  • HOURS, HOUR, HOU, HO, HRS, HR, H
  • DAYS, DAY, DA, D
For example, this command starts a SCANDISK job that reports SCANDISK progress every five minutes:
scandisk inquire 5 m
The default is SECONDS.
The maximum time interval allowed is seven days.