Check out thwack Ambassador, Derek Schauland's newest post on Storage Arrays.
Also, don't forget to update your email address in your profile!
Search 140,365 posts and 1,367 resources contributed by 129,118 members or post a topic.

Already Joined? Sign in
Does APM require DB2 Connect installed on the APM server?

Page 1 of 1 (3 items) | RSS

rated by 0 users
Answered (Not Verified) This post has 0 verified answers | 2 Replies | 2 Followers | 125 Views


2 Posts
Points 4
boiseincsl replied on Fri, Jan 27 2012 2:13 PM
rated by 0 users

Am trying to connect to a DB2 V9.5 Linux server.

I've installed a v9.7fp5_nt32_odbc driver on the APM server.

On the APM server, looking at the installed drivers I see a "IBM Data Server Driver for ODBC - C:/Program Files/ibm/v9.7fp5_nt32_odbc_cli/bin"  listed.

In APM, while editting the "Database Used Space(MB)" in the Edit Application Template page, i've defined the connection string as follows (password x'd out):

Driver={IBM DATA SERVER DRIVER for ODBC - C:/Program Files/ibm/v9.7fp5_nt32_odbc_cli/bin};Database=DW;Hostname=${IP};Port=50002; Protocol=TCPIP;Uid=lxdsn;Pwd=xxxxxx;

I keep getting the following message:

Testing on node boslxdb01 (10.1.2.119): failed with 'Down' status

Data source name not found and no default driver specified.  

 

So am wondering if I need to install a DB2 Connect client on the APM server?

Or if anyone can give me some guidance, it would be appreciated.

Thank you,

Steve

  • | Post Points: 3

All Replies


2,084 Posts
Points 31,066
Moderator
SolarWinds Employee
Answered (Not Verified) aLTeReGo replied on Sat, Jan 28 2012 4:54 PM
rated by 0 users
IBM DB2.pdf
Suggested by aLTeReGo

I believe your database driver should be "Driver={IBM DB2 ODBC DRIVER}

I've attached some unofficial internal documentation for installing, configuring and monitoring IBM DB2 with APM. It's likely overkill for your needs but better too much than too little. I recommend you being reading on page 13.

  • Post Points: 3

2 Posts
Points 4
boiseincsl replied on Mon, Jan 30 2012 9:53 AM
rated by 0 users

aLTeReGo,

thank you for the assistance and the pdf... I was thinking I could get by with just an ODBC driver, but per your document, it appears I need other pieces. I have installed the DB2 Client, and now see this "IBM DB2 ODBC DRIVER" listed in the drivers on my APM server, and I now can successfully test my template.

Thanks again,

Steve

  • | Post Points: 1
Page 1 of 1 (3 items) | RSS

© 2003 - 2012 SolarWinds, Inc. All Rights Reserved.

Who is SolarWinds?

SolarWinds is rewriting the rules for how companies manage their networks. Guided by a global community of network engineers, SolarWinds develops simple and powerful network management software and network monitoring software for networks of all sizes. SolarWinds also offers a network certification program to become a SolarWinds Certified Professional (SCP).

What is thwack?

thwack, SolarWinds online community site, was designed by network engineers, for network engineers. thwack is a vibrant, growing community of more than 30,000 IT pros who share a passion for technology.

Explore Resources, Answers, Templates, and Advice

Download Free Networking Tools

Learn More About SolarWinds Products