Kbase P132611: What packing factor was used for idxbuild?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/12/2008 |
|
Status: Verified
GOAL:
What packing factor was used for idxbuild?
GOAL:
How to know that the -pfactor used is in effect during the idxbuild?
GOAL:
How to verify the index compaction after idxbuild with -pfactor parameter
FACT(s) (Environment):
OpenEdge 10.1C
All Supported Operating Systems
FIX:
A feature enhancement to the PROUTIL -C IDXBUILD utility was the 'packing factor' -pfactor <%> to use when building indexes.
To verify what packing factor was used:
A. The database.lg file can be parsed for message: (13943) TB value is 24, TM value is 32, SG value is 64, packing factor is 80
B. Index analysis reports will show that no index utilization % is above the number provided for -pfactor
- proutil -C idxanalys [Area_Name]
- proutil -C idxblockreport <TableName.IndexName>
For example:
D:\101B\WRK\mo>proutil dd -C idxblockreport Customer.name
BlockSize = 4096 Block Capacity = 4068
Number Length On Length Delete
of of Delete of Chain Percent
DBKEY Level Entries Entries Chain Size Type Utilized
512 1 4 50 0 0 root 0
320 2 320 6530 0 0 leaf 79
352 2 296 6526 0 0 leaf 79
288 2 341 6531 0 0 leaf 79
256 2 161 3331 0 0 leaf 40
Index Block Statistics reported successfully.
The above results from building the customer.name index with a packing factor of 80.