7.2 Index Manager

Index Manager is an attribute of the Server object that lets you manage database indexes. These indexes are used by OpenText eDirectory to significantly improve query performance.

OpenText eDirectory ships with a set of indexes that provide basic query functionality. These default indexes are for the following attributes:

CN

Aliased Object Name

dc

Obituary

Given Name

Member

Surname

Reference

uniqueID

Equivalent to Me

GUID

NLS: Common Certificate

cn_SS

Revision

uniqueID_SS

extensionInfo

ldapAttributeList

ldapClassList

You can also create customized indexes to further improve OpenText eDirectory performance in your environment. For example, if your organization has implemented a new LDAP application that looks up an attribute not indexed by default, it might be useful to create an index for that attribute.

NOTE:Although indexes improve search performance, additional indexes also add to directory update time. As a general rule, create new indexes only if you suspect performance issues are related to a particular directory lookup.

Using OpenText Identity Console, you can create or delete indexes. You can also view and manage the properties of an index, including the index name, state, type, rule, and attribute indexed.

7.2.1 Creating an Index

  1. On the OpenText Identity Console home page, click the Index Management tile.

  2. Click Create Index .

  3. On the Create Index page enter the name at the Name field.

  4. From Select server list > select server.

  5. From Select Attribute list > select attribute.

  6. Select the index rule.

    • Value matches the entire value or the first part of the value of an attribute. For example, value matching could be used to find entries with a LastName that is equal to “Jensen” and entries with a LastName that begins with “Jen.”

    • Presence requires only the presence of an attribute rather than specific attribute values. A query to find all entries with a Login Script attribute would use a presence index.

    • Substring matches a subset of the attribute value string. For example, a query to find a LastName with “der” would return matches for Derington, Anderson, and Lauder.

      A substring index is the most resource-intensive index to create and maintain.

  7. Click Create.

    The Index Created successfully on 1 server massage appears.

    Restart Limber as a background process and initiate the change.

    IMPORTANT:The $ character is used as a delimiter for attribute values. If you use the $ character in your index name, you must use a preceding backslash (\) character to escape the $ character when working with indexes via LDAP.

7.2.2 Deleting an Index

Indexes might outlive their usefulness. You can delete user-defined and auto-created indexes that are no longer a benefit.

  1. On the OpenText Identity Console home page, click the Index Management tile.

  2. On the Index page, select the user- or auto-added index you want to delete.

  3. Click Delete to update the index table.

  4. On the Delete Confirm popup > click OK to confirm delete.

    Restart Limber as a background process and initiate the change.

7.2.3 Taking an Index Offline

During peak times you might want to tune performance by temporarily taking indexes offline. For example, to achieve additional bulk-load speed, you might want to suspend all of the user-defined indexes. Because each object addition or modification requires updating defined indexes, having all indexes active might slow down bulk-loading of data. After the bulk-load is completed, the indexes can be brought online again.

  1. On the OpenText Identity Console home page, click the Index Management tile.

  2. On the Index page, select the check box against the index that you want to take off-line, click State drop-down menu > select Offline.

    The index state changes from Online to Offline in the display table. An index can be in any of the following states:

    • Online : Currently running.

    • Offline : Suspended. The index can be started again by clicking Bring Online.

    • New : Waiting to move to Online.

    • Deleted : Waiting to be removed from the index table.

7.2.4 Managing Indexes on Other Servers

If you've found a particular index to be useful on one server and you see the need for this index on another server, you can copy the index definition from one server to another. In reviewing predicate data, you might also find just the opposite case: an index that was meeting a need for several servers is no longer useful on one of these servers. In that case, you could delete the index from the single server that isn't benefitting from the index.

Index Manager allows you to target a single instance of an index without impacting all instances.

  1. On the OpenText Identity Console home page, click the Index Management tile.

  2. On the Index page, select the index that you want to modify.

    When you select an index, servers in the tree providing that index are listed.

  3. On the Modify Index page select additional servers.

  4. Click Save.

    The Index modified successfully! message appears.