15.00 - SYNCSCAN - Teradata Database

Teradata Database Support Utilities

prodname
Teradata Database
vrm_release
15.00
category
Configuration
featnum
B035-1180-015K

SYNCSCAN

Purpose  

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

Syntax  

Note: 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.

 

Syntax Element

Description

/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 “Subtable Identifiers (tids)” on page 79.