Making changes to objects in your database—even performing routine administrative tasks—can be difficult and risky. There are dozens of tasks to track, and a single misstep could have a disastrous impact on availability and data integrity. Reduce both effort and risk with a collection of tools to help you:

Reduce the time required to administer complex and disparate Db2 environments

Automate routine tasks throughout the application lifecycle for improved integrity

Improve productivity with simplified Db2 catalog navigation and change management

Enhance application availability by performing changes and maintenance with minimal outages

Provide dashboard-based visibility into database change activity

BMC AMI Database Administration for Db2 ^® increases and enhances database availability with these functions:

Automates tasks that keep databases available during updates and changes

Creates copies instantly, with no outages

Captures a complete snapshot of your data quickly, without having to suspend read/write access to your database

Database changes can introduce risk. BMC AMI Database Administration for Db2 ^® helps you mitigate and reduce this risk, improving your overall resiliency.

Generate complete change management scripts to intelligently apply changes

Automatically generate all dependencies such as grants and indexes

Undo changes when necessary by generating backout change management scripts to quickly reverse changes

BMC AMI Database Administration for Db2 ^® speeds up routine database tasks, making you more nimble.

Use the load, unload, and copy utilities to move and duplicate data faster, with fewer resource demands

Easily apply changes from one database schema to corresponding structures across your environment

Navigate and interact with your Db2 catalog information with a powerful catalog management tool

“By regularly using the BMC solutions to identify the top consumers of MIPS, we’ve been able to prioritize our efforts and start with the ones that would have the biggest impact on CPU consumption. Our developers use the tool more because the interface is so easy to work with.”

Marc Tougaw, Db2 Systems Programmer

Dillard’s

“Our aim is to simplify many of our daily IBM ^® Z ^® tasks associated with IBM ^® Db2 ^® operators and developers, while also building a new, smart interactive approach with Db2 ^® systems. BMC AMI Catalog Manager for Db2 ^® , part of the BMC AMI Database Administration for Db2 ^® solution, enabled us to make this goal a reality and achieve productivity savings totaling $280,000.”

Massimiliano Valli, Systems Programmer

BMC AMI Database Administration for Db2 ®

Simplify database administration with task automation

Reduce your change risk, preventing data loss, errors, and downtime

“By regularly using the BMC solutions to identify the top consumers of MIPS, we’ve been able to prioritize our efforts and start with the ones that would have the biggest impact on CPU consumption. Our developers use the tool more because the interface is so easy to work with.”

BMC AMI Database Administration for Db2 ^®