Kbase P31998: How to determine the number of records per block within a storage area using the PROSTRCT command.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/4/2011 |
|
Status: Verified
GOAL:
How to determine the number of records per block within a storage area using the PROSTRCT command.
GOAL:
How to determine the # of records per block within a storage area using PROSTRCT command.
GOAL:
How to determine records/block within a storage area using PROSTRCT command.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
There are two commands which will allow you to determine how many records per block are configured for a specific storage area.
These commands are: "prostrct list" and "prostrct statistics".
1. prostrct list dbname.st (will update the dbname.st file with current
extent information in the dbname.st and will also display information
to the screen).
Review the dbname.st file to determine how many records per block for the
area you are interested in.
Command: prostrct list dbname
more dbname.st
d "Cust_Data":9,32 /tmp/me_9.d1 f 320
d "Cust_Data":9,32 /tmp/me_9.d2
^^
OR
2. prostrct statistics dbname will display block utilization information as
well as extent information on a per area basis.
Command: prostrct statistics dbname
Database Block Usage for Area: Cust_Data
Active blocks: 184
Empty blocks: 168
Extent blocks: 2
Total blocks: 352
Records/Block: 32 <---- Records per block