Synonym Chain Analysis Report
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
For an additional example of the report, see the PFPANLYZ member in the REPORTS data set.
Synonym Chain Analysis Report
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 0
The 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. |