2.14 Maintaining the Mobility Connector Database

The Mobility Connector database is named mobility. The default user for accessing the Mobility Connector database is datasync_user.

Database maintenance activities for the Mobility Connector database ensure satisfactory performance for mobile device users.

2.14.1 Performing General PostgreSQL Database Maintenance

The Mobility Connector database is a PostgreSQL database. As with any database, the Mobility Connector database requires regular maintenance in order to perform reliably. If you are new to managing a PostgreSQL database, see Routine Database Maintenance Tasks on the PostgreSQL Documentation Web site for assistance.

2.14.2 Configuring Automatic Nightly Maintenance

Most items synchronize automatically from GroupWise mailboxes to the Mobility Connector database. As a result, they are readily available when users want to manually synchronize the contents of specific folders. Over time, older items must be cleaned up on a regular basis to prevent degradation in Mobility Connector synchronization performance.

By default, the Mobility Connector automatically cleans up outdated items from the Mobility Connector database between midnight and 6:00 a.m. every day. It cycles through all users and all folders once each day. It checks the user-selected settings for each mobile device to determine the maximum age after which users no longer want items retained on their mobile devices.

You can adjust the time period during which the Mobility Connector performs nightly maintenance, and you can turn off nightly maintenance, if necessary.

  1. In Synchronizer Web Admin, click the Mobility Connector to display the Mobility Connector Configuration page.

  2. Click Edit XML Source.

  3. To adjust the time when nightly maintenance occurs:

    1. Locate the following line:

      <databaseMaintenanceStartHour>0</databaseMaintenanceStartHour>

    2. Using the 24-hour clock, change the start hour as needed for your Synchronizer system.

  4. (Optional) To turn off nightly maintenance:

    1. Locate the following line:

      <databaseMaintenance>1</databaseMaintenance>

    2. Change 1 to 0.

      IMPORTANT:This is not recommended. Without nightly maintenance, items accumulate in the Mobility Connector database indefinitely and reduce Mobility Connector performance over time.

  5. Click Save Custom Settings.

  6. Click Home on the menu bar to return to the main Synchronizer Web Admin page.

  7. In a terminal window, restart the Synchronizer services:

    rcdatasync restart

  8. In the Actions column for the Mobility Connector, click Stop Stop icon to stop the Mobility Connector, then click Start Start icon to start the Mobility Connector and apply the changes.

You can see what the Mobility Connector is doing as it performs its nightly maintenance by searching for MaintenanceMonitor in the Mobility Connector log file:

/var/log/datasync/default.pipeline1.mobility-AppInterface.log

If logging is set to Debug, the Mobility Connector logs each item that it deletes. This can result in a very large log file. Without the Debug log level, the Mobility Connector lists the users as it performs nightly maintenance for them. For more information about log levels, see Connector Logging Level in User Management in the Mobility Pack Administration Guide.