Notes® database activity logging

Notes® database activity logging tracks Notes® database activity that occurs during a server session. Database records include such information as the name of the database, the name and address of the database user, the number of documents read and written, the number of bytes read and written, the total number of transactions executed in the database, and the length of time the database was open. Servers, users, and API programs can all generate database activity.

There are five types of activity logging records for database activity:

  • Open records, which log when a database opens
  • Checkpoint records, which log activity that occurs when a database has been open for a specified length of time
  • Close records, which consolidate all log information for a database session into a single record when a database closes
  • CloseEnd records, which consolidate database information at the end of a Notes® session (when the client logs off of the server)
  • MailDeposit records, which log when a mail message that does not contain an attachment is deposited into MAIL.BOX. (Mail messages that contain attachments generate Open records, Close records, and possibly Checkpoint records.)

This table contains a few examples of the types of activities that generate each type of database record.

Table 1. Records and activities

Type of record

Type of activity

Open
  • Opening a database or any action that opens a database, such as checking database properties
  • Starting replication, including opening a database to determine if replication is needed (even if no replication is needed).
    Note: When Domino® closes databases after determining that replication is not necessary, it generates a Close record that contains 0 (zero) in the Duration field.
  • Having a remote server open another server's MAIL.BOX

Checkpoint
  • Editing documents
  • Saving and updating documents
  • Viewing or changing an ACL
  • Performing any other database activity while a database is open

Close
  • Closing a database
  • Ending replication
  • Logging off, either manually or automatically (one record for each open database)
  • Exiting Notes® (one record for each open database)
  • Having a remote server close MAIL.BOX

CloseEnd
  • Closing a database at the end of a session
  • Closing databases that the server opened for replication
  • Logging off of Notes®
  • Exiting Notes®

CloseEnd records log the total activity in a database during a Notes® session. Each time a user opens and closes a database during a session, Domino® creates separate database Open and Close records. When the user closes the Notes® session, Domino® generates a CloseEnd record for each database that was open during the session. The CloseEnd record consolidates the total activity in the database during the entire Notes® session. Therefore, if you open and close a database several times during a Notes® session, Domino® generates multiple Open and Close records for that database, but only one CloseEnd record.

MailDeposit

Depositing a mail message that does not contain an attachment into MAIL.BOX