BMC Software, Inc., Confidential and Proprietary Information
8-2 Administrative Products for DB2 Installation Guide
Overview
Overview
This chapter provides information about how to prepare to install the BMC
Software DASD MANAGER PLUS for DB2 product. The DASD
MANAGER PLUS product is a comprehensive database management tool
that supports DB2 Version 3.1 and later.
DASD MANAGER PLUS
• gathers, stores, and analyzes statistics in a production environment
• monitors changes in the database
• automates utility execution based on the condition of the data
• estimates space requirements
• features support for DB2 Version 5.1
• produces numerous analytical and statistical reports on DB2 objects
DASD MANAGER PLUS gathers and analyzes statistics with BMCSTATS,
which collects all the statistics collected by RUNSTATS and STOSPACE
,
plus many others that can be helpful in administering a database. The
statistics that BMCSTATS collects are maintained in a historical database in
which each entry is time-stamped. The historical database makes possible
trend analysis of DB2 object activity. If installed, the LOADPLUS or
REORG PLUS utilities can also provide statistics to the BMCSTATS
database.
DASD MANAGER PLUS automates utility execution through
BMCTRIG, an
analysis tool that examines the BMCSTATS database for almost two dozen
exception conditions, such as number of extents. When conditions reach or
exceed the trigger values that you specify, DASD MANAGER PLUS can
automatically build and submit the appropriate utility job to correct the
condition.
BMCTRIG lets you generate worklist JCL or standard JCL with its
flexibility, familiarity, and easy restarts.
The Space Estimation function simulates changes to the database, so that you
can predict the effect of changes to such things as page size, segment size,
primary and secondary allocations, number of rows, index type, and average
row length.
DASD MANAGER PLUS exploits the advantages of DB2 Version 4.1 and
later:
• type 2 indexes
• data sharing across DB2 subsystems
• partition independence for DB2 utilities
• faster LOAD, REORG, and RUNSTATS
• online REORG
• improved queries
