Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 LUW Property Editors › Define a DB2 LUW Index Extension

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 a 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 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. Click the Comment tab and enter any comments you want to associate with the index extension.
7. Click the Where Used tab to view where index extensions are used in the model.
8. Click the UDP tab to work with user-defined properties for the index extension.
9. Click the Notes tab to view history information and view or edit user notes.
10. 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