This book provides information necessary to use and administer the year
2000 ready, DB2* relational database management system (RDBMS) products,
- 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
- 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.
Error conditions when using the Control Center are recorded in the Control
Center Administration Engine Log (db2cc.log). This log records
information about the errors generated while using the Control Center.
The log is always active while the Control Center is active. The log
file is kept in the home directory of the executable that invokes the Control
Center. That is, in the bin subdirectory of the
sqllib subdirectory. The file can be viewed and updated
using an ASCII file editor.
The log file records the error message type, a time stamp, a process
identifier (PID), a thread identifier (TID), and an SQL error message.
The process ID and the thread ID are used to identify the operating system
that generated the log. Combined with the Control Center trace
information, DB2 Service and Support personnel are able to determine which
Control Center task caused the error. The information is only of use to
the DB2 Service and Support personnel.
The log file can be edited by an ASCII file editor to remove log records
that are no longer needed.
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
- The Alert Center to monitor the messages that result from other
- 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 ]
[ DB2 List of Books |
Search the DB2 Books ]