Syntax Elements - 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™
- /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.