15.10 - SHOWWHERE - Teradata Database

Teradata Database Teradata Virtual Storage

prodname
Teradata Database
vrm_release
15.10
category
Configuration
featnum
B035-1179-151K

The SHOWWHERE command displays information about cylinder allocation and temperature. This command is available only if temperature-based block-level compression (TBBLC) is enabled.

Note: The CreateFsysInfoTable and PopulateFsysInfoTable macros provide a way to generate SHOWWHERE-like file system information to an SQL table. For more information, see SQL Functions, Operators, Expressions, and Predicates.

where:

 

Syntax Element

Description

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

Display output is limited to cylinders in the current SCOPE. If no scope has been specified, SHOWWHERE shows information for all cylinders. For more information, see SCOPE.

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

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)