Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 18, 2005

A Toad without Warts: Quest's Toad Product for DB2 Hits the Streets - Part 2 - Page 2

By DatabaseJournal.com Staff

by Paul C. Zikopoulos

SQL Recall

Toad for DB2 keeps a history (which lasts beyond the current session) of all the SQL statements you have run against your database – making it quick and easy to retrieve them for retest or base modeling purposes:


As with any rich development and administration environment, there is a debugger that handles variable modification, bookmarks, step through, breakpoints, execution stack exposures, and so on, for statement-by-statement debugging of your business logic (SQL/PL, triggers, and more). DBAs developing business logic can step through code as it executes on the server.

A sample Debugger screen is shown below. Note that I have included a breakpoint and bookmarks (1 and 2) into the simple SQL/PL procedure:

Using GUI controls, you can step through the Debugger code at will.

The 'and more...' part

Even in this two-part series, I cannot go into all of the features that are available in Toad for DB2 – it is such a comprehensive product. The following figure shows some of the features that I have mentioned (and some that I have not). The best way to see just how powerful and helpful this amazing product is would be to take it for a test drive:

Want to test drive Toad for DB2?

Want to test drive Toad for DB2 for yourself? Why not join the Quest Toad for DB2 beta program or download a trial copy when it finished? You can join at: http://www.toadsoft.com/toaddb2/toaddb2beta.html. By participating, you have an excellent opportunity to give feedback and direction to the future development of the product.

The beta program for Toad for DB2 began on September 2 nd, 2005. For the most part, you will find weekly updates on this beta site. The beta period expires on October 13th, 2005, and the planned availability date for this product is October 25th, 2005. (Of course, this is the software industry, so these dates are not carved in stone.)

There is even a Yahoo! user group that you can join to influence the product and get support. You can learn more about this group at: http://www.toadsoft.com/maillist.htm.

What does Toad for DB2 run on?

To run Toad for DB2 , you simply need a workstation that has a minimum 233 MHz processor (though 300+ MHz is recommended) with 256 MB of RAM (though 512 MB is recommended). You will need a mouse-pointing device and at least a VGA monitor that can display a resolution of 800x600 (though 1024x768 is recommended).

The bottom line is, if you have a computer nearby, it is likely sufficient to run Toad for DB2 (well, perhaps not that TRS-80 in your crawl space). What is perhaps more important to note, however, is with these type of hardware requirements, you can repurpose the old machine that is powered off as a management control point into your database environment.

From an operating system perspective, you can run Toad for DB2 on any of the following platforms:

  • AIX 5.1, 5.2, 5.3
  • HP-UX 11i V1.5+ (support for both the Intel Itanium and PA-RISC)
  • Red Hat Enterprise Linux (RHEL) AS release 3 and 4
  • Solaris Versions 7, 8, 9, 10 (support for both SPARC and x86 architecture)
  • SuSE Enterprise Linux (SLES) Versions 7, 8, and 9
  • Windows 2000, Windows XP, Windows Server 2003

To get Toad for DB2 to talk to your DB2 server, you will need to install the appropriate DB2 client connectivity software (which you can download for free at: http://www-306.ibm.com/software/data/db2/udb/support/downloadv8.html).

With that said, Toad for DB2 can manage any DB2 Version 8 or later database server running on a Linux, UNIX, or Windows platform.

Wrapping it up...

In this two-part series, I have taken you through many of the administrative and development features in the Toad for DB2 product. If you are a developer or DBA looking for a rich and powerful tool to help you manage your database environment, but don't want to commit yourself yet, you can just check out a flash demo of Toad for DB2 at http://www.toadsoft.com/toaddb2/.

About the Author

Paul C. Zikopoulos, BA, MBA, is an award-winning writer and speaker with the IBM Database Competitive Technology team. He has more than ten years of experience with DB2 UDB and has written over sixty magazine articles and several books about it. Paul has co-authored the books: DB2 Version 8: The Official Guide, DB2: The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 for Dummies, and A DBA's Guide to Databases on Linux. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Cluster/EEE) and a DB2 Certified Solutions Expert (Business Intelligence and Database Administration). In his spare time, he enjoys all sorts of sporting activities, running with his dog Chachi, and trying to figure out the world according to Chloë – his new daughter. You can reach him at: paulz_ibm@msn.com.


IBM, AIX, DB2, and DB2 Universal Database are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both.

Microsoft and Windows are trademarks of Microsoft Corporation in the United States, other countries, or both.

Intel and Itanium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.

UNIX is a registered trademark of The Open Group in the United States and other countries.

Linux is a trademark of Linus Torvalds in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

Copyright International Business Machines Corporation, 2005. All rights reserved.


The opinions, solutions, and advice in this article are from the author's experiences and are not intended to represent official communication from IBM or an endorsement of any products listed within. Neither the author nor IBM is liable for any of the contents in this article. The accuracy of the information in this article is based on the author's knowledge at the time of writing.

DB2 Archives