3.3 Tools

< Day Day Up >

DB2 UDB provides some tools that help you in several tasks, like performance optimization and maintenances tasks. In the following we introduce four of them.

3.3.1 IBM DB2 UDB Performance Expert for Multiplatforms

IBM DB2 UDB Performance Expert for Multiplatforms offers a comprehensive view that consolidates, reports, analyzes and recommends changes on DB2 UDB performance-related information. The tool includes a Performance Warehouse that stores performance data and analysis tools as well as a Buffer Pool Analyzer that collects data and provides reports on related event activity. With online monitoring capabilities, DB2 UDB Performance Expert monitors DB2 Connect gateways, including application and system-related information. Building on IBM's autonomic computing and on demand expertise, DB2 UDB Performance Expert also offers recommendations for system tuning to gain optimum throughput. You can use DB2 UDB Performance Expert to:

Monitor the DB2 UDB database and DB2 applications online and by evaluating report sets.
View and examine the status of a DB2 instance and its applications while they are currently active, or investigate events and performance problems that happened in the past.
Monitor individual nodes or an entire system.
Recognize event exceptions and take appropriate actions by means of a user exit.
Obtain tuning recommendations.
Identify trends and anticipate potential bottlenecks.

3.3.2 IBM DB2 UDB Recovery Expert for Multiplatforms

DB2 UDB Recovery Expert for Multiplatforms provides targeted, flexible and automated recovery of database assets. Its easy-to-use environment enables even less experienced DBAs to successfully complete highly sophisticated and efficient recovery techniques in minimal time. DB2 UDB Recovery Expert provides intelligent analysis and diagnostics of altered, incorrect, or missing database assets including tables, indexes, or data. It also automates the process of rebuilding those assets to a correct "point-in-time," often without taking the database or e-business operations offline.

3.3.3 IBM DB2 High Performance Unload for Multiplatforms

An IBM DB2 UDB tool that helps reduce the maintenance window is DB2 UDB High Performance Unload for Multiplatforms. This product gives customers a fast and efficient tool for unloading and extracting data for movement across the enterprise or for reorganization in place. It delivers high levels of parallelism and distribution of data across multiple logical or physical partitions. It also supports DB2 UDB Enterprise Edition/Enterprise Server Edition (SMP) and data that has been distributed across multiple logical or physical partitions on an MPP system, such as DB2 Enterprise-Extended Edition/Database Partitioning Feature (PDF).

3.3.4 IBM DB2 UDB Table Editor for Multiplatforms

IBM DB2 UDB Table Editor for Multiplatforms quickly and easily accesses, updates, and deletes data across multiple DB2 database platforms, including IBM Informix Dynamic Server 9.x. Through integration with the Control Center, or Web-based interfaces, the tool supports high function editing with full support for DB2 security and user profiles. In addition to editing raw data, you can create editing forms with drag-and-drop graphical user interfaces, giving end users the ability to perform more of the data maintenance activities, therefore freeing up DBA resources.

3.3.5 IBM DB2 UDB Web Query Tool for Multiplatforms

DB2 Web Query Tool for Multiplatforms makes it easy for users at all levels to access enterprise data for query, data comparison, or reporting through multiple interfaces. These interfaces can include traditional Web-based browsers, e-mail clients, and wireless devices such as PDAs, text pagers, and WAP-enabled cellular phones.

< Day Day Up >