Salesforce

How does PROUTIL tabanalys gather record information?

« Go Back

Information

 
TitleHow does PROUTIL tabanalys gather record information?
URL NameP122741
Article Number000137664
EnvironmentProduct: Progress
Version: 8.x, 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
How does PROUTIL tabanalys gather record information?
How does PROUTIL dbanalys gather record information?
How does PROUTIL ixanalys gather index information?
How does PROUTIL idxanalys gather index metrics?
How does proutil gather information for analys reports (DBANALYS, TABANALYS, I(D)XANALYS)
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
PROUTIL performs low level C routines to read every record of every table.

DBANALYS is essentially a cumulative report for:
  1. TABANALYS,
  2. IDXANALYS
  3. CHANALYS summary
TABANALYS:
  • As each data block is read, PROUTIL records 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 each Area are accumulated.
IDXANALYS:
  • The same method is used to gather information for indices when performing IDXANALYS
  • How much space is used by all indices within each area is calculated.
  • 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. 
All this information is held by the PROUTIL process and written to a report which can be read from the screen or re-directed to an output file for viewing in a text editor.

When these operations are run online, then there is the possibility that after the data are read, the data may have been changed by another process.
When online dbanalys, tabanalys, or ixanalys are performed, the beginning of the report will indicate that the results are estimates based on data gathered by the process during its one and only pass through the database:
[Warning] database in use - reported statistics are approximations. (2486)
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:30 AM

Powered by