DOMINO AND DB2


Databases created with Domino
The information in this topic is unique to the IBM® Lotus® Domino™ with IBM® DB2 Universal Database™ Enterprise Server Edition configuration. For information about creating IBM® Lotus® Notes® databases, see the Domino Administrator printed or online documentation.

For information about creating databases in IBM® DB2 Universal Database™, go to the DB2 Information Center at http://publib.boulder.ibm.com/infocenter/db2help/index.jsp

Database storage

When you run the DB2 Server Enablement Tool from the Domino Administrator or the Domino Web Administrator, you specify a number of parameters. One of these is the default database storage type of either DB2 or NSF that is assigned to all databases that you create. By default, the database storage type is DB2, but you can change that to NSF on the DB2 tab of the Server document. When NSF is the default database storage type, new databases are created as files in the Domino server's disk space. When DB2 is the default database storage type, the databases are stored in a DB2 database managed by the DB2 server. "Classic" Domino databases are referred to as NSF databases, and NSFs stored in a DB2 database and managed by a DB2 server are referred to as DB2 enabled Notes databases.

Only databases stored in DB2 can be accessed in DB2 using SQL. Databases created with an NSF are not visible to DB2. NSFs and DB2 enabled Notes databases are visible to the Domino server.

Each DB2 enabled Notes database can be identified by the following icon in the Files panel of the Domino Administrator:

Icon representing DB2 enabled Notes database

Databases not supported as DB2 enabled Notes databases

The Domino tasks listed in the following table create databases in NSF format on DB2 enabled Domino servers.

Note Do not create replicas for these .NSF files on a DB2 enabled Domino server:
TaskCommand to run taskDescriptionDatabase
Activity Trends CollectortrendsRuns the Activity Trends Collector which performs historical and trended analysis on Domino Activity data.activity.nsf
Administration ProcessAdminPAutomates a variety of administrative tasks.admin4.nsf
BillingBillingCollects all generated billing information.billing.nsf
CatalogerCatalog Updates the database catalog. catalog.nsf
Cluster Database Directory ManagerCldbdirUpdates the cluster database directory and manages databases with cluster-specific attributes.cldbdir.nsf
Event MonitorEvent Monitors events on a server.events4.nsf
HTTP ServerHTTPEnables a Domino server to act as a Web server so browser clients can access databases on the server.webadmin.nsf
IMAP ServerIMAPEnables a Domino server to act as a maildrop for IMAP clients.mail files for IMAP users/mail#.ntf
LDAP ServerLDAPEnables a Domino server to provide LDAP directory services to LDAP clients.schema.nsf
MTCMTCReads log files produced by the router and writes summary data about message traffic to a database for message tracking purposes.mtstore.nsf
RouterRouter Routes mail to other servers. mail.box
Rooms & Resource ManagerRnRMgrProcesses all Rooms and Resources activities, such as meeting invitations, reschedules or cancellations, and updates the Busytime database accordingly.clubusy.nsf or busytime.nsf
Schedule managerSchedProcesses all user calendar activities and updates the Busytime database accordingly.clubusy.nsf or busytime.nsf
SMTP listenerSMTPListens for incoming SMTP connections, enabling Domino to receive mail from other SMTP hosts.mail*.box
The databases in the following table are not supported as DB2 enabled Notes databases in Domino and DB2.

Note Do not create replicas for these .NSF files on a DB2 enabled Domino server:
DatabaseUsageDescriptionFrom template
DA.NSFDirectory AssistanceThe Domino server uses directory assistance to look up information in a directory other than a local primary Domino Directory (NAMES.NSF).DA50.NTF
DBDIRMAN.NSFDomino ServerKeeps information about all Notes databases on the Server.DBDIRMAN.NTF
DDM.NSFAdmin Client, Domino ServerDomino Domain Monitoring provides one location in the Domino Administrator client that you can use to view the overall status of multiple servers across one or more domains.DDM.NTF
DIRCAT.NSFDomino server, Notes ClientDirectory catalog is an optional directory database that typically contains information aggregated from multiple Domino Directories.DIRCAT5.NTF
DOMCHANGE.NSFRunJava taskThe Domino Change Control database is used by the Domino Change Manager process to manage and execute change control plans. It includes an approval cycle workflow and tight integration with the Administration Process.domchange.ntf
INETLOCKOUT.NSFDomino serverThe first time the lockout database needs to be looked at or written to, it is created using the template inetlockout.ntf. The template is included in server installation and is run during runtime. By default, the ACL allows access to Administrators only. The Default access setting is No Access. inetlockout.ntf
ISPY50.NSFISY server taskThis database is created automatically by the ISpy server task for its mail probing activities. mail#.ntf
LOG.NSFDomino Server, Notes ClientNotes Log created at Domino server startup. Records and stores information about all types of Domino server activities and remote workstation communication activities.LOG.NTF
NAMES.NSFDomino Server, Notes ClientDomino Directory PUBNAMES.NTF
RESRC8.NSFAdmin Client, Notes ClientResource Reservation DatabaseRESRC8.NTF
STATREP.NSFStatistic Collector TaskMonitoring Results Database (formerly Statistics Reporting) contains statistics for one or more servers in a domain (gathered by the Statistic Collector Task).STATREP5.NTF
WEB.NSFAveraging agentThe Averaging Agent collects ratings that the users assign to Web pages and calculates the rating of pages in the Web Navigator database.
See also