16.10 - SHOWSPACE - 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 SHOWSPACE command shows storage space utilization. It displays the following information based on the defined scope. For more information, see SCOPE.

  • Number of cylinders allocated for permanent, journal, temporary, spool, DEPOT, and WAL log data.
  • Average utilization per cylinder for permanent, journal, temporary, DEPOT, and spool cylinders.
  • Number and percentage of available free cylinders.

Syntax



/S, /M, /L
Displays a one-line summary for each AMP as defined by the SCOPE command.
Using any of the display options with SHOWSPACE is equivalent to issuing the command with no display options.

Usage Notes

Although disk space allocated for TJ and WAL records is charged against the table 0 26, no actual TJ or WAL records are found in the subtables of this table. Instead, these records are in the WAL log. The only row that exists in any subtable of the table 0, 26 is the table header in subtable 0.

Example: Using SHOWSPACE to display storage space utilization

The following output is from a large cylinder system.

Ferret  ==>
showspace

   SHOWSPACE  results for Each AMP     
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+
                | Perm Data Cyls  |  Wal Cyls  | Depot Cyls |   Spool Cyls    |    Temp Cyls    |    Jrnl Cyls    |  Pspool Cyls    | Free Cyls  |
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+
                |Avg  % of        |% of        |Avg         |Avg  % of        |Avg  % of        |Avg  % of        |% of             |% of        |
           total|utl  total       |total       |utl         |utl  total       |utl  total       |utl  total       |total            |total       |
Vproc      Avail|per  Avail       |Avail       |per         |per  Avail       |per  Avail       |per  Avail       |Avail            |Avail       |
Num   DSU   Cyls|Cyl  Space  #Cyl |Space  #Cyl |Cyl    #Cyl |Cyl  Space  #Cyl |Cyl  Space  #Cyl |Cyl  Space  #Cyl |Cyl Space  #Cyl  |Space  #Cyl |
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+
   0      10810 | 79%  10%    179*|  0%      6 |  0%      2*|  0%   0%      4*|  0%   0%      1*|  0%   0%      1*|  0%   0%        | 90%   9697 |
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+
   1      10810 | 78%  10%    181*|  0%      5 |  0%      2*|  0%   0%      4*|  0%   0%      1*|  0%   0%      1*|  0%   0%        | 90%   9686 |
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+
 
 
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+
TOTAL     21620 |             360*|         11*|          4*|               8*|               2*|               2*|               1*|      19383 |
                +-----------------+------------+------------+-----------------+-----------------+-----------------+-----------------+------------+

Average Free Cylinders Across All AMPs in the Current Scope:   90%

* Reported in units of Large Cylinders
  (A Large Cylinder is 6 times the size of a small cylinder)