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, 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.

  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 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.

[ DB2 List of Books | Search the DB2 Books ]