Understanding customizable reports

Action Report

This report gives the contents of actions—identifying their services, objects, object type, partition, and any object set. If the service in the action is BMCTRIG, the report also identifies the corrective action.

ASUACTN

Average Monthly Growth Report¹

This report lists the average monthly growth in cardinality, tracks, and pages for table spaces and indexes for the past twelve months based on the statistics taken.

ASUAMGR

Corrective Action Cross Reference Report

This report identifies all actions that are associated with a corrective action in the Db2 subsystem.

ASUDFACT

Data Set List by Database Name Report

This report lists information about the data sets residing on the specified database.

ASUZDSLI

Database Space Detail Report¹

This report provides detailed information about table space and index space allocation, current space utilization, and reorganized space estimation.

ASUDSPAC

Database Space Trend Report¹

This report predicts the number of days until a Db2 object will exceed the maximum number of extents, the space limit, or the space on the volume.

ASUSPCTR

Database Storage Utilization Report

This report lists the space allocated, the space used, the percentage of space used, and the number of extents for each table space and index of a Db2 database; also shows totals by table space, index, and database.

ASUDBSPA

Exception Report by BMCTRIG Action¹

This report lists exceptions that a BMCTRIG job detected.

ASUEXCPT

Index Clustering Report¹

This report lists, for clustering indexes, the unique rule (UR) of the index, the percentage of rows in clustering order, and the number of rows not in optimal position.

ASUCRANA

Modified Table Space Pages Report¹

This report lists the number of rows in a table space, the number of active pages, the number of pages modified since the last copy, the percentage of modified pages, and the recommended type of copy to make.

ASUTSDIR

Space Estimation Report¹

This report estimates the reorganized space of a Db2 object based on the specified percentage change in the object’s cardinality and the specified percentage free and number of free pages.

ASUPSE

Space Estimation Trend Report¹

This report uses linear regression of BMCSTATS historical data to estimate the cardinality of an object and then computes the reorganized space of an object.

ASUTRSE

Space Utilization by Table Report¹

This report lists the number of pages containing table data, the percentage of pages that contain rows, and the table cardinality for the specified Db2 objects.

ASUTBSPA

Table Space and Index Extents Report¹

This report lists the allocated space, used space, and number of extents for Db2 table spaces and indexes that equal or exceed a specified number of extents.

ASUDBEXT

Table Space and Index Storage Limits Report¹

This report shows the storage limits for Db2 table spaces or indexes, showing the percentage of the physical object-limit that has been used.

ASUDBLIM

This report shows the storage limits for Db2 table spaces or indexes, showing the percentage of the physical object-limit that has been used. This report is based on data in the Db2 real time statistics tables, SYSTABLESPACESTATS and SYSINDEXSPACESTATS.

ASURTLIM

Tables with More than Average Growth Report¹

This report identifies Db2 tables that are growing at more than the average rate, based on the last two sets of statistics taken.

ASUNPGR

Volume Space Trend Report

This report predicts the number of days until DASD volumes will run out of space.

ASUVOLTR