[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

best tool for DB2 database

Posted on 2010-08-23
11
Medium Priority
?
874 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
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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 26

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 26

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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
This article will show a step by step guide on how to mask column values in Oracle 12c using DBMS_REDACT full redaction option. This option is available on licensed Oracle Enterprise edition as part of Oracle's Advanced Security.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

591 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