15.00 - SHOWSPACE - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

SHOWSPACE

Purpose  

The SHOWSPACE command shows storage space utilization. It displays the following information based on the defined scope. For more information, see “SCOPE” on page 591.

  • 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  

     

    Syntax Element

    Description

    /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  

    The following output is from a small 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%        |9 0%   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)