How to trim the BlackBerry Monitoring Service database size

Article ID: KB22559

Type: Support Content

Last Modified: 01-13-2012

 

Product(s) Affected:

  • BlackBerry Enterprise Server for Novell GroupWise
  • BlackBerry Enterprise Server for Microsoft Exchange
  • BlackBerry Enterprise Server for IBM Lotus Domino
Jump to: Environment | Overview
CollapseEnvironment
  • BlackBerry® Monitoring Service 5.0 SP1
  • DT639643
CollapseOverview
The BlackBerry® Monitoring Service stores statistical information into its database via the Data Collection Subsystem. By default it will limit it's database size to 4GB for Microsoft® SQL Server Express. However, Enterprise or Standard versions of Microsoft SQL Server have an unlimited database size.

In all Microsoft SQL Server versions the database size can be trimmed.

Step 1 - Configure the database size registry key

Warning: The following procedure involves modifying the computer registry. This can cause substantial damage to the Windows® operating system. Document and back up the registry entries prior to implementing any changes.

The TargetSize registry key is the value of the maximum desired size of the BlackBerry Monitoring Service database.

Path:
HKEY_LOCAL_MACHINE\SOFTWARE\Research In Motion\BlackBerry Enterprise Server\Monitoring Service\Database

Key:
TargetSize

Type:
DWORD

Value (in MB / example):
3200

Step 2 - Trim the database

1. In the command prompt navigate to the BlackBerry Monitoring Service tools directory:

X:\Program Files\Research In Motion\BlackBerry Enterprise Server\Monitoring Service\tools\

2. Type the following at the command prompt:

dcs_agent.exe trim

Disclaimer

By downloading, accessing or otherwise using the Knowledge Base documents you agree:

   (a) that the terms of use for the documents found at www.blackberry.com/legal/knowledgebase apply to your use or reference to these documents; and

   (b) not to copy, distribute, disclose or reproduce, in full or in part any of the documents without the express written consent of RIM.


Visit the BlackBerry Technical Solution Center at www.blackberry.com/btsc.