SHOWWHERE Example - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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)