×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')
Fast Path Offline Suite 4.0 ... Using Analyzing a DEDB Analysis report descriptions

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

Analysis report descriptions

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Last modified by Winner kumar Jaiswal on Jun 14, 2019
using

Comments

Log in or register to comment.

Pointer Analysis Report
Segment Length Analysis Report
© Copyright 1992-2019 BMC Software, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.