Use the Check for DB2 Updates menu option to obtain the most up-to-date information about updates to the DB2 product. You can install the Information Center locally on your computer or intranet server, or access it via the Internet. The Information Center provides a fast and easy method to search the DB2 manuals. The Information menu provides easy access to the DB2 documentation. For example, you can arrange for a backup task to run at a time when there is minimal database activity. The Task Center allows you to schedule tasks to be performed automatically.

Use DB2 replication when you want to propagate data from one location to another. The Replication Center lets you set up and manage your replication environment.It tracks error messages and scheduled tasks that have been executed.

The Journal tool can help investigate problems in the system.

The tool also comes with several advisors to help you configure your system more quickly. From the Control Center, database objects can be created, altered, and dropped. Not only does it support the administration of DB2 database servers on the Linux, UNIX, and Windows platforms, but also on the OS/390 and z/OS platforms.

The Control Center is the most important of these tools.

The general administration tools allow database administrators (DBAs) to manage their database servers and databases from a central location.

The Project Deployment Tool lets developers deploy their Development Center project to another database.

The Development Center provides developers with an environment where they can develop and test database application objects like stored procedures.2.2.2 Development Toolsĭevelopment tools allow developers to easily write and test stored procedures and user-defined functions, as well as to deploy them to different databases. It also has the ability to invoke the Visual Explain tool, which shows the access path for the query. The Command Editor is a graphical interface tool that provides the same functionality as the text-based tools-and more. The Command Window is available only on Windows, while the CLP is available on all other platforms. The two text-based interfaces are the Command Line Processor ( CLP) and the Command Window. Figure 2.2 The IBM DB2 menus 2.2.1 Command Line ToolsĬommand line tools, as the name implies, allow you to issue DB2 commands and SQL statements from a command line interface.

Ca db2 tools manual