Previous Topic: Define DB2 z/OS Table or Index PartitionsNext Topic: Specify DB2 z/OS Using Clause Parameters for 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 New icon in property editors to create a new object 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 that you want to associate with the object.
  5. (Optional) Click the UDP tab to work with user-defined properties for the object.
  6. (Optional) Click the Notes tab to view and edit user notes.
  7. Click Close.

    The DB2 for z/OS XML Index Editor closes.