Chat now with support
Chat with Support

MessageStats 7.8.1 - Report Pack for Lotus & IBM Notes User Guide

About the Lotus and IBM Notes Report Pack Preparing for Installation Configuring the Report Pack Database Management Setting Task Default Properties Creating Gathering Tasks Using the Reports Console Lotus and IBM Notes Report Descriptions Report Filter Definitions

About the MessageStats Database

The MessageStats Database stores the data that is used to render reports.

When you install the report pack, you provide the location of the database server. MessageStats stores that location and displays the location on the Database tab of the MessageStats Server Properties dialog box.

There are two database server implementations that you can use to store the collected data:

You can also employ a distributed database implementation.

Managing your MessageStats Database

The MessageStats Database stores the information that is used by the reports. When the database is properly tuned, information can be efficiently stored, and the reports can quickly access the required data. Over time, the database will grow, and the database server may become taxed. However, it is critical that the database retain enough data for any historical reporting needs that may arise.

Proper database management includes following the Microsoft best practices for backing up data and archiving historical data. To manage your database, you can use the Database Management functionality to selectively delete obsolete data and to tune the database for optimal performance.

Using Database Management

During the installation of the Lotus and IBM Notes report pack, additional tables are added to the MessageStats database in order to store Note-specific data. MessageStats allows you to manage the storage of Lotus and IBM Notes object data to prevent excessively rapid growth of the MessageStats database.

In MessageStats, database management functionality is extended to include database management functions specific to Lotus and IBM Notes data. Using Database Management, you can delete obsolete information and tune your database.

Before you modify your database, ensure that no consoles are currently writing information to the database. If you use Database Management while a console is writing to the database, you risk corrupting your database.

Select Database Management from the treeview.

The Database Management tool provides the following functionality:

Configuring an Aging Task

You can use the Data Aging function to delete the historical data from your database. The Lotus and IBM Notes Configuration option under the Data Aging node allows you to define the aging task for Lotus and IBM Notes data.

1
Expand the Database Management | Data Aging | Lotus and IBM Notes Configuration nodes in the treeview.
2
Select Delete aged data.
3
Select Age Statistics (days) check box.
5
Click Configure Job.
6
Select Daily, Weekly, or Monthly to indicate how often you want to delete the data older than your retention definitions.
7
Enter the Start Date and Start Time information.
8
Click to select the Limit Job Execution Time box if you want to limit the time duration for an aging job, and enter an end time.
10
Click Deploy.

After you create a job, the interface changes to a three-tab format:

Because the aging process is performed by a service, progress is recorded in the log journal for all database management activities.

The log information is available in the MessageStats log journal, so activity can be viewed on the MessageStats Gathering reports by filtering the Source field by Stats Data Aging or Audit Data Aging values.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating