16.10 - Standard Filer Startup Syntax - Teradata Database

Teradata Database Support Utilities

Teradata Database
June 2017
Start Filer from the Supervisor window of Database Window (DBW). Use the DBW START command. For more information on the options available with the start command, see the “Database Window (xdbw)” chapter in Utilities.

Syntax Element Description
-l Starts Filer with file system locking disabled.

Use this option to avoid hang or deadlock situations caused by lock conflicts. Because the file system locking protocols are not observed, Filer may see inconsistent information.

This option should be used only when Teradata Database is in the Debug-Stop state. Use of the -l option at other times can cause a database reset.

-i Same as the -l option.
-v Starts Filer on a single vproc. This is known as running Filer in vproc-specific mode or local mode.

If the -v vproc option of the DBW START command is specified together with the -v option of Filer, Filer is started on the vproc identified by vproc, otherwise, Filer is started on the control vproc, normally the AMP that is running with the lowest vproc number. For more information on DBW commands and options, see the “Database Window (xdbw)” chapter in Utilities.

The SCOPE and VPROC commands are not allowed when Filer is run in vproc-specific mode. For more information, see SCOPE (or VPROC).
-m [percent] Causes the Teradata Database file system to allocate a percentage of available memory for Filer to use for output buffers. This can help prevent Filer from running out of buffer space when running commands that generate large amounts of output.

percent specifies the percentage of memory per AMP that the file system allocates for Filer. The valid range is from 1 through 75%. If -m is used without a percent specification, 25% of available memory is allocated.

-h Displays the online help for Filer.
? Displays the online help for Filer.

Usage Notes

Teradata Database and the Teradata Database File System need not be running when Filer is started.

Do not leave Filer running unattended because locks on segments (if any exist) could block other tasks. Either quit Filer, or use the DROP command to release these locks.

Running Filer from the System Debugger and Coroner

The System Debugger and Coroner are used by qualified personnel to analyze and repair serious system problems. Filer can be run from within System Debugger and Coroner.

  • When run from System Debugger, Filer does not observe file system locking protocols. Because these protocols are normally used to avoid hang or deadlock situations, and to prevent access to file system segments that are in use by other processes, improper use of Filer from the System Debugger can result in file system corruption.
  • When run from Coroner, Filer presents a subset of the normal Filer commands that are suitable to working with crashdump data. The Filer HELP command displays the Filer commands that are available in the current context within which Filer is running.