15.00 - List of Commands - Teradata Database

Teradata Database Support Utilities

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

List of Commands

Filer presents a command-line environment that allows the entry of the following Filer commands, which are discussed in more detail in the sections that follow.

 

Command

Description

“ACCESS”

Accesses a specific copy of a CI or DB segment located on DISK, DRAM, or is the LATEST.

“ALTCI”

Makes the non-active CI copy the active copy, and the formerly active copy the non-active copy.

“ALTWCI”

Makes the non-active WCI copy the active copy, and the formerly active copy the non-active copy.

“ASSIGN”

Assigns a repaired cylinder back to a specified AMP and storage type. Normally used after a cylinder that is in the bad list or quarantine list has been repaired.

“BADLIST”

Displays list of bad cylinders, scans them for preliminary diagnosis, initializes and releases unrepairable cylinders back to storage.

“BLK”

Selects the segment that starts at the specified cylinder and sector number, determines the type of block, and displays it accordingly.

“CHECKSUM”

Validates, displays, and optionally repairs the checksum for a DB, WDB, CI, or WCI segment.

“CI”

Selects and displays the Cylinder Index (CI) segment for the specified cylinder.

“CID”

Selects and displays the Cylinder Index Descriptor (CID) for the specified cylinder.

“DATE/TIME”

Displays the current system day, date, and time.

“DB”

Selects and displays the Data Block (DB) segment that starts at the specified cylinder and sector number.

“DBD”

Displays the Data Block Descriptors (DBDs) of the current cylinder.

“DBROW”

Displays the physical rows of a DB.

“DELETE”

Deletes the currently selected object or range of objects, including all descendants and antecedents.

“DEPOT”

Displays cylinder summary information for cylinders in the Depot, or block summary information for blocks in a particular Depot cylinder.

“DISABLE”

Sets a specific flag in the file system to FALSE, disabling certain features of Filer. Most such flags are for internal use only.

“DISCARD”

Discards a rebuilt CI in memory without affecting the original CI.

“DISPLAY”

Shows a formatted display of the currently selected object or range of objects. If you specify an ordinalrange, then DISPLAY shows a related object or range.

“DROP”

Drops the access on the current object and returns to the default prompt.

“DUMPDISK”

Selects the disk segment that starts at the specified cylinder and sector number, determines the type of block, and displays it accordingly.

“ENABLE”

Sets a specific flag in the file system to TRUE, enabling certain features of Filer. Most such flags are for internal use only.

“ERRORS”

Redirects diagnostic messages to a file that you specify or to the default file, stderr.

“FIB”

Displays the File Information Block (FIB) and information about cylinder usage.

“FIND”

Given the table and optional ridrange, displays the cylinders containing the range.

“FREECACHE”

Displays the status of the free cylinder cache.

“HELP”

Provides context sensitive help for Filer commands.

“IDENT”

Identifies the objects in the specified sectors, and displays the properties of the objects.

“INFO”

Displays details of a rebuilt CI that is still in memory, not yet written to disk.

“INIT”

Initializes the current cylinder or range of cylinders to free.

“INPUT”

Directs Filer to read commands from a specified file rather than from the default input file, stdin.

“MEMBLK”

Accesses the file system segment at the specified memory address, determines the type of the segment, and returns a formatted display of the segment.

“MEMCTX”

Returns a formatted display of a file system context structure (ctxcontext_t) beginning at the specified memory address.

“MEMDB”

Returns a formatted display of a DB beginning at the specified memory address.

“MEMDUMP”

Dumps memory in the hexadecimal format, starting at the specified location for a specified length of bytes.

“MEMROW”

Formats a row beginning at the specified memory address.

“MEMSORCTX”

Returns a formatted display of a context structure (sorcontext_t) beginning at the specified memory address.

“MEMWCTX”

Returns a formatted display of a context structure (wtjcontext_t) beginning at the specified memory address.

“MEMWDB”

Returns a formatted display of a WDB beginning at the specified memory address.

“MEMWREC”

Formats a WAL log record beginning at the specified memory address.

“MI”

Selects and displays the Master Index (MI).

“MODIFY REDO”

Replays the specified WAL log records, or defines whether or not to replay the WAL log records during the next file system startup.

“NEXT”

Displays the next row, WAL log record, DB, WDB, DBD, WDBD, CI, WCI, CID, WCID or subtable.

“OUTPUT”

Redirects Filer output to a file you specify or to the default file, stdout.

“PACK”

Packs the segment to eliminate fragmentation.

“PATCH”

Modifies file system segments and other objects in memory.

“PREV”

Displays a previous row, WAL log record, DB, WDB, DBD, WDBD, CI, WCI, CID, WCID or subtable.

“PRIORITY”

Sets the priority class of the Filer process.

“QUARLIST”

Displays list of quarantined cylinders, scans them for preliminary diagnosis, initializes and releases unrepairable cylinders back to storage.

“QUIT”

Ends a Filer session.

“RADIX”

Sets the default radix (decimal or hexadecimal) used as the numeric base for Filer data input and output.

“REALLOCDUR”

Reallocates durable cylinders.

“REBUILDCI”

Rebuilds the cylinder index for a specified cylinder.

“REBUILDMAP”

Rebuilds the map of allocated cylinders.

“RENAME”

Renames the currently selected segment to the specified location on the disk.

“REPAIRSECTS”

Deletes specified overlapping data blocks from rebuilt CIs in memory.

“RESETFREECYL”

Resets the file system internal free cylinder count back to the correct value.

“ROW”

Displays physical rows from one or more subtables. For a single subtable, ROW sets the context to those rows.

“SCANDISK”

Verifies the integrity of the file system.

“SCOPE (or VPROC)”

Selects a set of vprocs that Filer will communicate with until Filer quits or a different set of vprocs is selected.

“SEGZERO (or SEG0)”

Selects and displays Segment Zero (0).

“SET FREECYL”

Sets the file system internal Free Cylinder count to the specified number.

“SHOWDEFAULTS”

Displays the default settings and the saved context.

“SRD”

Returns a formatted display of all the Subtable Descriptors (SRDs) on the current CI that have any rows from the specified subtable tid. If tid is not specified, then all SRDs are displayed.

“STAMP”

Takes five hexadecimal numbers and converts them to a file system timestamp.

“STORAGEINFO”

Displays per-AMP system control information for storage.

“SYNCSCAN”

Shows all currently running scans on an AMP that are eligible for the synchronized full file scan feature.

“TABLE”

Displays rows from the subtable specified by tid.

“TABLEID”

Displays the table number of a specified table.

“TRACEPRINT”

Dumps the internal trace buffer of the file system. The cylid limits the display to entries to that cylinder.

“TRASH”

Removes the FSG name of the copy of the currently selected segment in memory, and retains access to it.

“VPROC”

Selects a set of vprocs that Filer will communicate with until Filer quits or a different set of vprocs is selected.

“WABC”

Displays the WAL Append Buffer Control (WABC) structure.

“WAL”

Displays Write Ahead Logging (WAL) log records in an ordinal record number range, such as the 10th through the 20th WAL log records.

“WCI”

Selects and displays the WAL Cylinder Index (WCI).

“WCID”

Selects and displays the WAL Cylinder Index Descriptor (WCID) associated with the requested WAL log cylinder.

“WDB”

Selects and displays the WAL Data Block (WDB) segment that starts at the specified cylinder and sector number.

“WDBD”

Displays the WAL Data Block Descriptors (WDBDs) of a WAL log cylinder.

“WDBREC”

Displays WAL log records for a WDB.

“WFIND”

Displays the WAL log cylinders containing WAL log records in a given range, or if no range is specified, then all of the WAL log cylinders.

“WFLUSH”

Manually force some or all of the WAL log records in memory to disk.

“WMI”

Returns a formatted display of the WAL Master Index (WMI).

“WREC”

Displays the WAL log records within a given range and within the restrictions of the whereclause.

“WRITE”

Forces the currently selected segment to disk.

“WSUMMARY”

Retrieves table IDs from WAL records within a given WAL log sequence number (WLSN) range.