Administration Guide

About This Book

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

Information required for designing, implementing and managing databases
Information regarding the configuring and tuning of 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 manual.
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 API Reference manual.
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 setup the replication of data between systems. execute DB2 utility functions through a graphical user interface. To invoke the Control Center, use the db2cc command, or (for OS/2) select the Control Center icon from the DB2 folder. 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 available that you can use to perform administration tasks. They include:

The Script Center to store small applications called scripts. These scripts may contain 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 to run unattended.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]