摘要 |
A computer program product is provided as a system and associated method that provide accurate statistics in real time. These statistics can be used to determine if a table space in a database management system requires maintenance operations such as reorganization, back up, fresh access path statistics, and/or larger disk space allocation. The database management system or DBMS maintains a set of values that provide indications of whether that operation is due on that object. The objects for which the indicators are maintained depend on the specific DBMS. Typically, these objects are tables, indexes, and table spaces. The database management system maintains the indicators in memory. Some of the indicators are cumulative and others are given in absolute values. The indicators are asynchronously externalized in dedicated database tables either periodically in user-specified intervals or at some predefined event such as stopping the database. When the user performs a database administration operation, the database management system resets the associated indicators, and reports objects that are in an exception state based on the indicators collected as described for each operation. Reporting can be implemented in either real time or near-real time. In both cases, the objects found in exception status can be automatically corrected by the appropriate database administration operation.
|