Understanding DB2: Learning Visually with Examples (2nd Edition)

4.11. Summary

This chapter introduced all the tools that are available in DB2. They come in two categories: the command-driven and the non-command-driven tools. All of the non-command-driven tools are GUI Tools. To use the command line tools you need to have some knowledge of DB2 commands and SQL statements. If you aren't familiar with these, the GUI tools come in handy.

The Command Line tools include the Command Line Processor (CLP), the Command Window (only on the Windows platform), and the Command Editor. Among the GUI tools, the most powerful one is the Control Center. From the Control Center you can launch other tools and administer your instances and databases. In addition, the Control Center facilitates your administration tasks with wizards and advisors.

The Application Development tools help you build, test, debug, and deploy stored procedures, user-defined functions (UDFs), and structured types.

The monitoring tools keep track of your databases according to criteria you provide and generate reports. They are handy for investigating performance problems and setting benchmarks for your database.