38.5 Optimizing Database Maintenance

If you run only one POA for the post office, you can adjust the number of database maintenance threads. If database maintenance needs are extremely heavy for a post office, you can set up a dedicated database maintenance POA to meet those needs.

38.5.1 Adjusting the Number of POA Threads for Database Maintenance

The POA by default performs a certain amount of database maintenance. In addition, you can create your own customized maintenance events as described in Section 36.4.1, Scheduling Database Maintenance and Section 36.4.2, Scheduling Disk Space Management.

By default, the POA starts one thread to handle all POA scheduled events and also all usage of the Mailbox/Library Maintenance feature in ConsoleOne.

To adjust the number of POA database maintenance handler threads:

  1. In ConsoleOne, browse to and right-click the POA object, then click Properties.

  2. Click GroupWise > Maintenance to display the Maintenance page.

    Maintenance property page
  3. Increase the number in the Maintenance Handler Threads field.

  4. Click OK to save the new thread setting.

    ConsoleOne then notifies the POA to restart so the new setting can be put into effect.

Corresponding Startup Switches You can also use the /gwchkthreads switch in the POA startup file to increase the number of POA threads started for database maintenance activities.

POA Web Console The Status page helps you assess whether the POA is currently meeting the database maintenance needs of the post office. Under the Thread Status heading, click GWCheck Worker Threads to display the workload and status of the database maintenance handler threads.

If the POA Web console is password protected as described in Section 37.2.1, Setting Up the POA Web Console, you can change the number of database maintenance handler threads on the Configuration page. Under Performance Settings, click Maximum GWCheck Worker Threads.

38.5.2 Configuring a Dedicated Database Maintenance POA

If a large amount of database maintenance needs to be performed for a post office, you can set up a dedicated database maintenance POA so that the database maintenance activities do not impact other POA activities, such as responding to GroupWise client users.

  1. Create a new POA object for the post office as described in Section 36.1.1, Creating a POA Object in eDirectory.

  2. Right-click the new POA object, then click Properties.

  3. Click GroupWise > Maintenance to display the Maintenance page.

    Maintenance property page
  4. Make sure Enable Automatic Database Recovery is selected.

  5. Set Maintenance Handler Threads as needed.

    The maximum number of threads you can start for database maintenance is 8.

  6. Deselect Perform User Upkeep and deselect Generate Address Book for Remote. Make sure another POA handles these tasks.

  7. Set Disk Check Interval and Disk Check Delay as appropriate for the database maintenance events you plan to schedule.

  8. Click Apply to save the updated information on the Maintenance page.

  9. Click GroupWise > Scheduled Events, then create database maintenance events as needed, as described in Section 36.4.1, Scheduling Database Maintenance and Section 36.4.2, Scheduling Disk Space Management.

  10. Click GroupWise > Agent Settings.

  11. Deselect Enable Client/Server and set Client/Server Handler Threads to 0. Make sure another POA handles client/server processing.

  12. Click Apply to save the updated information on the Agent Settings page.

  13. Click GroupWise > QuickFinder.

  14. Deselect Enable QuickFinder Indexing. Make sure another POA handles indexing.

  15. Click OK to save the new settings for dedicated database maintenance processing.

  16. Install the POA software on a different server from where the original POA for the post office is already running. See Installing GroupWise Agents in the GroupWise 8 Installation Guide.

  17. Add the /name switch to the POA startup file and specify the name designated when you created the new POA object. Also add the /name switch to the startup file for the original POA.

  18. For the original POA:

    1. Add the ‑‑name switch to the original POA startup file to differentiate it from the new POA you have set up.

    2. Deselect Enable Automatic Database Recovery for the original POA object.

    3. Restart the original POA, so that it no longer performs the database maintenance activities you have set up a dedicated POA to perform.

  19. Start the dedicated database maintenance POA.

Corresponding Startup Switches You can also use the /nomf, /notcpip, /noqf, /nonuu, and /nordab switches in the POA startup file to disable unwanted processing, then use the /gwchkthreads switch to increase the number of database maintenance handler threads.