Quick reference of statistics-related tasks
The following table shows typical ways to use the statistics tasks:
Programs for collecting and updating statistics
To populate this database with statistics | Run these programs |
|---|---|
DASD MANAGER PLUS statistics database | BMCSTATS BMCCPRS |
Db2 catalog | BMCSTATS BMCUPRS |
Db2 catalog history | BMCSTATS BMCUPRS |
The following table lists the detailed tasks:
Statistics collection and update tasks
Task | Reference |
|---|---|
List Db2 objects. | |
List Db2 object data sets. | |
Specify BMCSTATS job parameters. | |
Collect index statistics. | |
Collect space statistics only. | |
Save statistics in the DASD MANAGER PLUS database. | |
Update the Db2 catalog with BMCSTATS statistics. | |
Print a statistics report. | |
Delete old statistics. | |
Group statistics collected by page. | |
Specify the multitasking level for collecting statistics. | |
Use sampling for statistics collection. | |
Recall archived data sets during statistics collection. | |
Specify tables and columns for statistics collection. | |
Update Db2 statistics with BMCSTATS statistics. | |
Generate a BMCSTATS job. | |
Understand the job status codes. | |
Compare Db2 statistics and BMCSTATS statistics. | |
Update Db2 statistics with your own values. | |
Update Db2 statistics with values from the DASD MANAGER PLUS database. |