Road Map to DB2 Programming
DB2 Universal Database includes the following tools to
perform server administration tasks.
| Note: | Not all tools are available on every platform.
|
- Control Center
- A graphical interface that displays database objects (such as databases,
tables, and packages) and their relationship to each other. Use the Control
Center to perform administrative tasks such as configuring the system,
managing directories, backing up and recovering the system, scheduling jobs,
and managing media.
The Control Center includes the following facilities:
- Command Center: to enter DB2 commands and SQL statements
in an interactive window, and to see the execution result in a result window.
You can scroll through the results and save the output to a file.
- Script Center: to create mini applications called
scripts, which you can store and invoke at a later time. These scripts can
contain DB2 commands, SQL statements, or operating system commands. You can
schedule scripts to run unattended. You can run these jobs once or you can set
them up to run on a repeating schedule. A repeating schedule is particularly
useful for tasks like backups.
- Journal: to view the following types of
information: all available information about jobs that are pending
execution, executing, or that have completed execution; the recovery history
log; the alerts log; and the messages log. You can also use the Journal to
review the results of jobs that run unattended.
- Alert Center: to monitor your system for early warnings
of potential problems, or to automate actions to correct problems.
- Tools Setting: to change the settings for the Control
Center, Alert Center, and Replication.
- Performance Monitor
- An installable option for the Control Center, the Performance Monitor is a
graphical interface that provides comprehensive performance data collection,
viewing, reporting, analysis, and alerting capabilities for your DB2 system.
Use the Performance Monitor for performance tuning.
You can choose to monitor snapshots or events. The Snapshot Monitor enables
you to capture point-in-time information at specified intervals. The Event
Monitor allows you to record performance information over the duration of an
event, such as a connection.
- Visual Explain
- An installable option for the Control Center, Visual Explain is a
graphical interface that enables you to analyze and tune SQL statements,
including viewing access plans chosen by the optimizer for SQL statements.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]