Notes 7 and DB2

HCL Domino Domino Forum
1

Greetings

I just want to know after release of the Notes & DB2 connectivity, are the organisation adopting this new feature. Please share your view and experience about the same

thank you.

2

Subject: It would probably be better if you asked this in the Domino and DB2 Forum

http://www-10.lotus.com/ldd/d7db2.nsf/DateAllThreadedWeb?OpenView

Learn more at my Lotus Notes Tips and Tricks Blog

Alan Lepofsky - Competitive Marketing Intelligence - IBM/Lotus

3

Subject: RE: It would probably be better if you asked this in the Domino and DB2 Forum

Thanks Alan - I didn’t know about that forum (or maybe I did and forgot).

I actually think that the question was asked in the correct forum as the answers from the Domino and DB2 forum would be biased.

My company would LIKE to use the DB2 functionality but it’s not obvious (to us at least) how to turn it on.

We’re probably going to get our Lotus Partner to set it up for us, which is a bit sad when, in theory there should be a straightforward installation procedure.

I like the idea of running a setup program myself.

Gavin.

4

Subject: “I like the idea of running a setup program myself.”…

Is there a specific part of the install/configuration (“turning it on”) that you are currently having difficulty with?

http://www-10.lotus.com/ldd/d7db2.nsf

Domino Administrator Client, Domino Server

Installing Domino 7 and DB2 on Microsoft Windows

The Domino Administrator 7 documentation contains several procedures for installing Domino 7 and DB2 on Microsoft Windows platforms:

Installing and setting up Domino and DB2 on Microsoft Windows - Local configuration

Installing and setting up Domino and DB2 and the DB2 Access server on Microsoft Windows - Local configuration

Installing and setting up Domino and DB2 on Microsoft Windows - Remote configuration

Installing and setting up Domino and DB2 and the DB2 Access server on Microsoft Windows - Remote configuration

In each topic, the order of the steps in the procedure has changed. The steps instructing you to determine whether you have a DB2 control group have been moved. The revised procedures are shown below:

Installing and setting up Domino and DB2 on Microsoft Windows - Local configuration

Install and set up the Domino server and the Domino Administrator. For instructions, see Chapters 1 - 3 of Administering the Domino System, or see the Domino Administrator 7 Help.

When you start the Domino server, you are prompted to specify whether to run Domino as an application or a Windows service. Choose application.

Create an installation user account.

Install DB2 on Microsoft Windows.

Create a DB2 administrator account.

On the Domino server, permanently enable transaction logging.

Note To use a DB2 enabled Notes database, transaction logging must be turned on in Domino. Linear, circular or archival transaction logging may be used. DB2 enabled Notes databases do not work if transaction logging is not enabled.

For information about setting up transaction logging, see the topic Setting up a Domino server for transaction logging.

  1. Enable the Domino server to communicate with the DB2 server.

  2. Determine whether your DB2 configuration has a SYSCTRL group by entering this command from the DB2 Command Line Processor (CLP):

GET DBM CFG

  1. If your DB2 configuration has a SYSCTRL_GROUP, you can omit this step. If your DB2 configuration does not have a SYSCTRL_GROUP, set up DB2DOM as the SYSCTRL_GROUP in DB2 by entering this command from the DB2 CLP:

Update dbm cfg using SYSCTRL_GROUP DB2DOM

  1. Update the DB2 configuration by entering these commands from the CLP window:

DB2STOP

DB2START

  1. Restart the Domino server and the Domino Administrator.

  2. After Domino creates the initial DB2 database, stop the Domino server.

  3. Map the DB2 user name to a Notes user name.

You are now ready to create views.

Installing and setting up Domino and DB2 and the DB2 Access server on Microsoft Windows - Local configuration

Install and set up the Domino server and the Domino Administrator. For instructions, see Chapters 1 - 3 of Administering the Domino System, or see the Domino Administrator 7 Help.

When you start the Domino server, you are prompted to specify whether to run Domino as an application or a Windows service. Choose application.

Create an installation user account.

Install DB2 on Microsoft Windows.

Create a DB2 administrator account.

On the Domino server, permanently enable transaction logging.

Note To use a DB2 enabled Notes database, transaction logging must be turned on in Domino. Linear, circular or archival transaction logging may be used. DB2 enabled Notes databases do not work if transaction logging is not enabled.

For information about setting up transaction logging, see the topic Setting up a Domino server for transaction logging.

  1. Create a server ID for the DB2 Access server.

  2. Install the DB2 Access server on the server running DB2.

  3. Enable the Domino server to communicate with the DB2 server.

  4. Determine whether your DB2 configuration already has a SYSCTRL group by entering this command from the DB2 Command Line Processor (CLP):

GET DBM CFG

  1. If your DB2 configuration has a SYSCTRL_GROUP, you can omit this step. If your DB2 configuration does not have a SYSCTRL_GROUP, set up DB2DOM as the SYSCTRL_GROUP in DB2 by entering this command from the DB2 CLP:

Update dbm cfg using SYSCTRL_GROUP DB2DOM

  1. Update the DB2 configuration by entering these commands from the CLP:

DB2STOP

DB2START

  1. Restart the Domino server and the Domino Administrator.

  2. After Domino has created the initial DB2 database, stop the Domino server.

  3. From the Domino server console, enter

DB2 ACCESS SET

  1. To verify that the DB2 Access server is installed and configured properly, use the Test DB2 Access feature from the Domino Administrator client.

  2. Map the DB2 user name to a Notes user name.

You are now ready to create views.

Installing and setting up Domino and DB2 on Microsoft Windows - Remote configuration

Install and set up the Domino server and the Domino Administrator. For instructions, see Chapters 1 - 3 of Administering the Domino System, or see the Domino Administrator 7 Help.

When you start the Domino server, you are prompted to specify whether to run Domino as an application or a Windows service. Choose application.

Create an installation user account.

Install DB2 on Microsoft Windows.

Create a DB2 administrator account.

On the Domino server, permanently enable transaction logging.

Note To use a DB2 enabled Notes database, transaction logging must be turned on in Domino. Linear, circular or archival transaction logging may be used. DB2 enabled Notes databases do not work if transaction logging is not enabled.

For information about setting up transaction logging, see the topic Setting up a Domino server for transaction logging.

  1. Install the DB2 Run Time Client on the same system as the Domino server.

  2. Enable the Domino server to communicate with the DB2 server.

  3. Determine whether your DB2 configuration already has a SYSCTRL group by entering this command from the DB2 Command Line Processor (CLP):

GET DBM CFG

  1. If your DB2 configuration has a SYSCTRL_GROUP, you can omit this step. If your DB2 configuration does not have a SYSCTRL_GROUP, set up DB2DOM as the SYSCTRL_GROUP in DB2 by entering this command from the DB2 CLP:

Update dbm cfg using SYSCTRL_GROUP DB2DOM

  1. Update the DB2 configuration by entering these commands from the CLP window:

DB2STOP

DB2START

  1. Restart the Domino server and the Domino Administrator.

  2. After Domino creates the initial DB2 database, stop the Domino server.

  3. Map the DB2 user names to Notes user names.

You are now ready to create views.

Installing and setting up Domino and DB2 and the DB2 Access server on Microsoft Windows - Remote configuration

Install and set up the Domino server and the Domino Administrator. For instructions, see Chapters 1 - 3 of Administering the Domino System, or see the Domino Administrator 7 Help.

When you start the Domino server, you are prompted to specify whether to run Domino as an application or a Windows service. Choose application.

Create an installation user account.

Install the DB2 server on Microsoft Windows.

Create the DB2 administrator account.

On the Domino server, permanently enable transaction logging.

Note To use a DB2 enabled Notes database, transaction logging must be turned on in Domino. Linear, circular or archival transaction logging may be used. DB2 enabled Notes databases do not work if transaction logging is not enabled.

For information about setting up transaction logging, see the topic Setting up a Domino server for transaction logging.

  1. Install the DB2 Run-Time Client on the same system as the Domino server.

  2. Create a server ID for the DB2 Access server.

  3. Install the DB2 Access server on the server running DB2.

  4. Enable the Domino server to communicate with the DB2 server available in the Domino Administrator.

  5. Determine whether your DB2 configuration already has a SYSCTRL group by entering this command from the DB2 Command Line Processor (CLP):

GET DBM CFG

  1. If your DB2 configuration has a SYSCTRL_GROUP, you can omit this step. If your DB2 configuration does not have a SYSCTRL_GROUP, set up DB2DOM as the SYSCTRL_GROUP in DB2 by entering this command from the DB2 CLP:

Update dbm cfg using SYSCTRL_GROUP DB2DOM

  1. Update the DB2 configuration by entering these commands from the CLP window:

DB2STOP

DB2START

  1. Restart the Domino server and the Domino Administrator.

  2. After Domino has created the initial DB2 database, stop the Domino server.

  3. From the Domino server console, enter

DB2 ACCESS SET

  1. To verify that the DB2 Access server is installed and configured properly, use the Test DB2 Access feature from the Domino Administrator client.

  2. Map the DB2 user name to a Notes user name.

You are now ready to create views.

5

Subject: Notes 7 and DB2

Thank you All, for your responses.

Regards