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