The RMU Analyze Placement command provides a maintenance tool
for analyzing row placement relative to index structures and
generates a formatted display of this statistical information.
Information is displayed selectively for any specified storage
area.
You can use the RMU Analyze Placement command to determine:
o The maximum and average path length to a data record. (The
maximum and average number of records touched to reach a data
record.)
o The estimated maximum I/O path length to a data record.
o The estimated minimum I/O path length to a data record.
o The frequency distributions for the database key (dbkey)
path lengths, maximum I/O path lengths, and minimum I/O path
lengths for specified indexes.
o The distribution of data records on data pages in a storage
area by logical area identifier (ID) and dbkey, the number
of dbkeys needed to reach each data record, the maximum and
minimum I/O path lengths needed to reach the data record, and
the specific dbkey for the data record.