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.

Accessing the statistics display features

DASD MANAGER PLUS provides a variety of options for collecting and managing statistics on your DB2 objects.

DB2 uses object statistics to determine the optimal path to the data. As the volume of data increases and approaches system limits, structural inefficiencies become apparent. For example, backup and recovery windows might shrink, and the performance of your applications and systems might degrade. Systems administrators need statistical information to plan changes that support application growth and activity.

Note

When DASD MANAGER PLUS executes SQL that uses an ORDER BY clause against the DB2 catalog, the query uses a Unicode collating sequence to sort data and typically uses the same sequence to display the data on panels and in reports. However, when DASD MANAGER PLUS sorts the data retrieved from the DB2 Catalog queries, the product displays sorted data on panels and in reports in an EBCDIC collating sequence.

To access the statistics display features

  1. On the DASD MANAGER PLUS Main Menu, select Statistics and press Enter.

    The Collect and Manage Statistics panel appears.

    DEAE ---------------------- Collect and Manage Statistics ---------------------
    Command ===>                                                                   
                                                                                  
    DASD provides the ability to collect, copy and list statistics.                
    Space Estimation is available when listing statistics.                         
                                                                                  
    Select an option. Then press Enter.                                            
       1. List BMC and DB2 Statistics                                              
       2. Manage existing BMCSTATS, BMCCPRS and BMCUPRS Service Actions            
       3. Create BMCSTATS Service Action to collect statistics                     
       4. Create BMCCPRS Service Action to copy DB2 Catalog to BMC stats database  
       5. Create BMCUPRS Service Action to copy BMC Stats database to DB2 Catalog

  2. On the Collect and Manage Statistics panel, select List BMC and DB2 Statistics and press Enter.

    The Display DB2 Object Selection panel is displayed.

    DECA -------------------------- DB2 Object Selection --------------------------
    COMMAND ===>                                                                  
                                                                                  
    Specify the object type(s) to be included in a list, then press Enter.
    Specify either an object name or a pattern.                           
                                                                         
      Database . . . . QZUD44%                                 (DB     Name)
      Tablespace . . .                                         (DB.TS  Name)
      Table. . . . . .                                         (Own.TB Name)
      Index. . . . . .                                         (Own.IX Name)
      Stogroup . . . .                                         (SG     Name)
      Volume . . . . .                                         (VL     Name)

You can specify the objects to include in a list on the DB2 Object Selection panel. You initiate most of the DASD MANAGER PLUS statistics display functions from the Display DB2 Object List. You can run many of the statistics functions interactively or in batch.

 

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