16.10 - SYNCSCAN - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
featnum
B035-1180-161K

Purpose

The SYNCSCAN command shows all currently running scans on an AMP that are eligible for the synchronized full-file scan feature.

Syntax

The online help lists the display options (/S, /M, /L) as /dispopt. You can type the options at the beginning or end of the command.


/S
Displays global information and a one-line summary for each eligible subtable.
/M
Same as /S, but also displays the process IDs of the tasks scanning each subtable.
/L
Displays global information and detailed information for each task scanning each subtable.
tid
The subtable of interest. For more information on tid formatting, see Specifying a Subtable Identifier (tid).