QMF reports
DASD MANAGER PLUS provides sample QMF queries that produce reports from the historical statistics database.
You can select one or more different views for the sample reports. The table below shows views that the CNTL library member ASURVIEW provides for use by the QMF reporting procedures.
Views for QMF reports
View | Description |
|---|---|
BMCQMF.RS_MO_AV_IXPART | This view produces averages for statistics by month on all indexes in the statistics database for the last three months. The view points to the BMCQMF.RS_USER_IXPART view. |
BMCQMF.RS_MO_AV_TSPART | This view produces averages by month over the last three months for all table spaces in the statistics database. The view points to the BMCQMF.RS_USER_TABLEPART view. |
BMCQMF.RS_MO_AV_TSPART12 | This view produces averages for statistics by month on all table spaces in the statistics database for the last twelve months. The view points to the BMCQMF.RS_USER_TSPART view. |
BMCQMF.RS_TABLEPART | This view provides the base for BMCQMF views that require the grouping of data by monthly periods (includes YYMM). The view points to the BMCATSnn.RS_TABLEPART table (where nn is the release level). |
BMCQMF.RS_USER_DBIX | This view provides a count of the number of indexes in each database. The view points to the BMCQMF.RS_MO_AV_IXPART view. |
BMCQMF.RS_USER_DBTS | This view creates summary statistics from the average table space statistics for each database in the statistics tables. The view points to the BMCQMF.RS_MO_AV_TSPART view. |
BMCQMF.RS_USER_IXPART | This view selects detail statistics on all indexes for which statistics have been collected within the last three months and groups them by database and month. The view points to the BMCATSnn.RS_INDEXPART table (where nn is the release level). |
BMCQMF.RS__USER_TBCOUNTS | This view creates a count of the number of tables in each table space. The view points to the BMCQMF.RS_USER_TBNAMES view. |
BMCQMF.RS_USER_TBNAMES | This view selects all table names in the statistics tables where statistics have been collected within the last three months. The view points to the BMCATSnn.RS_TABLES table (where nn is the release level). |
BMCQMF.RS_USER_TSPART | This view selects detail information about table spaces from statistics entries less than three months old. The view points to the BMCATSnn.RS_TABLEPART table (where nn is the release level). |
BMCQMF.RS_USER_TSPART12 | This view selects detail statistics for all table spaces for which statistics have been collected within the last twelve months and groups them by database and month. The view points to the BMCATSnn.RS_TABLEPART table (where nn is the release level). |
DASD MANAGER PLUS provides the sample QMF reports (in the table below) to access useful information in the statistics tables.
Descriptions of QMF reports
Report | Query | Form | View |
|---|---|---|---|
DBMONTHLY lists high-level table space statistics for all databases by month. | QDBMONTHLY | FDBMONTHLY | BMCQMF.RS_USER_DBTS |
DBSUMMARY lists summary information about all databases. | QDBSUMMARY | FDBSUMMARY | BMCQMF.RS_USER_TBCOUNTS BMCQMF.RS_USER_DBTS BMCQMF.RS_USER_DBIX |
MONTHCHANGE gives delta information by table space over the last three months. | QMONTHCHANGE | FMONTHCHANGE | BMCQMF.RS_MO_AV_TSPART |
PARTSTATS3 gives information about all table space partitions over the last three months. | QPARTSTATS3 | FPARTSTATS3 | BMCQMF.RS_MO_AV_TSPART |
SPACESTATS12 displays the amount of space used by all table spaces over the last twelve months. The report can be modified to display any desired statistic over the last twelve months. | QSPACESTATS12 | FSPACESTATS12 | BMCQMF.RS_MO_AV_TSPART |
TSBYMONTH produces detail information by month for every table space in the statistics tables. | QTSBYMONTH | FTSBYMONTH | BMCQMF.RS_MO_AV_TSPART |
TSBYSET produces one line for each timestamped entry in the statistics database for a table space partition. | QTSBYSTATSSET | FTSBYSTATSSET | BMCATSnn.RS_TABLEPART |
Use the following procedure to set up the sample QMF reports feature.
To implement the sample QMF Report Facility
Build views for the DASD MANAGER PLUS sample QMF reports. Run SPUFI and specify the CNTL data set and member ASURVIEW.
- Import the DASD MANAGER PLUS QMF Reports into QMF.
- Edit all members of the QMFPROC data set, as follows:
- Change HLQ to the high-level qualifier for DASD MANAGER PLUS data sets at your installation.
- Change U******* to the logon ID of the person running the QMF install.
From QMF, execute the following command:
IMPORT PROC FROM 'HLQ.QMFPROC' (M=LOADPROC)
- Edit all members of the QMFPROC data set, as follows:
- Press F2 or enter the RUN command to run the procedure which imports all of the BMC-supplied DASD MANAGER PLUS QMF reports.