[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Access DB2 from Domino server 6.5.2 in Linux

Posted on 2004-10-22
Medium Priority
Last Modified: 2013-12-18

I've DECS running, I already have an ODBC conn with Easysoft's software with a SQL Server 2000 server, but I need to access also a DB2 under AS/400.

I have the DB2 driver (thank to IBM's iSeries Client Access for Linux) installed, and have the Agent executed "on server". It seems that the Domino can't see the DSN set in the Linux (configured with unixODBC's ODBCConfig).

Do I need to set something in the notes data directory or set an environment variable or something? :(

ayuda!! :P

thanks! :D
Question by:mmartha
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 31

Assisted Solution

qwaletee earned 1000 total points
ID: 12385518
Hi intouchsystems,

Domino executes under its own account, make sure that ODBC is configured properly for that account.  Don't know if it has teh concept of user v. system DSN's, but if so, make sure it is a system DSN.

Best regards,
LVL 19

Expert Comment

ID: 12397764
I will suspect many things. The installation of ODBC could be a problem. I hope your DB2 is installed properly. Have you made sure it is? It requires korn shell for a proper installation (not a part of standard Linux in most distributions).

My advice for you also would be to switch to WebSphere if you indeed want Linux. That's where the future is.
LVL 19

Expert Comment

ID: 12397785
intouchsystems? mmartha? QuickPost?
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 19

Accepted Solution

RanjeetRain earned 1000 total points
ID: 12397946
These pages may help you troubleshoot the problem and understand the things overall:

http://www.unixodbc.org/config.html - How to configure ODBC on Linux using unixODBC ODBCConfig
unixODBC without the GUI      http://www.unixodbc.org/odbcinst.html http://www.unixodbc.org/config.html
Linux Web Hosting with WebSphere, DB2, and Domino      http://www.redbooks.ibm.com/redbooks/pdfs/sg246007.pdf http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg246007.html?Open


Author Comment

ID: 12401848
Hi all!

I have no access to modify the DB2, it is already running. It is a system DSN, and was configured by the DB2 administrator (so all the connection data must be OK).

While installing the conn DSN for the SQL Server, I had to add a link in the /opt/lotus/notes/latest/linux directory "to the real unixODBC's libodbc.so which is in /usr/local/easysoft/unixODBC/lib" according to the driver's manufacturer(http://www.easysoft.com/products/2002/lotus.phtml).

That's why I was thinking that maybe, after the installation of the DB2 driver, and the proper configuration of the system DSN for the DB2 server, I needed to add some kind of link too, so the Domino Server could "see" the driver, or the DSN.

It is my believe that after de configuration of the DSN, all programs should be able to use it trough simply call it with its name. (my DSN's name is DB2).

I found out in http://www.unixodbc.org/doc/db2.html some commands like "isql -v login password". When I do that, or when I use the "example" command of Data Direct's driver (www.datadirect.com) I get a succesfull connection. So I don't think the connection is the issue.

I don't know if all this info helps at all.

I'm not sure what's the deal about my nickname. :S

LVL 31

Expert Comment

ID: 12403455
As Ranjeet surmised, my QuickPost somehow confused your handle with someone else's.  (QuickPost is a quick access utility for experts to find and respond to questions.)

EasySoft is an ODBC bridge provider.  I don't know much about those.  I would suggest first getting a simple text ODBC driver working, amke sure it works under multiple logon accounts.   You can then progress to the more sophisticatd stuff.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question