Open Source Tool for DB2


 
Thread Tools Search this Thread
Operating Systems AIX Open Source Tool for DB2
# 1  
Old 12-29-2009
Question Open Source Tool for DB2

Dear Folks,
Please suggest any Open source db2 tool for working with SQL queries
# 2  
Old 12-29-2009
This DbVisualizer - The Universal Database Tool may not be open-source, but it is free and works fine with DB2.
Is this the answer you are looking for? Your question is a bit vague.
# 3  
Old 12-30-2009
What do you mean "work with SQL queries"? To check how effective they are or just to type and execute them?

My DB2 experience is back from v7 and v8, but in first case you should already have db2expln with your DB2 installation. It shows you if you queries do table scans, do use indexes, tell you the DB2-Dollar costs for your statements (the less the better) and so on. It shows it output in ASCII; there is also a tool that comes with the installation that shows this graphical - maybe it is part of the db2cc, I don't remember it, sorry.
For the second case you might want to use your favourite editor that might hopefully have the feature to highlight syntax, especially for SQL. You can then save that file maybe on the box and feed it the db2 command.

Btw. for performance purposes etc. there is a very neat monitor tool available for free:
http://www.db2mon.com
Login or Register to Ask a Question

Previous Thread | Next Thread

5 More Discussions You Might Find Interesting

1. Fedora

Is UNIX an open source OS ?

Hi everyone, I know the following questions are noobish questions but I am asking them because I am confused about the basics of history behind UNIX and LINUX. Ok onto business, my questions are-: Was/Is UNIX ever an open source operating system ? If UNIX was... (21 Replies)
Discussion started by: sreyan32
21 Replies

2. UNIX for Dummies Questions & Answers

query on the existence of open source tool

can anyone say me, is there any open source tool for generating either 2G or 3G traffic? If so exist, pls brief me about it. (0 Replies)
Discussion started by: routeme
0 Replies

3. Shell Programming and Scripting

Open Source

Hi Friends I'm new to this UNIX - I'm working on the porting project from Solaris To Linux i just want to map some commands from solaris to Linux so can any one please tell me how to get the source code of the commands like "ls", "cu", "du" Regards sabee (1 Reply)
Discussion started by: sabee.prakash
1 Replies

4. UNIX for Dummies Questions & Answers

how to open a text file using some tool such as gedit under gtk

how to open a text file using some tool such as gedit under gtk I list some text file names in a GtkCList . I want to open the file on when users click on the row. How to implement this ? Thanks (0 Replies)
Discussion started by: cy163
0 Replies

5. News, Links, Events and Announcements

source reader tool

Hi, can anybody give info on source reader tool?which platform does it wok on?and how it works (1 Reply)
Discussion started by: vijaya2006
1 Replies
Login or Register to Ask a Question