Full-function database base values
When a full-function database is registered with Database Advisor, base values are initially set by one of the following methods:
- Data is collected from subsequent execution of POINTER CHECKER PLUS.
- Data is collected from subsequent execution of COLLECT functions (scheduled or on demand).
- Database-level base values and partition-level base values can also be set when data is collected from subsequent execution of a BMC reorganization utility.
Base values are updated automatically after execution of any of the following BMC utilities:
- LOADPLUS/EP for IMS
- SECONDARY INDEX UTILITY/EP
- Single-step DBR Reorg
- Single-step online Reorg
When LOADPLUS/EP for IMS or SECONDARY INDEX UTILITY/EP is executed, base values for databases and partitions are set and base values for data sets are cleared. Data set base values in these cases are reset by one of the following methods:
- Data is collected from subsequent execution of POINTER CHECKER PLUS.
- Data is collected from subsequent execution of the ENDOFDAY function.
If a database is reorganized with an IBM reorganization utility, Database Advisor resets the base values for the database with the next ENDOFDAY run.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*