Solved

Alternative for IBM DB2 Client

Posted on 2008-06-26
14
1,234 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
  • 7
  • 6
14 Comments
 
LVL 45

Expert Comment

by:Kdo
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:Kdo
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
 

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:Kdo
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:Kdo
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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:
Kdo 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:Kdo
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:Kdo
ID: 21924658
Hi SummerWine,

Welcome to Experts Exchanged.   :)


Kent
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Creating and Managing Databases with phpMyAdmin in cPanel.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

757 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now