16.10 - SHOWDEFAULTS - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

Shows the default settings and the current context. The command displays the current default radix for input and output, the current input, output, and error file names, and the SCOPE defined. SHOWDEFAULTS also displays WAL log context information.

Syntax



/L
When the SCOPE is set to a table that uses a sparse map, /L displays the complete list of AMP vprocs in the sparse map.

Example: SHOWDEFAULTS output

Ferret ==> showd

The current setting of the Input Radix is Decimal
The current setting of the Output Radix is Decimal
Ferret is running with Script Mode -- Disabled

Scope for the Defrag command is :
   Invalid, because no tables or cylinders are specified
Scope for the Packdisk command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the Scandisk command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the Showblocks command is :
   Invalid because there are no tables or log records selected
Scope for the Showspace command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the ShowFSP command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the Showwhere command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the Showcylalloc command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the Force command is :
  MAP specification ignored as  Force command requires table-id in the command option 
Scope for the Showcompress command is :
  MAP td_map100 (vproc(s) 0-400, 801, 810, 820, 825...)
Scope for the [un]Compress command is :
    Ignores the MAP scope set by scope command