Creating database indexes for class properties (DB2 for z/OS)

To optimize the performance of those queries that search a class property, create an index for the property in the object store database. The index that you create is a specific type of expression-based index in the following circumstances: case-insensitive search behavior is in effect, and the object store database is a DB2® for z/OS® database.

To create an expression-based index for a class property:

1. Connect to the object store database by using the appropriate DB2 for z/OS database tool.
2. Run a command with the following syntax:

   Command syntax	CREATE INDEX idx_name ON table_name(LOWER(column_name, ' ')); Important: The second argument of the LOWER() function designates the locale. Unless you changed the default locale when you installed DB2, you can leave this argument blank. For more information, see the discussion about the initial locale in CURRENT LOCALE LC_TYPE. For more information about the function, see LOWER.
   Example	CREATE INDEX lc_lname ON DocVersion(LOWER(lname, ' '));

   table_name

   The table that contains the column: DocVersion for documents, Generic for custom objects, and Container for folders.

   column_name

   The name of the property column.

   idx_name

   The name of the index.