?
Solved

best tool for DB2 database

Posted on 2010-08-23
11
Medium Priority
?
813 Views
Last Modified: 2012-05-10
Hi,

I am newbie to DB2.previosuly i used oracle db for all the projects.for new project i had to ujse DB2.
for oracle i used below tools for writing sql statements,exporting data to excel ,exporting data into SQL scripts etc..so many features are there in the below tools.apart from that I can also create my own shortcuts like without writing full table names.i think we cannot these below tools for DB2.it is specific to oracle only.Is there any tool for DB2 also which will have same features.

TOAD
pl/sql developer (allround automations)
0
Comment
Question by:chaitu chaitu
[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
  • 4
  • 3
  • 2
  • +2
11 Comments
 
LVL 8

Accepted Solution

by:
Rindbaek earned 1200 total points
ID: 33499854
0
 
LVL 20

Author Comment

by:chaitu chaitu
ID: 33499917
other than TOAD are there any other tools which will give me these features???
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 33499955
Certainly but toad fulfill my needs so i never had to look any further.

but IBM have this one: DB2 Development Center
and there is also EMS SQL MANAGER:
http://www.sqlmanager.net/products/db2/manager
0
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 
LVL 20

Author Comment

by:chaitu chaitu
ID: 33500016
what is DB2 LUW solutions and DB2 z/OS solutions ???which db2 tool i need to download in toad site??
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 33500040
LUW = Linux Unix Windows
z/OS = an IBM mainfraime

you need to download the version that match the OS that the database is running on. Most likely the LUW.
0
 
LVL 20

Author Comment

by:chaitu chaitu
ID: 33500075
i am downloading both toad DB2 LUW and also DB2 EMS SQL MANAGER:
let me check which one is good.
can i create my own shortcuts in above tools like

if i type S and press enter it should print SELECT
like wise if i type some table name short cut as EM it should print EMPLOYEE .

syntax highlighting and bracket clsing etc.. will come in these tools?
0
 
LVL 8

Expert Comment

by:Rindbaek
ID: 33500086
I would expect them to do so, yes.
0
 
LVL 46

Assisted Solution

by:Kent Olsen
Kent Olsen earned 400 total points
ID: 33500301
Hi chaituu,

Before buying a licensed copy of anything, check out the free options.

IBM's own tool, the IBM Data Studio, is free and works very, very well.  

  http://www.ibm.com/developerworks/downloads/im/data/


I also like the Aqua Data Studio from AquaFold.

  http://www.aquafold.com/downloads.html


It doesn't have all of the admin functionality that TOAD and the IBM Data Studio do,  but from a developer standpoint, it allows you to a common interface for almost all modern DBMS.  It supports DB2, Oracle, MySQL, PostGreSql, SQL Server, Informatix, and several more.



Good Luck,
Kent
0
 
LVL 27

Expert Comment

by:tliotta
ID: 33515044
what is DB2 LUW solutions and DB2 z/OS solutions ?

When you ask a question like that one, we wonder what platform you are running DB2 on. The "best" tools might be different for different platforms. What version of DB2 are you working with?

Tom
0
 
LVL 25

Assisted Solution

by:Tomas Helgi Johannsson
Tomas Helgi Johannsson earned 400 total points
ID: 33515873
          Hi!

Try IBM Data Studio 2.2 which is a very good tool. I use it to manage both DB2 v. 9.1 on LUW as well as DB2 v.9.1 Z/OS
http://www-01.ibm.com/software/data/optim/data-studio/features.html?S_CMP=rnav
http://www-01.ibm.com/support/docview.wss?uid=swg24025984
http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.ds.release.doc/topics/release_ds22.html

This is very similar to the Oracle SQL Developer but native to DB2. :)

Regards,
     Tomas Helgi
0
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 33515903
The DB2 Data Studio standalone runs on RedHat Linux, Suse Linux or Windows
http://www.ibm.com/developerworks/downloads/im/data/

Regards,
     Tomas Helgi
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

777 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