Synonym Chain Analysis Report - Documentation for Fast Path/EP products reference information 4.0
The Synonym Chain Analysis Report gives detailed information about the frequency and length of synonym chains.
The report provides statistics about root segment placement and physical I/O requirements. It provides valuable information to determine the following:
effectiveness of a randomizing module (In theory, root segments should be distributed evenly across all RAPs.)
optimal values for ROOT and UOW parameters
performance-tuning for an area
Note
The Synonym Chain Analysis Report can be generated only when POINTER_VALIDATION=FULL or RAP_VALIDATION=XREF is specified.
For an additional example of the report, see the PFPANLYZ member in the REPORTS data set.
Synonym Chain Analysis Report
1Date: 02/22/2016 FAST PATH ANALYZER/EP (4.00.00.01) Time: 09:02AM Synonym Chain Analysis Report Page 5
0DBD Name: PFPDEMO Area Name: PFPDEMO3 Area DSname: PFP.DB.PFPDEMO3 Area number: 3 UOW Range: All
-Synonym Chain Analysis -----------Root Placement Statistics------------ ------Physical I/O------- -In RAA Base-- ---In DOVF---- ---In IOVF---- -------Statistics-------- No. Roots/ ---RAPs--- Avg/ Max/ Avg/ Max/ Avg/ Max/ Avg SDev Max Min RAP No. % SDev Min SDev Min SDev Min 10 0 11 0 12 1 0.7 4.00 4 3.00 3 5.00 5 6.00 0.00 6 6 0.00 4 0.00 3 0.00 5 13 0The following table lists the fields that are displayed in this report.
Synonym Chain Analysis Report fields
Field | Description |
|---|---|
DBD Name | The DBD name of the database. |
Area ddname | The ddname of the area. |
Area Number | The area number. |
UOW Range | The range of UOWs included in the report. The value All indicates the entire area is being reported; a range value (start to stop) indicates the range of UOWs being reported. |