SHOWWHEREの例 - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - データベース ユーティリティ

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
2019年3月
Language
日本語
Last Update
2019-10-29
dita:mapPath
ja-JP/qxr1512078764562.ditamap
dita:ditavalPath
ja-JP/qxr1512078764562.ditaval
dita:id
B035-1102
Product Category
Software
Teradata Vantage

例: SHOWWHEREの使用によるシリンダの割り当てと温度の表示

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)