Kbase P122741: How does proutil tabanalys gather record information?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/03/2007 |
|
Status: Unverified
GOAL:
How does proutil tabanalys gather record information?
GOAL:
How does proutil dbanalys gather record information?
GOAL:
How does proutil ixanalys gather index information?
GOAL:
How does proutil idxanalys gather index information?
FIX:
Proutil performs low level C routines to read every record of every table.
As each data block is touched, proutil looks to see what records from which tables are in the block.
Internal structures record the number of records, record fragments and record sizes for each record of each table.
The minimum, maximum and average record sizes for all records of the table are calculated.
The sizes for all tables in the areas are accumulated.
The same information is calculated for indices when performing a full dbanalysis or ixanalysis.
As each index block is examined information is gathered on the number of levels of the b-tree, number of blocks, degree each index block is utilized (full) for each index of the database. How much space is used by all indices within an area is calculated.
All the information is held by the proutil process and written to the log files.
If these operations are performed online, then there is the possibility that after we have read data, the data may be changed by another process.
When online dbanalys,tabanalys, or ixanalys are performed the beginning of the file will indicate that the results are estimates based on data gathered by the process during its one and only pass thru the database.