Solved

best tool for DB2 database

Posted on 2010-08-23
11
762 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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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 24

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 24

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
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.

706 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

12 Experts available now in Live!

Get 1:1 Help Now