Progress
Database Administration
Guide and Reference


PROUTIL DBANALYS Qualifier

Displays statistical information about index, record, and free chain blocks.

SYNTAX

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

db-name

Specifies the database you are using.

EXAMPLE

The following is a sample display of PROUTIL DBANALYS output:

SUMMARY FOR AREA "Inventory" : 8 
---------------------------------------------------------- 
                     Records             Indexes                  Combined  
NAME                Size   Tot %       Size   Tot %              Size  Tot % 
PUB.Bin             26.3K    1.1       16.4K    0.7             42.8K    1.8 
PUB.InventoryTrans  3661B    0.1          0B    0.0             3661B    0.1 
PUB.Item            7662B    0.3       8117B    0.3            15779B    0.6 
PUB.POLine         217.5K    9.1       51.9K    2.2            269.4K   11.3 
PUB.PurchaseOrder   68.6K    2.9       19.0K    0.8             87.6K    3.7 
PUB.Supplier        1177B    0.0         97B    0.0             1274B    0.1 
PUB.SupplierItemXr  1118B    0.0       1166B    0.0             2284B    0.1 
PUB.Warehouse       1288B    0.1        440B    0.0             1728B    0.1 
Size key: 
 B = bytes 
 K = kilobytes 
 M = megabytes 
 G = gigabytes 


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