SYSCAT.INDEXEXTENSIONS catalog view

Each row represents an index extension.

Table 1. SYSCAT.INDEXEXTENSIONS Catalog View
Column Name Data Type Nullable Description
IESCHEMA VARCHAR (128)   Schema name of the index extension.
IENAME VARCHAR (128)   Unqualified name of the index extension.
OWNER VARCHAR (128)   Authorization ID of the owner of the index extension.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
CREATE_TIME TIMESTAMP   Time at which the index extension was defined.
KEYGENFUNCSCHEMA VARCHAR (128)   Schema name of the key generation function.
KEYGENFUNCNAME VARCHAR (128)   Unqualified name of the key generation function.
KEYGENSPECIFICNAME VARCHAR (128)   Name of the key generation function instance (might be system-generated).
TEXT CLOB (2M)   Full text of the CREATE INDEX EXTENSION statement.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the index extension.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.