Kbase P91243: What information is gathered when running tabanalys?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
What information is gathered when running tabanalys?
GOAL:
How to determine the number of records per a table?
FIX:
The tabanalys option from proutil displays the following information by table per a storage area:
Table - Table owner and table name.
Records - Total number of records in the database for the table.
Bytes - Total number of bytes used in the database for the table.
Min - Minimum number of bytes used by any record for the table.
Max - Maximum number of bytes used by any record for the table.
Mean - Mean number of bytes used by any record for the table.
Count - Total number of record fragments found in the database for the table.
Factor - Degree of record fragmentation for the table.
Scatter Factor - Degree of distance between records in the table.
Syntax: proutil <dbname> -C tabanalys