Administration Guide

About This Book

This book provides information necessary to use and administer the year 2000 ready, DB2* relational database management system (RDBMS) products, and includes:

• Information about designing, implementing and managing databases
• Information about configuring and tuning your database environment to improve performance.

Many of the tasks described in this book can be performed using different interfaces:

• The Command Processor, which allows you to access and manipulate databases from a graphical interface. From this interface, you can also execute SQL statements and DB2 utility functions. Most examples in this book illustrate the use of this interface. For more information about using the command processor, see the Command Reference.
• The application programming interface, which allows you to execute DB2 utility functions within an application program. For more information about using the application programming interface, see the Administrative API Reference.
• The Control Center, which allows you to graphically perform administrative tasks such as configuring the system, managing directories, backing up and recovering the system, scheduling jobs, and managing media. The Control Center also contains Replication Administration to graphically set up the replication of data between systems. Further, the Control Center allows you to execute DB2 utility functions through a graphical user interface. There are different methods to invoke the Control Center depending on your platform. For example, use the db2cc command on a command line, (on OS/2) select the Control Center icon from the DB2 folder, or use start panels on Windows platforms. For introductory help, select Getting started from the Help pull-down of the Control Center window. The Visual Explain and Performance Monitor tools are invoked from the Control Center.

There are other tools that you can use to perform administration tasks. They include:

• The Script Center to store small applications called scripts. These scripts may contain SQL statements, DB2 commands, as well as operating system commands.
• The Alert Center to monitor the messages that result from other DB2 operations.
• The Tool Settings to change the settings for the Control Center, Alert Center, and Replication.
• The Journal to schedule jobs that are to run unattended.
• The Data Warehouse Center to manage warehouse objects.