16.10 - SHOWWHERE - 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

The SHOWWHERE command displays information about cylinder allocation and temperature. This command is available only if you have licensed Teradata Virtual Storage (TVS), or if you have enabled temperature-based block-level compression (TBBLC).

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 SQL Functions, Operators, Expressions, and Predicates.

Syntax



/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.

Example: Using SHOWWHERE to display cylinder allocation and temperature

Ferret  ==>
showwhere

SHOWWHERE result for Each AMP
           +---------------+------------+-----------------------+-------+
 Vproc     |     # of      |   Type     |        Temperature    |       |
 Num       |     Cyls      |            |  %HOT   %WARM   %COLD |   VH  |
           +---------------+------------+-------+-------+-------+-------+
           |          780* |       PERM |   40% |   39% |   22% |  100% |
           |           16  |        WAL |   31% |   56% |   13% |    0% |
           |           24  |      DEPOT |    4% |   46% |   50% |    0% |
           |          112  |   WAL POOL |   14% |   62% |   24% |    0% |
           |            8* |      SPOOL |   63% |   38% |    0% |    0% |
           |          136* | SPOOL POOL |   40% |   35% |   25% |    0% |
           |            8* |GLOBAL TEMP |    0% |    0% |  100% |    0% |
           |            8* |       JRNL |    0% |   25% |   75% |    0% |
           |            8* |     PSPOOL |    0% |    0% |  100% |    0% |
           +---------------+------------+-------+-------+-------+-------+
 TOTAL     |         5840  |            |   38% |   38% |   24% |   80% |
           +---------------+------------+-------+-------+-------+-------+
* Reported in units of Large Cylinders
  (A Large Cylinder is 6 times the size of a small cylinder)