Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see DASD MANAGER PLUS for DB2 13.1.

Table space partition statistics

This topic shows a sample Tablespace Partition Statistics panel, which is a more detailed view of the table space statistics.

The following figure displays the last, previous, and first statistics from the DASD MANAGER PLUS statistics database for the selected table space partition.

Note

A zero in the Partition field indicates that the table space is not partitioned.

Tablespace Partition Statistics panel

 DECA ---------------- Tablespace Partition Statistics -------------------------
COMMAND ===>                                                                  
                                                                             
Tablespace Name: CCBPART.TSPART          Pctfree : 99                          
Partition  . . : 1                       Freepage: 0        Volume  : DEV231   
Stogroup . . . : SYSDEFLT                                                      
------------------------------------------------------------------------------
|                Last Run        | Prev Run    %Change | 1st  Run    %Change |
| Active Pages :       540       |       540         0 |       540         0 |
| Pctactive    :         1       |         1           |         1           |
| Pctdrop  . . :         0       |         0           |         0           |
| Full  Pages  :         0       |         0         0 |         0         0 |
| Dirty Pages  :         0       |         0         0 |         0         0 |
| Space (Trks) :        45       |        45         0 |        45         0 |
| Extents  . . :         1       |         1         0 |         1         0 |
| Reorgspace   :        30       |        30           |        30           |
|               yyyy-08-23-13.57 |  yyyy-08-23-09.48   |  yyyy-06-11-13.24   |
------------------------------------------------------------------------------
Select additional panels to display and press Enter.                           
  More Part Stats       Graph Cardinality          Graph PageGroup Stats      
  Column Stats          Graph Pages                List Entries               
  Graph Extents         Graph PctActive/Drop       PageGroup Stats

To display tablespace partition statistics

Perform any of the following actions:

  • In the More Part Stats field, type S to display additional tablespace partition statistics (or type T at the COMMAND line) and press Enter.
  • In the Column Stats field, type S to display column statistics (or type C at the COMMAND line) and press Enter.
  • In the Graph Extents field, type S to display a graph of the extent statistics (or type GE at the COMMAND line) and press Enter.
  • In the Graph Cardinality field, type S to display a graph of the cardinality statistics (or type GC at the COMMAND line) and press Enter.
  • In the Graph Pages field, type S to display a graph of the page statistics (or type GP at the COMMAND line) and press Enter.
  • In the Graph PctActive/Drop field, type S to display a graph of the percentage of active and drop statistics (or type G% at the COMMAND line) and press Enter.
  • In the Graph PageGroup Stats field, type S to display a graph of the page group statistics (or type GG at the COMMAND line) and press Enter.
  • In the List Entries field, type S to display Tablespace Partition Statistics for dates other than those shown (or type L at the COMMAND line) and press Enter. The Tablespace Partition Statistics panel appears.
  • In the PageGroup Stats field, type S to display Tablespace Partition Pagegroup Statistics (or type G at the COMMAND line) and press Enter. The panel displays the statistics for the partition by page group for the last BMCSTATS execution on the object.

Related Topics

Table-statistics-for-a-partitioned-table-space

Tips-for-analyzing-table-space-partition-statistics



 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*