Segment I/O Analysis Report
The Segment I/O Analysis Report provides valuable information for database performance tuning and for evaluation of I/O requirements for specific user transactions.
Analysis is used also to determine the optimal reorganization point and to validate the effects of UOW and ROOT value parameter changes.
The Segment I/O Analysis Report can be generated only when POINTER_VALIDATION=FULL is specified on the primary command.
The Segment I/O Analysis Report provides the following statistics for a typical database record:
- Direct dependent segments in each part of an area (SDEPs segments are not included)
- Physical I/O operations required to retrieve dependent segments
- Physical I/O required to retrieve an average database record
- Physical I/O required to retrieve an average root segment
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*