This chapter introduced most of the tools that are available in DB2. They come in two categories: the command-driven and the graphical user interface (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 CLP Plus, the Command Window (only on the Windows platform), and the Command Editor. The IBM Data Studio is a GUI that comes with every DB2 edition. From the IBM Data Studio, you can launch different perspectives to manage and administer your instances and databases. The SQL and XQuery editor helps you create and run SQL scripts. If you want to leverage the power of routines such as stored procedures, user-defined functions, and triggers, the database routines editor and debugger is what you need. It helps you with many tasks from developing and testing the routines to deploying and debugging the routines.
The IBM Data Studio Web Console provides health monitoring, job management, and connection management for DB2 databases. It can be used in a single-user environment or a multiuser environment to share monitored features and analysis across database servers.
The web console generates reports and keep track of your databases according to criteria you provide. These reports are handy for investigating performance problems and setting benchmarks for your database.