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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*