If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Domino Access to DB2

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-31-09, 14:48
bmarangoly bmarangoly is offline
Registered User
 
Join Date: Aug 2009
Posts: 4
Question Domino Access to DB2

Can someone help me configure my domino access to db2. When I use the enable server for db2 tool in Domino I get the following error:
(am I missing an ID or something?)

DB2 SERVER ENABLE LOG
Server id update completed
SQL10007N Message "-1390" could not be retrieved. Reason code: "3".

Catalog node completed
Error attempting to catalog node.

configurationis as follows:
domino 8.5 on suse linux 10 (one machine)
db2 9.7 enterprise server on windows (separate machine)

Thank you,
Betsy
Reply With Quote
  #2 (permalink)  
Old 08-31-09, 15:18
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Do you have the DB2 client installed on the Domino machine? If yes, what is its version? If not, you know what to do.
Reply With Quote
  #3 (permalink)  
Old 08-31-09, 16:05
bmarangoly bmarangoly is offline
Registered User
 
Join Date: Aug 2009
Posts: 4
Thank you for the post.
The version I have installed is 9.1
Reply With Quote
  #4 (permalink)  
Old 08-31-09, 16:31
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Make sure you are selecting the option that says something like "Domino and DB2 are on different servers". Also try cataloging the DB2 server manually.
Reply With Quote
  #5 (permalink)  
Old 08-31-09, 16:40
bmarangoly bmarangoly is offline
Registered User
 
Join Date: Aug 2009
Posts: 4
I did choose that option.

Could you give me some basics on cataloging the DB2 server manually. Do I do this where I installed DB2 Enterprise server (domino is on a separate machine). The DB2 ES is on Windows vista.

Thank you so much. I really want to get this connection working.
Reply With Quote
  #6 (permalink)  
Old 08-31-09, 16:55
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
Quote:
Originally Posted by bmarangoly
I did choose that option.

Could you give me some basics on cataloging the DB2 server manually. Do I do this where I installed DB2 Enterprise server (domino is on a separate machine). The DB2 ES is on Windows vista.
You need to catalog it on the client (which is Domino in your case). Make sure the DB2 client instance profile is executed, then type
Code:
db2 catalog tcpip node db2srv remote <ip address> server <port>
db2 catalog db <database> at node db2srv
Substitute the actual DB2 server IP address and port and a database that exists. Then try connecting, using the login ID that will be used by Domino to connect to DB2.
Reply With Quote
  #7 (permalink)  
Old 08-31-09, 17:23
bmarangoly bmarangoly is offline
Registered User
 
Join Date: Aug 2009
Posts: 4
Thank you.
Sorry I am a newbie at this -
How do I create a DB2 client instance profile on my Domino machine (the os is Suse Linux 10).
I am guessing that after that is created I will get the db2 prompt?
Right now, I know the db2 access client was installed and created an /opt/ibm/db2 directory.
Thanks again!
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On