Previous Topic: Define a DB2 LUW IndexNext Topic: Define a DB2 LUW Module


Define a DB2 LUW Index Extension

Use the DB2 for LUW Index Extension Editor to define an extension object for use with indexes on tables that have structured type or distinct type columns.

To define a DB2 LUW index extension

  1. Right-click an Index Extension in the Model Explorer and select Properties.

    The DB2 for LUW Index Extension Editor opens.

  2. Select an index extension and work with the following options:

    Note: Click New New icon in property editors to create a new object on the toolbar to create a index extension. Use the Enter filter text text box to filter a large list of indexes to locate the one you want to work with.

    Name

    Specifies the name of the index extension.

    Schema

    Specifies the default schema for the index extension.

    Generate

    Specifies whether or not to generate DDL for this object during Forward Engineering.

  3. Click the Parameter tab and work with the following options:
    Parameter

    Specifies the parameter that is passed to the index extension at the time of creating the index to define the behavior of this index extension.

    Physical Data Type

    Specifies the data type for the parameter.

  4. Work with the following fields on the General tab:
    Source Key

    Indicates a structured data type or distinct type for the source key column supported by the index extension.

    Generate Key Function Definition

    Specifies how the index key is generated using a user-defined table function.

    Target Key

    Specifies the target key parameters that are the output of the key generation function.

  5. Click the Search Method Definitions tab and work with the following options:
    Search Method Definitions

    Specifies the method details of the index search. This definition should include a method name, the search arguments, a range producing function, and an optional index filter function.

  6. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
  7. (Optional) Click the Where Used tab to view where the object is used within the model.
  8. (Optional) Click the UDP tab to work with user-defined properties for the object.
  9. (Optional) Click the Notes tab to view and edit user notes.
  10. (Optional) Click the Extended Notes tab to view or edit user notes.
  11. Click Close.

    The index extension is saved and the DB2 for LUW Index Extension Editor closes.

More information:

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor