DB Record Placement Analysis report

Edit online

The DB Record Placement Analysis report includes the number of database records that are contained in each of the seven placement categories.

The DB Record Placement Analysis report provides the following information:

  • The number of database records that are contained in each of the seven placement categories
  • Statistics about the number of DOVF and IOVF CIs that are used by a record

The DB Record Placement Analysis report provides information that can be used to determine:

  • When to reorganize a DEDB area
  • When to expand CI size (if it is less than 4 K)
  • The optimal value for the UOW parameter in the DBD

The following figure is an example of the DB Record Placement Analysis report.

Figure 1. DB Record Placement Analysis report
DB RECORD PLACEMENT ANALYSIS                                                                                 
                                                        ---DOVF CI'S USED---    ---IOVF CI'S USED---         
                                     NO. RECS    P/C    AVG.  SDEV  MAX  MIN    AVG.  SDEV  MAX  MIN         
   RECORDS IN: BASE ONLY              190,955   76.4                                                         
               BASE + DOVF             37,097   14.8    1.10   .30    2    1                                 
               BASE + DOVF + IOVF           2    0.0    1.00   .00    1    1    1.00   .00    1    1         
               BASE + IOVF                  1    0.0                            1.00   .00    1    1         
               DOVF ONLY               21,935    8.8    1.17   .38    2    1                                 
               DOVF + IOVF                  1    0.0    1.00   .00    1    1    1.00   .00    1    1         
               IOVF ONLY                    9    0.0                            1.00   .00    1    1
NO. RECS
Shows the total number of database records in the placement category.
P/C
Shows the percentage of the total number of database records in the placement category.
DOVF CI'S USED and IOVF CI'S USED
Show statistics about DOVF and IOVF CI usage.
AVG.
Shows the average number of DOVF or IOVF CIs that were used by records in the placement category.
SDEV
Shows the standard deviation for the average number of records in the placement category.
MAX
Shows the maximum number of DOVF or IOVF CIs that were used by any record in the placement category.
MIN
Shows the minimum number of DOVF or IOVF CIs that were used by any record in the placement category. (The minimum can never be less than 1.)
Recommendations:
  • DOVF usage is preferable to IOVF usage.
  • Less than 5 to 10% of the database records should use IOVF.
  • Expand the DOVF part of the UOW to minimize IOVF usage.