DEDB analysis reports

Fast Path Analyzer/EP produces a total of 11 reports.

The Area Summary Report is the most general of the reports, and is generated automatically any time the Fast Path Analyzer/EP ANALYZE command is executed. The other 10 reports can be categorized in three general groups. These reports contain detailed data about database performance, space usage, segment characteristics, and record characteristics.

Related topic

DEDB reports

As shown in the following table, a specific keyword is available to request each report individually when executing the Fast Path Analyzer/EP REPORT subcommand. The table also shows that certain reports require specific keyword values for generation.

For additional examples of the reports, refer to PFPANLYZ in the REPORTS data set.

Category	Report title	Keyword that generates report	Prerequisite
Space Utilization	Free Space Analysis	FREESPACE_ANALYSIS	none
	IOVF Space Analysis	IOVF_SPACE_ANALYSIS	none
	UOW Detailed Analysis	UOW_DETAILED_ANALYSIS	none
Segment	Pointer Analysis	POINTER_ANALYSIS	none
	Segment I/O Analysis	SEGMENT_IO_ANALYSIS	POINTER_VALIDATION=FULL must be specified
	Segment Length Analysis	SEGMENT_LENGTH_ANALYSIS	none
	Segment Placement Analysis	SEGMENT_PLACEMENT_ANALYSIS	none
Record	Record Length Analysis	RECORD_LENGTH_ANALYSIS	POINTER_VALIDATION=FULL must be specified
	Record Placement Analysis	RECORD_PLACEMENT_ANALYSIS	POINTER_VALIDATION=FULL must be specified
	Record Profile Analysis	RECORD_PROFILE_ANALYSIS	none
	Synonym Chain Analysis	SYNONYM_CHAIN_ANALYSIS	POINTER_VALIDATION=FULL or RAP_VALIDATION=XREF must be specified

This section contains the following topics:

DEDB analysis reports

Comments