Database analysis

You can perform a database analysis to collect information about one or more databases from a variety of sources -- the replication history, the User Activity dialog box, and the log file (LOG.NSF) -- and view it in a single "results" database. You can perform a database analysis only if you have access to the Domino® Administrator.

Use database analysis to collect the following information about a database:

Replication history, as recorded in the Replication History dialog box
User reads and writes, as recorded in the User Activity dialog box (one way of viewing database activity statistics generated by the Statlog task)
Document creations, edits, and deletions, as recorded in a database
Design changes, as recorded in a database
Replication additions, updates, and deletions, as reported in the log file
Mail messages delivered by the mail Router

You can collect this information from multiple replicas of a database.

When you perform a database analysis, you create a database that holds the results, which are stored in analysis documents. After you create a results database, each time you perform a database analysis, you can choose to overwrite its contents or append new results to its contents. The results database is created from the Database Analysis (DBA4.NTF) template.

Each analysis document in the results database contains fields that describe a particular event.

Table 1. Fields and events
Field	Describes
Date	Date of the event
Time	Time of event
Source of Event Information	The analyzed database or its replicas or the log file
Source Database	Name of a database containing documents that were read For database replication events, name of database from which information was pulled
Source	Name of server that stores a database containing documents that were read or written For database replication events, name of server that stores the database from which information was pulled
Destination	Name of a database on which documents were updated For database replication, name of the database to which information was replicated
Destination machine	Name of a server that stores a database that was updated For database replication, name of a server that stores a database to which information is replicated
Description	Description of the event

Analysis documents describe these types of events:

Table 2. Types of events
Event	Describes	Required database analysis option
Activity	Number of user or server reads and writes generated by the Statlog task when monitoring database activity	User reads User writes
+Activity	Number of user reads and writes as noted in the database and in the log file	Log file activity User reads or User writes
Mail Router	Number of documents delivered to the database	User writes
Data Note	Document creations, edits, and deletions	Changes to documents
Design Note	Changes to the database ACL and design	Changes to design
Replicator	Replication history	Replication history
+Replicator	Number of replication additions, updates, and deletions, as reported in the log file	Log file activity