How to configure DB2 on a single Lotus Domino server

Here are 10 simple steps to configure DB2 on a single standalone Lotus Domino server.

1. Create a new Microsoft Windows user account.

2. From the DB2 Command Line Processor, check whether your DB2 installation has a SYSCTRL_GROUP configured by entering the command:

   'GET DBM CFG'
   

3. If there is a SYSCTRL_GROUP configured, add the newly created Windows user account to that group. If it is not configured, create a new operating system group named 'DB2DOM' and configure this group as the SYSCTRL_GROUP. From the DB2 Command Line Processor, enter the command:

   'UPDATE DBM CFG USING SYSCTRL_GROUP DB2DOM' 
   

4. From the DB2 Command Line Processor, update the DB2 configuration by stopping and restarting DB2. Enter the command:

   'DB2STOP'
   

   Then, enter the command:

   'DB2START' command.
   

5. Set up your Lotus Domino server for transactional logging.

6. Manually copy the ndb2key.dll to C:program fileslotusDomino.

7. Open Domino Administrator -> Goto DB2 -> Edit server, and enter the following information:

   Port Number: 50000
   Instance: DB2
   Database: Domino
   Directory: c:db2dbsrvr
   DB Default Creation: DB2, to specify in which 
   format the Lotus Domino database will be created. 
   The default is .nsf.
   

8. Start the Lotus Domino server and make sure the Lotus Domino server for DB2 is enabled on the right side of the Domino Administrator UI.

9. Select "Enable Server DB2" and fill in the information required:

   DB2 Instance
   DB2 data store
   DB2 username password
   

10. Restart your Lotus Domino server.

To test your installation, create a new Lotus Domino database and check its properties. If it worked, it will show as a DB2-enabled database.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Ashutosh Chandra. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. Digg This!     StumbleUpon     Del.icio.us    RELATED CONTENT Lotus Notes Domino Database Management LotusScript agent parses ACL to Microsoft Notepad Domino Domain Monitoring hints and gotchas LotusScript code rebuilds corrupted busytime.nsf file LotusScript agent automates selective mail file replication Configuring Domino Domain Monitoring (DDM) How to move Notes databases off Domino 8 servers and save disk space What is Notes 8.5's DAOS (Domino Attachment and Object Storage) feature? LotusScript agent indexes Lotus Notes/Domino databases An introduction to Domino Domain Monitoring (DDM) 'Customize this view' options are disabled in Lotus Notes databases Server How to move Notes databases off Domino 8 servers and save disk space Move a Lotus Domino server to a new certifier without a reinstall Securely connect Lotus Domino servers on different domains Track and record Lotus Notes user logins to Domino Server Use SMTP outbound authentication to relay hosts in Lotus Notes Domino 8 Log off idle Lotus Notes users for better Domino Server performance Copy Lotus Notes databases from the Domino Server console command line How to perform an in-place upgrade of Lotus Domino server hardware Daylight Saving Time 2007 -- seven helpful tips for Lotus Notes administrators FileZilla Lotus Notes Domino Interoperability Display SharePoint data in a Lotus Notes Web application with Ajax Search Microsoft Active Directory with LotusScript Open a Lotus Notes database from Microsoft SharePoint 2007 Top 10 Lotus Notes/Domino administration tips of 2008 Can Lotus Notes/Domino and Microsoft SharePoint play nice together? IBM Lotus Notes versus Microsoft SharePoint: The rest of the story Fix Lotus Notes 8.0 issues when launching Microsoft Office applications A batch file for Lotus Notes Domino maintenance on Windows Server 2003 Lotus Notes and Microsoft SharePoint integration Running Lotus Notes Domino on Linux RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.