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

Use this procedure only if you do not want to use Administration Console for Content Platform Engine to create the index. 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.