Free Space Analysis Report
The Free Space Analysis Report provides the following information:
- summary and detailed information about the total and usable amount of free space in each section of the database (RAA base, DOVF, and IOVF)
- statistics about the number and size of the free space elements in each section of the database
- overflow usage analysis (DOVF and IOVF)
For an additional example of the report, refer to the PFPANLYZ member in the REPORTS data set.
The Free Space Analysis Report provides valuable information that can be used to determine the following items:
- when to reorganize or expand an area
- optimal values for UOW and ROOT parameters
- DOVF and IOVF usage
Free space calculations have the following characteristics:
- The entire area is included in the report. When an optional UOW range report is requested, the report also contains a summary of the free space within the selected UOWs.
- The total usable space in a CI is the block size minus 21 (the overhead bytes).
- The length of the free space element (FSE) is included in usable free space only if it is large enough to hold the smallest maximum segment that is defined in the area.
- Scraps (free space less than 4 bytes in length) are included in free space calculations, but they are not included in FSE calculations.
Free Space Analysis Report
Time: 09:02AM Free Space Analysis Report Page 12
0DBD Name: PFPDEMO Area Name: PFPDEMO1 Area DSname: PFP.DB.PFPDEMO1
Area number: 1 UOW Range: All
0
Area Overview RAP DOVF IOVF SDEP
0 Total % FS: 27% 10% 83% 96%
Usable % FS: 27% 9% 83% 94%
Unused: 10% 7% 81% 94%
In Area: 5% 1% 32%
FS for Root: 43%
0Analysis of RAP Blocks
---CIs--- -----No. of FSEs------ -------Size of FSEs-------- Using
FS % No. % Avg SDev Max Min Avg SDev Max Min Ovflow
100 11 10
90-99 0 0
80-89 3 3 1.0 0.0 1 1 6,884 168 7048 6712 0
70-79 4 4 1.0 0.0 1 1 5,967 230 6306 5799 0
60-69 6 5 1.0 0.0 1 1 5,268 268 5715 5052 0
50-59 7 6 1.0 0.0 1 1 4,488 263 4751 4120 0
40-49 6 5 1.0 0.0 1 1 3,717 275 3993 3432 0
30-39 3 3 1.0 0.0 1 1 2,748 291 3070 2505 0
20-29 3 3 1.0 0.0 1 1 2,122 199 2349 1980 0
10-19 6 5 1.0 0.0 1 1 1,220 194 1563 986 0
0-9 65 57 1.0 0.1 1 0 200 169 769 8 60
0 RAP CI Usage Summary Total: 114 Used: 103 (90%)
CIs Using Overflow: No: 60 % CIs: 58%
-Analysis of Overflow Blocks
% DOVF --UOWs--- ---DOVF CIs Used--- ----No. of FSEs---- ------Size of FSEs------ In --IOVF CIs Used--- FSEs/
Part FS No. % Avg SDev Max Min Avg SDev Max Min Avg SDev Max Min IOVF Avg SDev Max Min IOVF CI
100 0
90-99 0
80-89 0
70-79 0
60-69 0
50-59 1 17 3.0 0.0 3 3 1.0 0.0 1 1 4,116 4,050 8171 43 0
40-49 0
30-39 0
20-29 0
10-19 0
0-9 5 83 5.0 0.0 5 5 1.0 0.2 1 0 170 135 464 15 5 3.6 2.1 6 1 1.0
0 DOVF CI Usage Summary Total: 30 Used: 28 (93%)
UOWs Using DOVF: No.: 6 % UOWs: 100%
No. DOVF CIs Used: Avg: 4.67 SDev: 0.82 Max: 5 Min: 3
0 IOVF CI Usage Summary Total: 95 Used: 18 (19%)
UOWs Using IOVF: No.: 5 % UOWs: 83%
No. IOVF CIs Used: Avg: 3.60 SDev: 2.07 Max: 6 Min: 1
Available IOVF CIs: No.: 77 % CIs: 81%
The following table lists the fields that are displayed in this report.
Free Space 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 that are 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. |