Optim Database Administrator for DB2 for Linux, UNIX and Windows

Optim Database Administrator helps you manage databases and database changes without disruption, streamlining change-in-place as well as database migration scenarios. Built-in analysis and mitigation features prevent application outages by ensuring that all related objects are migrated, assure performance by ensuring indexes are updated, and facilitate availability by ensuring privileges are migrated.

Optim Database Administrator:

Provides easy task initiation for common database administration tasks including object, utilities, command, and configuration management. Commands can be run immediately, saved to a script to be run later, or saved to a script that is compatible for scheduling for offline execution from the data server.

Supports seamless transition from logical to physical design via integration with InfoSphere Data Architect. Automates forward and reverse schema engineering between models, the database, and DDL.

Facilitates impact and dependency analysis to mitigate risk of application outages. Finds dependencies among data objects to understand how proposed changes might impact other related objects.

Maintains the integrity of the database by generating commands that respect referential integrity relationships, preserve table data, privileges, and all dependent objects and allows you to undo changes quickly if necessary.

Accelerates complex structural changes by automating extended alters that require dropping and re-creating objects and data preservation. You can choose how data is preserved during change deployment with the ability to either store data outside the database or store data inside the database using a shadow table. You can also transform the data unloaded and map columns when reloading. Built-in integration simplifies use with Optim High Performance Unload. Unlike other products data is persevered on the database server and not routed through the client.

Simplifies promoting changes from development to test or test to production.

Compare two databases to find out if anything is different or missing. This is especially helpful for problem determination.

Supports large enterprises with:

Improves performance by generating maintenance utility commands such as runstats and reorg. Reduces the impact on production by leveraging the unload speed and repartitioning capabilities of Optim High Performance Unload directly through the Optim Database Administrator user interface.

Enables fast error correction in the event that deployment errors occur providing undo, partial undo, and restart.

Facilitates team collaboration and audit readiness enabling you to:

Use Optim Database Administrator to: