Solved

best tool for DB2 database

Posted on 2010-08-23
11
768 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 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
 
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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:Kdo
Kdo 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This article describes some very basic things about SQL Server filegroups.
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Via a live example, show how to take different types of Oracle backups using RMAN.

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now