Solved

Alternative for IBM DB2 Client

Posted on 2008-06-26
14
1,264 Views
Last Modified: 2008-07-09
Hello Gurus,

Could anyone let me know if there is an Alternative for IBM DB2 with less cost (If possible without license cost). We need to access DB2 server in AIX server. Can we have any software alternative to IBM DB2 installed to access it for querying the database table. A good one.

Also is Visual Analyzer useful in this case?

Regards.
Hari.
0
Comment
Question by:rharivenkatesh
[X]
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
  • 7
  • 6
14 Comments
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 21874214
Hi Hari,

If you've got a DB2 server running, you should have access to the DB2 client.  It's performance is much better than the ODBC/JDBC drivers that are out there so if possible, try to use it.

What DB2 server are you running?


Kent
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 21874294

Here's a link to a list of popular JDBC drivers.  Interestingly, the DB2 driver is at the top of the list.  :)

  http://www.devx.com/tips/Tip/28818

If you're running a DB2 database, you should have some access to DB2 drivers and the client.


Kent
0
 

Author Comment

by:rharivenkatesh
ID: 21874307
Hello Kent,

DB2 Server is running in AIX machine in U.S. We need to access it from India. We need to buy more DB2 clients with license. So we trying to find alternatives to reduce cost.

Can you suggest any?

Regards.
Hari.
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

Author Comment

by:rharivenkatesh
ID: 21874330
We are using UDB. More over this alternative for DB2 Client we need to access DB2 database tables and do querying.
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 21874426

It sounds like you're working on and/or supporting someone else's DB2 environment.  They should have whatever licenses are necessary to get you the DB2 client.  You may be able to download it from them.


Kent
0
 

Author Comment

by:rharivenkatesh
ID: 21875222
Yes we are supporting and we need to buy licenses but cannot buy 50 or 60+. We want to reduce the cost.

Regards.
Hari.
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 21876921

Check with the people that host the DB2 database.  If they have a licensed version of DB2, they have the DB2 client and can get you a copy.


Kent
0
 

Author Comment

by:rharivenkatesh
ID: 21877368
That is not possible. Do you know any client that can be used with less cost than DB2 Client.
0
 

Author Comment

by:rharivenkatesh
ID: 21877493
Kent and All,
Could you please let me know Available list of DB2 database query tool client like TOAD and DB2 Client. I am taking a list and need this ASAP.
0
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 500 total points
ID: 21878481

Aqua Data Studios and the Advanced Query Tool are pretty good, too.

ADS is a lot cheaper than Toad, but I like them both.  AQT has some issues, but the layout is very good.


Kent
0
 

Author Comment

by:rharivenkatesh
ID: 21881118
Thanks a ton Kent. Does these 2 need mandatory installation IBM DB2 client or can it work independently with IBM DB2 installation?

This is because for Oracle, even though we use TOAD we still need installation of Oracel Client and setting up of the TNSNAMES.ora. I am not aware of DB2.

Thanks for your support.

Regards.
Hari.
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 21882829

The DB2 client doesn't have a tsnnames.ora file, but it does have its own configuration file.  You can edit it directly, but that's not for the timid or inexperienced.

I don't believe that and of those clients have a DB2 ODBC driver built into them.  But I haven't researched that in a while.


Kent
0
 

Expert Comment

by:SummerWine
ID: 21923630
Hari,

perhaps SQuirreL would help you. Has charts of tables and their relations too, but I think it's not any visual analyzer. And it's under "The GNU Lesser General Public License".

SummerWine
0
 
LVL 45

Expert Comment

by:Kent Olsen
ID: 21924658
Hi SummerWine,

Welcome to Experts Exchanged.   :)


Kent
0

Featured Post

Plug and play, no additional software required!

The ATEN UE3310 USB3.1 Gen1 Extender Cable allows users to extend the distance between the computer and USB devices up to 10 m (33 ft). The UE3310 is a high-quality, cost-effective solution for professional environments such as hospitals, factories and business facilities.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

622 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