Configuring a directory server for performance tuning with Configuration Tool

Use Configuration Tool to tune a directory server to improve the performance of the search and update operations.

1. Start Configuration Tool for an instance.
   See Starting Configuration Tool.
2. From the task list in the left navigational pane, click Database tasks > Performance tuning.
3. In the Performance tuning page, complete the following steps:
   1. In the Percentage of available system memory to be allocated to this directory instance field, enter the percentage of system memory you want allocated to the instance.
      The available system memory is divided between multiple directory server instances, or between instances and other servers that you plan to run on the system. The tool uses the value that you provide to calculate the sizes of the entry and filter caches.
   2. In the Planned number of groups field, enter the number of groups that you expect to add in the instance.
      The tool uses the value that you provide to calculate the sizes for the directory server caches.
   3. In the Maximum number of members in a group that will be referenced frequently field, enter the average number of members for groups that are referenced frequently.
   4. Under the Number of entries and average entry size area, choose one of the following options:
      • If you want to estimate the number of entries in the directory and the average size of an entry, complete the following steps:
        1. In the Planned number of entries field, enter the total number of entries that are planned for the instance. The tool attempts to determine the number of entries in the directory server instance. If it cannot, it uses the default of 10,000 entries. The tool uses this value to calculate the sizes for the directory server caches.
        2. In the Average size of an entryfield, enter the average size in bytes of an entry that is in the instance. The tool attempts to compute the size of an entry in the directory server instance. If it cannot, it uses the default of 2650 bytes. The tool uses this value to calculate the sizes for the directory server caches.
      • If you want the tool to determine the total number of entries and average entry size, click Load from server instance database. The tool populates the Planned number of entries and Average size of an entry fields.
   5. Under the Update frequency area, choose one of the following options:
      • If you expect frequent updates to the instance, click Frequent updates. (As a guideline, an average of more than one update for every 500 searches can be considered frequent updates.)
      • If you expect less frequent updates or if updates are grouped and made during certain durations in a day, click Batch updates.

      The tool uses this information to set the filter cache size. The filter cache is useful only when there are infrequent updates to the instance and the same searches are run multiple times. If frequent updates are expected, the filter cache is set to 0. If infrequent or batch updates are expected, the filter cache is set to 1024 filter cache entries.
   6. If you want the tool to provide performance analysis values, select Enable collection of additional system data for extended tuning.
      • When you select the check box, the DB2 monitor switches BUFFERPOOL and SORTHEAP are enabled. The performance of the directory server instance might degrade when the tool enables the DB2 monitor switches to collect the data.
      • To obtain accurate data for optimal tuning of your directory server instance, select the check box when directory activity is typical for your environment. If you run the database health check when the server is not busy, then the usual does not provide optimum performance values.
   7. Click Next.
      The Performance tuning: verification page opens.
4. In the Performance tuning: verification page, complete the following steps:
   1. In the Database health status list, verify the performance tuning settings that the tool generates.
      If there are no database activities for the instance, the Database health status list might not be populated. The list is populated if the tool collects information about at least one DB2 related parameter. The tuning settings are also logged in the perftune_stat.log file.
   2. To modify the database parameter values, click Tune database parameters.
      The Database parameters window opens.
   3. In the Database parameters window, specify values for the following database parameters:
      1. In the Database heap field, enter the maximum memory in pages to set for database heap. The database heap contains control block information for tables, indexes, table spaces, and buffer pools. It also contains memory for the log buffer and temporary memory that is used by utilities.
      2. In the Package cache size field, enter the size in pages to cache the sections for static and dynamic SQL and XQuery statements on a database.
      3. In the Log buffer size field, enter the size in pages for the buffer that must be allocated for log records. You must specify the amount of the database heap to use as a buffer for log records.
      4. In the Maximum database files open per application field, enter the maximum number of file handles that can be open for each database agent.
      5. In the Changed pages threshold field, enter the percentage of changed pages.
      6. In the Sort heap size field, enter the maximum size for sort heap in pages. The sort heap can be used as private memory pages for private sorts or as shared memory pages for shared sorts.
      7. In the Log file size field, enter the size in KB for the log files. This parameter defines the size of each primary and secondary log file.
      8. In the Database log path field, enter the location where you want to store the log files. You can click Browse to specify the location.
      9. To save the set values and to update the database parameters with the values, click OK. If you do not specify values for parameters, the default values are set.
5. To confirm whether to update the directory and database settings with the tuning values, choose one of the following options:
   • To update the tuning settings for your directory server instance, click Yes, use the recommended values to update the directory and database configuration settings.
   • If you do not want to use the tuning settings, click No, keep the current settings. No configuration settings will be updated.
6. To apply the changes, click Finish.
7. To confirm the task completion, click OK.
8. Verify the logs that are generated when the tuning settings are updated.
9. To clear the logs, click Clear results.
10. To close the Performance tuning page, click Close.
11. To close the Configuration Tool window, click File > Exit.
12. To confirm your action, click Yes.