DB2:getIndexInfo

Get Index Information.

Note: This method can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.

Type

SYNC, IMPACT_INFO

Arguments

Name

Type

Description

Schema Name

String

Schema Name

Returns

Name

Type

Description

Table Schema

String

Table Schema

Table Name

String

Table Name

Table Name

String

Table Name

Index Schema

String

Index Schema

Index Name

String

Index Name

Partition

Big Integer

Database partition number.

Index Id

Big Integer

Index identifier.

Data Partition

Big Integer

Data partition identifier.

Compressed?

String

Physical index format. 'Y' = Index is in compressed format, 'N' = Index is in uncompressed format

Partitioned?

String

Identifies the partitioning characteristic of the index. 'N' = Nonpartitioned index, 'P' = Partitioned index, Blank = Index is not on a partitioned table.

Logical Size

Big Integer

Logical size of the index object.

Physical Size

Big Integer

Physical size of the index object.

Rebuild Required?

String

Rebuild status for the index. 'Y' = if the index defined on the table or data partition requires a rebuild, 'N' = otherwise.

Large RIDS present?

String

Indicates whether or not the index is using large row IDs (RIDs) (4 byte page number, 2 byte slot number). 'Y' = indicates that the index is using large RIDs, 'N' = indicates that the index is not using large RIDs, 'P' = (pending) indicates that the table that the index is defined on supports large RIDs (that is, the table is in a large table space), but the index for the table or data partition has not been reorganized or rebuilt yet.

Usage Notes

Invoking this method returns index information about the table schema.