?
Solved

Alternative for IBM DB2 Client

Posted on 2008-06-26
14
Medium Priority
?
1,294 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 46

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 46

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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 

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 46

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 46

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 46

Accepted Solution

by:
Kent Olsen earned 2000 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 46

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 46

Expert Comment

by:Kent Olsen
ID: 21924658
Hi SummerWine,

Welcome to Experts Exchanged.   :)


Kent
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

599 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