Skip to Content
Information
Limited support BMC 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 statistics

This topic shows a sample Tablespace Statistics panel, which is a high-level view of the statistics.

The following figure displays the last, previous, and first statistics from the DASD MANAGER PLUS statistics database for the specified table space. This panel also displays statistics that BMCSTATS generates and statistics that BMCCPRS adds to the DASD MANAGER PLUS database.

(BMC.DB2.SPE2110) Tablespace Statistics panel

DEJM --------------------- Tablespace Statistics ------------------------------
  COMMAND ===>                                                                   
                                                                                
  Tablespace Name: QZUDEF.QZUS01EF                         Partitions: 4         
  Tablespace type: L                Member Cluster: N      Tables. . : 1         
  Implicit . . ..: N                      MaxParts: 0      Segsize   : 0         
  Dssize . . . ..: 8388608                 PageNum: A                            
                                                                                
                                                                                
  ------------------------------------------------------------------------------
  |                  Last Run      |   Prev Run  %Change |    1st Run  %Change |
  | Active Pages :     246015      |     246015        0 |     246015        0 |
  |                                |                     |                     |
  | Space (Trks) :      54255      |      54255        0 |      54255        0 |
  | Reorgspace   :      40995      |      40995          |      40995          |
  |               2021-07-13-06.48 |  2021-07-13-03.10   | 2021-06-10-06.44.4  |
  ------------------------------------------------------------------------------
                                                                                
  Select additional panels to display and press Enter.                           
     Display Partition information?      Display Table information?              
     Graph Pages?                        Display Entry List?                     
Warning

Note

If BMCSTATS encounters negative data points, it will not display them in the page statistics graphs. Negative data points occur when BMCSTATS gathers selected partition statistics on a table space in which the Force rollup field is set to N (meaning the statistics are not rolled up for the entire table space).

To display table space statistics

Perform any of the following actions:

  • In the Display Partition information? field, type S (or type P at the COMMAND line) and press Enter to display table space partition statistics. The Tablespace Partition Selection panel appears for you to make a selection.

   (BMC.DB2.SPE2110) Tablespace Partition Selection panel

DEJM ---------------- TABLESPACE PARTITION SELECTION --------- Row 1 to 4 of 4  
 COMMAND ===>                                                  SCROLL ===> CSR   
                                                                                 
 Tablespace Name:   QZUDEF.QZUS01EF                 Last Run : 2021-07-13-06.48  
                                                                                 
 Type S in Act field to select for more detail.                                  
                                                                                 
Act                                                                              
   Part     Nactive/          Far/     Pct  Pct        Full/      Space/    Ext  
               Card          Near      Act  Drop      Dirty      Dssize          
 -------------------------------------------------------------------------------
      1       110061             0      96     0      110053       25020      1  
           10785220             0                         0     8388608          
                                                                                 
      2        97043             0      96     0       97036       20850      2  
            9509620             0                         0     8388608          
                                                                                 
      3        38641             0      96     0       38637        8340      2  
            3786472             0                         0     8388608          
                                                                                 
      4          270             0       0     0           0          45      1  
                  0             0                         0     8388608          
                                                                                 
 ******************************* Bottom of data ******************************** 
  • In the Graph Pages? field, type S (or type GP at the COMMAND line) and press Enter to display the page statistics graph.
  • In the Display Table information? field, type S (or type T at the COMMAND line) and press Enter to display the Table Statistics panel.
  • In the Display Entry List? field, type S (or type L at the COMMAND line) and press Enter to list statistics for dates other than those shown.

The Tablespace Statistics List panel appears.

Tips for analyzing table space statistics

The following tips can help you analyze table space statistics:

  • Compare the Space and Regspace values. If the Reorgspace value is a small fraction of the Space value, you might recover a large percentage of space by reorganizing the table space.
  • Display the Pages Graph to see the relationship over time between active pages, allocated pages, and the pages required if you reorganized the table space. Reorganization restores PCTFREE and FREEPAGE, so the REORGED value might be more or less than the number of active pages. If the value is more than the allocated pages, a reorganization can cause one or more secondary extents to be allocated (unless you alter the space parameters first).

 

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

DASD MANAGER PLUS for DB2 12.1