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 ] [ -RO ]  ]

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 Database analysis 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.

-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 -RO with caution because it is designed to work only with a read-only connection. Unexpected errors may result if you specify -RO when 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:

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