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

Database Maintenance

The Database Maintenance node of the navigation tree contains the functionality for reindexing the individual database tables and defragmenting a database.

The Reindex option completely reindexes each table in the database. The Defragment option simply defragments the indexes. If you run the Reindex option, you do not need to run the Defragment option since there is nothing to defragment if all the indexes are new.

Using these functions can aid in reducing the time it takes to read data from and write data to the database:

Resource Intensive

Schedule the Reindex job to run every day after all the gathering tasks have completed.

Less Resource Intensive

Schedule the Defragment job to run every weekday (Monday through Friday) after all the gathering tasks have completed.

Schedule the Reindex job to run on the weekend (or once a month) after all the gathering tasks have completed.

Deleting Lotus and IBM Notes Object Data

This branch of the navigation tree provides the functions that delete object data and report data from the MessageStats database. You can use the Lotus and IBM Notes Object Data option to delete information about Lotus and IBM Notes server objects and any report data associated with the specified Notes server.

You can select objects including

If you delete a Domino domain, user report data is automatically deleted. If you delete a server, you have the option of deleting the user data or not.

1
Expand the Database Management | Deleting Data nodes in the treeview.
2
Select the Lotus and IBM Notes Object Data node.
3
Select Domains and/or Servers.
5
Click Delete.

Clearing the MessageStats Database

The Clear Database function allows you to delete all the information in your database.

The Clear Database function cannot be reversed. If you may need any of the information you intend to delete, create a backup of the database.

The following information is removed from the MessageStats database:

1
Expand the Database Management | Deleting Data nodes in the treeview.
2
Select the Clear Database node.
3
Click Clear Database.

Setting Task Default Properties

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating