Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1280
  • Last Modified:

Alternative for IBM DB2 Client

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
rharivenkatesh
Asked:
rharivenkatesh
  • 7
  • 6
1 Solution
 
Kent OlsenData Warehouse Architect / DBACommented:
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
 
Kent OlsenData Warehouse Architect / DBACommented:

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
 
rharivenkateshAuthor Commented:
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
rharivenkateshAuthor Commented:
We are using UDB. More over this alternative for DB2 Client we need to access DB2 database tables and do querying.
0
 
Kent OlsenData Warehouse Architect / DBACommented:

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
 
rharivenkateshAuthor Commented:
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
 
Kent OlsenData Warehouse Architect / DBACommented:

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
 
rharivenkateshAuthor Commented:
That is not possible. Do you know any client that can be used with less cost than DB2 Client.
0
 
rharivenkateshAuthor Commented:
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
 
Kent OlsenData Warehouse Architect / DBACommented:

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
 
rharivenkateshAuthor Commented:
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
 
Kent OlsenData Warehouse Architect / DBACommented:

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
 
SummerWineCommented:
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
 
Kent OlsenData Warehouse Architect / DBACommented:
Hi SummerWine,

Welcome to Experts Exchanged.   :)


Kent
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now