SHOWWHERE Command | Troubleshooting Teradata Virtual Storage | Teradata Vantage - 17.00 - 17.05 - SHOWWHERE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Teradata® Virtual Storage

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Configuration
Publication ID
B035-1179-170K
Language
English (United States)

Purpose

The SHOWWHERE command displays information about cylinder allocation and temperature.

The CreateFsysInfoTable and PopulateFsysInfoTable macros provide a way to generate SHOWWHERE-like file system information to an SQL table. The tdheatmap table function provides a frequency-of-access report for database objects on a per-AMP basis. For more information, see "File System Information Macros and Functions" in Teradata Vantage™ - SQL Operators and User-Defined Functions, B035-1210.

Syntax

{ SHOWWHERE | SHOWW } [ /S | /M | /L ]
/S
Displays a summary listing of the cylinders showing one line for every cylinder type .
This is the default.
/M
Displays a medium length listing of the cylinders with one line for every cylinder type per AMP (vproc).
/L
Displays a long listing of the cylinders with one line for every cylinder type per AMP (vproc) per storage device.

Usage Notes

Display output is limited to cylinders in the current scope (one or more vprocs, tables, or the WAL log), defined with the SCOPE command. If no scope has been specified, SHOWWHERE shows information for all cylinders.

If temperature information is not available for the current scope, SHOWWHERE returns an error.