7.2 Index Manager

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

NetIQ 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 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 NetIQ iManager, 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. In NetIQ iManager, click the Roles and Tasks.

  2. Click eDirectory Maintenance > Index Management.

  3. Select a server from the list of available servers.

  4. On the Modify Indexes page, click Create.

  5. Enter the Index Name.

    If you do not enter an index name, the attribute is automatically assigned as the index name.

    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.

  6. Select an attribute.

  7. 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.

  8. Click OK to update the index table.

  9. Click Apply to restart Limber as a background process and initiate the change.

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. In NetIQ iManager, click the Roles and Tasks.

  2. Click eDirectory Maintenance > Index Management.

  3. Select a server from the list of available servers.

  4. On the Modify Indexes page, select the user- or auto-added index you want to delete.

  5. Click Delete to update the index table.

  6. Click Apply to 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. In NetIQ iManager, click the Roles and Tasks.

  2. Click eDirectory Maintenance > Index Management.

  3. Select a server from the list of available servers.

  4. On the Modify Indexes page, select the indexes you want to take offline, then click Change State.

    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.

  5. Click Apply.

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. In NetIQ iManager, click the Roles and Tasks.

  2. Click eDirectory Maintenance > Index Management.

  3. Select a server from the list of available servers.

  4. To copy an index definition to another server on the same tree, click Modify Index Location.

  5. Select the index definition you want to copy.

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

  6. Use the columns provided to move a copy of the index to the desired server.

  7. Click Apply.