Try OpenEdge Now
skip to main content
Database Administration
Reference : PROUTIL Utility : PROUTIL IDXANALYS qualifier
 

PROUTIL IDXANALYS qualifier

Displays information on index blocks.

Syntax

proutil db-name -C idxanalys [ area area-name ]
     [ tenant tenant-name| group group-name| shared ] 
[-csoutput [ -fieldsep sep-value][ -csfilePrefix pref-name ]
           [ -verbose ]]

Parameters

db-name
Specifies the database to analyze.
area area-name
Specifies that IDXANALYS is to be performed on the area-name area only.
tenant tenant-name
Specifies that IDXANALYS is to be filtered to only provide information related to objects that are owned by tenant-name. If tenant-name is not valid, IDXANALYS exits with an error. Specifying tenant is only allowed on databases enabled for multi-tenancy.
group group-name
Specifies that IDXANALYS is to be filtered to only provide information related to objects that are owned by group-name. If group-name is not valid, IDXANALYS exits with an error. Specifying group is only allowed on databases enabled for multi-tenancy.
shared
Specifies that IDXANALYS is to be filtered to only provide information related to shared objects. Specifying shared is only allowed on databases enabled for multi-tenancy.
-csoutput
Specifies that IDXANALYS output the analysis data to text files in addition to the screen. The result is that the following files are created:
*db-name .ix.txt — For index analysis output
*db-name .block.txt — For block analysis output
For more information about the contents of the files, see the Databaseanalysis output.
-fieldsep sep-value
When -csoutput is specified, sep-value indicates the value to separate the columns of output. A space is used by default. Accepted values for sep-value are:
*Any ASCII character between 0x21 and 0x7E
*sp — to denote a space (the default)
*tab — to denote a the TAB character (<\t> or ASCII character 0x09)
-csfilePrefix pref-name
When -csoutput is specified, pref-name indicates a file name prefix. The database name is used by default. All remaining elements of the file name are not customizable.
-verbose
When -csoutput is specified, the first row of the output files contains header names for each column of output.
IDXANALYS calculates the number of index blocks and the percentage of the database used by the index blocks. The _UserStatus virtual system table displays the utility's progress. See Managing Performance for more information.

Output format

Both non-partitioned and partitioned indexes appear in the summary for shared objects in alphabetical order by name. For partitioned indexes, the data for the index of indexes appears first, followed by the remainder of partitions in alphabetical order by partition name. There is no differentiation between local and global indexes. However, a global index will have only a single line of information with a partitionId of 0.

Example

The following output is a sample display of PROUTIL IDXANALYS:


INDEX BLOCK SUMMARY FOR AREA "Employee": 7
-------------------------------------------------------


INDEX BLOCK SUMMARY FOR SHARED OBJECTS:
--------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
PUB.Benefits
EmpNo 8 1 1 1 197.0B 4.8 1.0
PUB.Department
DeptCode 18 1 1 1 84.0B 2.1 1.0
PUB.Employee
DeptCode 20 1 1 1 132.0B 3.2 1.0
EmpNo 19 1 1 1 503.0B 12.4 1.0
Name 21 2 1 1 1.0K 25.5 1.0
PUB.Family
EmpNoRelativeName 22 2 1 1 1.4K 36.4 1.0
PUB.TimeSheet
EmpNoDayRecorded 59 2 1 1 293.0B 7.2 1.0
PUB.Vacation
EmpNoStartDate 60 2 1 1 152.0B 3.7 1.0

------------------------------------------------------------------
Subtotals: 8 3.8K 11.9 0.0




INDEX BLOCK SUMMARY FOR AREA "Inventory": 8
-------------------------------------------------------


INDEX BLOCK SUMMARY FOR SHARED OBJECTS:
--------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
PUB.Bin
BinNum:0 10 1 2 3 6.8K 57.1 1.9
ItemNum:0 11 1 1 1 1.8K 46.2 1.0
PUB.Item
CatDescription 34 1 2 3 4.1K 34.5 2.3
Category2ItemName 35 2 1 1 958.0B 23.5 1.0
CategoryItemName 36 2 1 1 1.0K 26.1 1.0
ItemName 37 1 1 1 934.0B 23.0 1.0
ItemNum 33 1 1 1 503.0B 12.4 1.0
PUB.POLine
PONumLinenum 47 2 2 15 51.3K 86.1 1.3
PUB.PurchaseOrder
PONum 48 1 2 6 18.8K 78.9 1.4
PUB.Supplier
SupplierID 56 1 1 1 97.0B 2.4 1.0
PUB.SupplierItemXref
ItemNumSupplierID 58 2 1 1 624.0B 15.3 1.0
SupplieridItemNum 57 2 1 1 542.0B 13.3 1.0
PUB.Warehouse
warehousename 62 1 1 1 307.0B 7.5 1.0
warehousenum 61 1 1 1 133.0B 3.3 1.0

------------------------------------------------------------------
Subtotals: 37 87.9K 59.8 0.2