Progress
Database Administration
Guide and Reference


PROUTIL IDXANALYS Qualifier

Displays information on index blocks. It calculates the number of index blocks and the percentage of the database used by the index blocks.

NOTE: The _UserStatus virtual system table displays the utility’s progress. For more information see Managing Performance."

SYNTAX

Operating System
Syntax
UNIX
Windows
proutil db-name -C idxanalys

db-name

Specifies the database to analyze.

EXAMPLE

The following is a sample display of PROUTIL IDXANALYS output:

INDEX BLOCK SUMMARY FOR AREA "Order" : 11  
------------------------------------------------------- 
Table                  Index  Fields Levels  Blocks   Size   % Util Factor 
PUB.BillTo  
  custnumbillto          46       2      1       1     27B     2.7     1.0 
PUB.Order  
  CustOrder              48       2      2      44   39.1K    91.4     1.5 
  OrderDate              49       1      2      33   18.5K    57.7     2.1 
  OrderNum               47       1      2      38   35.3K    95.5     1.5 
  OrderStatus            50       1      2       7   3808B    54.6     2.1 
  SalesRep               51       1      2       9   6226B    69.5     1.9 
PUB.OrderLine  
  itemnum                23       1      2      56   36.6K    67.2     1.9 
  orderline              22       2      3     139  132.7K    98.2     1.0 
  OrderLineStatus        24       1      2      10   7354B    73.8     1.8 
PUB.ShipTo  
  custnumshipto          45       2      1       1     36B     3.6     1.0 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095