Creating Models › Target Servers for Physical Models › Database Property Editors › DB2 z/OS Property Editors › Define a DB2 z/OS XML Index

Define a DB2 z/OS XML Index

You can create an index on an XML column to evaluate Xpath expressions efficiently and to improve performance when XML documents are queried.

To define a DB2 z/OS XML Index

1. Expand a table in the Model Explorer, expand XML Index, right-click an XML Index and then select Properties.

   The DB2 for z/OS XML Index Editor opens.

2. Select an XML Index and work with the following options:

   Note: Click New on the toolbar to create an XML Index. Use the Enter filter text text box to filter a large list of XML Indexes to locate the one you want to work with.

   Name

   Specifies the name of the XML Index.

   Schema

   Specifies a schema for the selected XML index. Select from the drop-down list.

   Column

   Specifies the column for which the XML index is being created. Select from the drop-down list. For the selected table, only those columns for which you have specified the Physical Data Type as XML appear in the drop-down list.

   Is Unique

   Specifies whether or not the selected XML index is unique.

   Generate

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

3. Work with the following options on the General tab:

   Is Compressed

   Specifies that the index uses index compression. Select from the drop-down list; valid values are True and False.

   Define Data Sets

   Specifies that the data sets are created when the index is created. Select from the drop-down list; valid values are True and False.

   Use Bufferpool

   Defines the bufferpool to use for the index. Select from the drop-down list.

   Close

   Specifies that the index is eligible for closing. The CLOSE parameter specifies whether or not the data set is eligible to be closed when the index is not being used and the limit on the number of open data sets is reached. Select from the drop-down list; valid values are True and False.

   Defer

   Specifies whether or not to build the index during the execution of the CREATE INDEX statement. Default is No, which means the index is built.

   Piece Size

   Specifies the maximum addressability of each data set for a secondary index. Enter a valid integer (see your DB2 z/OS documentation for specific information on valid integers).

   Copy

   Indicates that the COPY utility is allowed for the index.

4. (Optional) Click the Comment tab and enter any comments you want to associate with the XML Index.
5. (Optional) Click the UDP tab to work with user-defined properties for the XML Index.
6. (Optional) Click the Notes tab to view history information and view or edit user notes.
7. Click Close.

   The DB2 for z/OS XML Index Editor closes.