Solved

best tool for DB2 database

Posted on 2010-08-23
11
785 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 300 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift 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 45

Assisted Solution

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
oracle forms question 22 48
Huge BLOB data type in Oracle how to retrieve in vb.net and crystal reports 6 49
date show only hh:mm 2 40
Append Query Access 2010 4 26
Creating and Managing Databases with phpMyAdmin in cPanel.
Read about achieving the basic levels of HRIS security in the workplace.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

730 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