PROUTIL IDXANALYS qualifier
- Last Updated: August 17, 2026
- 3 minute read
- OpenEdge
- Version 13.1
- Documentation
PROUTIL IDXANALYS qualifier
Displays information on index blocks.
Syntax
|
Parameters
- db-name
- Specifies the database to analyze.
- area area-name
- Specifies that
IDXANALYSis to be performed on the area-name area only. - tenant tenant-name
- Specifies that
IDXANALYSis to be filtered to only provide information related to objects that are owned by tenant-name. If tenant-name is not valid,IDXANALYSexits with an error. Specifyingtenantis only allowed on databases enabled for multi-tenancy. - group group-name
- Specifies that
IDXANALYSis to be filtered to only provide information related to objects that are owned by group-name. If group-name is not valid,IDXANALYSexits with an error. Specifyinggroupis only allowed on databases enabled for multi-tenancy. - shared
- Specifies that
IDXANALYSis to be filtered to only provide information related to shared objects. Specifyingsharedis only allowed on databases enabled for multi-tenancy. - -csoutput
-
Specifies that
IDXANALYSoutput 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 Database analysis output.
-
db-name
- -fieldsep sep-value
- When
-csoutputis 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
-csoutputis 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
-csoutputis specified, the first row of the output files contains header names for each column of output. For example:"Time Stamp" "DBUID" "DB name" "Area" "Area #" "Partition Type" "Tenancy" "Tenancy #" "Partition Policy" "Partition" "Partition #" "Owner" "Table" "Table #" "Index" "Index #" "State" "Fields" "Levels" "Blocks" "Size" "Utilization" "Factor" "DPsOnChain" "DPsOffChain" "LeafBlocks" "LeafBlocksOnChain" 2026-02-27T11:48:13.000-5:00 "yEdqpHgDw5awFMdPYAfWMg" "custdb1" "Control Area" 1 "-" "-" 0 "-" "-" 0 "PUB" "_Area" -71 "_Area-Number" 1027 1 1 1 1 143 1.8 1.0 0.0 0.0 1 0 2026-02-27T11:48:13.000-5:00 "yEdqpHgDw5awFMdPYAfWMg" "custdb1" "Control Area" 1 "-" "-" 0 "-" "-" 0 "PUB" "_AreaExtent" -72 "_AreaExtent-Area" 1028 1 2 1 1 173 2.1 1.0 0.0 0.0 1 0 2026-02-27T11:48:13.000-5:00 "yEdqpHgDw5awFMdPYAfWMg" "custdb1" "Schema Area" 6 "-" "-" 0 "-" "-" 0 "PUB" "_Client-Session" -200 "_Auth-time" 1083 1 1 1 1 3 0.0 1.0 "-" "-" "-" "-" - -RO
- Runs the utility in read-only mode. Use read-only mode to connect to databases on read-only media or to diagnose and repair issues on a stopped database before starting it. Read-only mode allows any number of connections at once, up to the maximum number of connections. You may run multiple diagnostic utilities concurrently, while the database broker is down, if they all support read-only connection and you run them in read-only mode. This reduces bottlenecks and expedites disaster recovery on large databases.Note: Use
-ROwith caution because it is designed to work only with a read-only connection. Unexpected errors may result if you specify-ROwhen using a single-user or multi-user connection.
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 Manage 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:
|
For more information, see Analyze index use.