DB2® Database Tools

Reduce administration complexity of your database architecture with these DB2 Tools

Change Management

Change your DB2 structures faster and with less complexity and errors with the DB2 Change Management Expert tool. Simplify change tracking and the need to extensively analyze objects and dependencies before upgrading existing databases and migrating data between databases.

Data Archiving

The Data Archive Expert tool provides administrators with a tool that can easily move seldom-accessed data to less costly storage mediums, and allows for “table-grouping” so relationship between tables can be recognized, to include tables with those being archived.

High Performance Unload

Reduce batch maintenance times to maximize availability with this tool. Data unloads from backup systems, whether they are table spaces or entire databases, are significantly sped up. Also, with DB2 High Performance Unload, you can perform selective unloads, partition unloads, and data transformation during unload operations.

Performance Management

This powerful tool monitors, analyzes, and tunes the performance of your DB2 data and applications proactively. In addition, it provides a complete and detailed analysis of system performance for a top-level view of performance, so you can actively identify and resolve potential database issues before they impact the business.

Recovery Management

Unexpected data loss can be a thing of the past with the DB2 Recovery Expert. This tool can recover a dropped table to a particular point in time, and include dependent objects such as indexes, views, authorizations and related tables. The Log Analysis component provides additional granularity to your recovery operations with the ability to back out and redo transactions as needed. In addition, the data auditing can pinpoint data changes so administrators can see when changes occurred, and who performed the changes.

Test Database Generator

Because of new privacy regulations, many businesses are taking pains to create sterilized data for testing environments, to reduce the risk of exposing sensitive production data. The DB2 Test Database Generator enables the rapid creation of sterilized test data from scratch or from production data with the sensitive data masked and protected.

Table Editor

This tool provides a drag and drop GUI for non-DBA types, so they can update data when and where they wish, without needing programming and code knowledge.

Web Query Tool

DB2 Web Query provides universal access to DB2 data across the enterprise. Whether accessing via the Web or various handheld devices, users can run data queries, comparison and access reports through a number of interfaces.

---

•  Print This Page