A database analysis database is designed to hold Results documents created by the Database Analysis tool in File - Tools - Server Administration.
Types of documents
This database has one type of document: Results. You read but do not create Results documents. Use the Database Analysis tool in File - Tools - Server Administration to create Results documents. The Database Analysis tool also creates new data analysis databases so you do not need to use File - Database - New.
Views and folders
You can view Results documents as follows:
The By Date view categorizes documents by the date the reported event occurred.
The By Event view categorizes documents by the type of event they describe.
The By Source view categorizes documents according to the server on which the event occurred.
The By Source DB view categorizes documents according to the source database for this transaction.
Special features worth exploring
This database is designed for use with the Database Analysis tool. The sections that follow, which can be found in Notes R4 Help and the
Notes R4 Database Administrator's Guide,
explain this feature.
About analyzing a database
The database analysis feature, useful for Notes administrators and database managers, collects information about a database from a variety of sources -- Replication History dialog box, User Activity dialog box, and the server Notes Log (LOG.NSF) -- and posts it in a single "results" database, created from the template Database Analysis (DBA4.NTF).
You can use database analysis to collect the following information about a database:
Replication history, as recorded in the Replication History dialog box for a database
User reads and writes, as recorded in the User Activity dialog box for a database and optionally the server Notes Log
Document creations, edits, or deletions as recorded in a database
Design changes as recorded in a database
Replicator additions, updates, and deletions as reported in the server Notes Log
Mail messages delivered by the mail router
You can also analyze the selected information on other replicas of the database.
Database analysis lets you collect this information in a central location so you're not required to look separately at the Replication History dialog box on a database, User Activity dialog box, Notes Log, and so on.
If you're analyzing a large database or multiple replicas, database analysis may take some time.
Running a database analysis
1. Choose File - Tools - Server Administration.
2. Click the Databases icon and choose Database Analysis.
3. Click Source Database and specify the server, title, and file name of the database you want to analyze. By default, the local Address Book is selected. Then click OK.
4. Click Results Database and specify a server, title, and file name of the database where you want to store the results. We recommend that you create the results database on your local workstation rather than on a server. To write to a server you must be able to create new databases there. If the specified results database already exists, select "Overwrite this database" to write over its contents or select "Append to this database" to add the new results to existing ones. Then click OK.
5. Next to "Report on the activity in the last: [ ] days,"
type the number of days' worth of information to report. The higher the number entered here, the longer it takes to generate the results.
6. Select one or more of the following options:
Replication history
User reads
User writes
Changes to documents
Changes to design
7. Select Replicas if you want to collect information from other replicas in addition to the one on the selected server.
8. Select Log file activity if you want the results database to include activity information relating to the database from the server Notes Log (LOG.NSF).
9. Select Log file events if you want the results database to include event messages relating to the database from the server Notes Log. You can only select this option if you have also selected Log file activity.
10. Click Start and Open if you want Notes to automatically open the results database when database analysis is complete. Otherwise, click Start.
Basic
Details: Running a database analysis
Results Database
It's recommended that you create the results database on your local workstation so that it won't conflict with searches conducted by other people; if you create the results database on a server, another person will be unauthorized to place search results in the same database. If you and others do create results databases on servers, each should specify different file names for the databases.
Report on the activity in the last: [ ] days
You can specify up to 99 days, although generally you'll want to select a much lower number so that the analysis occurs within a reasonable time and doesn't generate too many documents.
Replication history
Reports successful replications of a database as reported in the database replication history.
User reads
Reports the number of times users opened documents in the database and the number of times servers read documents.
User writes
Reports the number of times users or servers created, modified, or deleted documents based on information in a database User Activity dialog box. Also reports the number of documents the mail router delivered to the database.
Changes to documents
Reports details of document additions, edits, and deletions.
Changes to design
Reports changes to the database access control list and database design.
Log file activity
Reports database activity from the Usage - By User view of the Notes Log.
Log file events
Reports events relating to this database from the Miscellaneous Events view of the Notes Log.
Viewing the results of a database analysis
1. Select the results database (if you didn't automatically open it by choosing the Start and Open option when you ran the analysis).
2. Choose View and one of the following sub-views:
By Date
By Event Type
By Source
By Source DB
3. Open a document within the view.
Details: Viewing the results of a database analysis
Views
The By Date view categorizes documents by the date the reported event occurred.
The By Event view categorizes documents by the type of event they describe.
The By Source view categorizes documents according to the server on which the event occurred.
The By Source DB view categorizes documents according to the source database for this transaction.
Information in an analysis document
Each analysis document in the results database contains the following fields:
Date
The date the event occurred
Time
The time the event occurred
Source of Event Information
Where the information came from: the analyzed database (or its replicas) or the Notes Log on the server (LOG.NSF)
Event Type
The type of event. The types of events are:
Activity--number of user or server reads and writes as noted in the database user activity report. Events of this type appear if you select User reads and User writes as analysis options.
+Activity--number of user reads and writes as noted in the server Notes Log. Events of this type appear if you select Log file activity and User reads or User writes as analysis options.
Mail Router--number of documents delivered to the database. Events of this type appear if you select the analysis option User writes.
Data Note--details about document creations, edits, or deletions. Events of this type appear if you select the analysis option "Changes to documents."
Design Note--details about changes to the database access control list or design. Events of this type appear if you select the analysis option "Changes to design."
Replicator--replication history as reported in the database replication history indicating successful replications. Events of this type appear if you select the analysis option "Replication History."
+Replicator--number of replicator additions, updates, and deletions as reported in the server Notes Log.
Events of this type appear if you select the option "Log file activity."
Source Database
Displays the name of a database containing documents that were read.
For database replication events, displays the name of the database from which information was pulled.
Source
Displays the name of the server that stores a database containing documents that were read or written.
For database replication events, displays the name of the server that stores the database from which information is pulled.
Destination
Displays the name of a database on which documents were updated.
For database replication, displays the name of the database to which information was replicated.
Destination machine
Displays the name of a server that stores a database that was updated.
For database replication, displays the name of a server that stores a database to which information is replicated.
Description
Description of the event.
O=Lotus Notes
O=Lotus Notes
PURSAFO
|.:#U
O=Lotus Notes
CN=Lotus Notes Template Development/O=Lotus Notes
PURSAFO
Fde!f^^
$Info
$Body
Times New Roman
&Arial
About Database Analysis
Welcome to the Notes Database Analysis database. A database analysis database is designed to hold Results documents created by the Database Analysis tool in File - Tools - Server Administration. The Database Analysis tool creates a new database or appends to an existing one so you typically do not create this database with File - Database - New.
Choose Help - Using This Database for information on how to populate and use this database.
(.txt)