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.

DB2 table space statistics

The Tablespace Statistics Browse panel displays the DB2 catalog and BMC Software statistics for the specified table space.

After viewing the table space statistics in the Tablespace Statistics Browse panel (see below), you can display statistics for a particular table.

The product obtains the DB2 catalog value from the SYSIBM.SYSTABLESPACE catalog table. The BMCSTATS value comes from the corresponding statistics table in the DASD MANAGER PLUS database and shows the value from the last run.

Tablespace Statistics Browse panel

 ASUCTSPB ------------- Tablespace Statistics Browse --------------------------
COMMAND ===>                                                                  
                                                                             
Tablespace Name: QZUDAC.QZUS01AC    Type    :       Partitions: 4             
                                    Clone   : N     Tables. . : 1             
                                    MaxParts: 0     Segsize   : 0             
                              Member Cluster: N     Implicit  : N             
                                                                             
----------------------------------------------------                          
|              DB2 Catalog    |      BMCSTATS      |                          
| Nactive:           23220    |          23220     |                          
|            yyyy-11-15-10.47 |   yyyy-12-23-12.54 |                          
----------------------------------------------------                          
                                                                             
Select additional panels to display and press Enter.                          
  Display Table statistics?    Display Partition Statistics?

 

To display updatable table statistics from the Display Table Statistics? field

In the Display Table Statistics? field, type S and press Enter.

To display table statistics

Use one of the following methods:

  • In the Display Table Statistics? field, type S and press Enter.
  • On the COMMAND line, type T and press Enter.
  • From the Object Selection List panel, type B in the Act field next to the table name.

To display table partition statistics

You can use either of the following methods:

  • In the Display Partition Statistics? field, type S and press Enter.
  • On the COMMAND line, type P and press Enter.

 

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

DASD MANAGER PLUS for DB2 12.1