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

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:

 
Table 1. Schedules for database maintenance.
Recommended alternatives for database maintenance

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

•
Domino domains
•
Lotus and IBM Notes servers

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.

To delete object data from the database
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.
4
Select the domains and/or the servers that you want to delete.
5
Click Delete.
6
Verify that you want to delete the object information.
 
* 
TIP: If you delete all the Domino servers in a domain, remember to delete the Domino domain as well. Otherwise, the domain still appears in the treeview. Since you have deleted the server that contains the primary Domino Directory that is used to enumerate the domain, any tasks run against the domain will fail.

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:

•
Processed tracking log information
•
Processed Exchange object data
•
Statistical information about your use of MessageStats (such as gathering status and last gathering)
•
Region definitions
•
Server properties information
•
Default filter options
To delete all data 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.
4
Verify that you want to delete the data.

Setting Task Default Properties

•
Configuring Task Default Properties
•
Specifying Lotus and IBM Notes Credentials
•
Changing Task Credentials
•
Changing the Schedule for a Task
•
Enabling Task Logging
•
Setting Task Retry Attempts
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating