Optim Database Administrator for DB2 for Linux, UNIX and Windows

Gestione las bases de datos y los cambios que se producen en ellas sin interrupciones

Optim Database Administrator, conocido anteriormente como Data Studio Administrator, forma parte de la familia Optim y permite a las organizaciones gestionar datos en entornos heterogéneos.

Optim Database Administrator mejora la productividad y reduce las paradas de las aplicaciones durante los cambios estructurales para agilizar los escenarios de migración de bases de datos y los cambios in situ. Puede utilizar Optim Database Administrator para:

  • Automatizar y cifrar los cambios de las bases de datos estructurales para que los DBA puedan gestionar mejor las bases de datos de pruebas y agilizar los despliegues.
  • Comparar, tirar hacia delante e invertir ingeniería entre los modelos, la base de datos y DDL.
  • Realizar modificaciones ampliadas que requieren la descarga y la recreación de tablas, y la gestión del mantenimiento de datos.
  • Facilitar los análisis de dependencia y del impacto para mitigar los riesgos de los cambios.
  • Migrar datos, privilegios y objetos de bases de datos, y generar mandatos de programas de utilidades de mantenimiento.
  • Documentar los cambios completados y propuestos para la colaboración y la auditoría, y realizar informes sobre estos.
  • Simplificar la navegación de la base de datos, los mandatos y los programas de utilidad de gestión.
  • Las funciones nuevas y ampliadas en 2.2 mejoran las tareas administrativas en general, y amplían el soporte para los entornos de base de datos particionada y la recuperación en caso de error de alta disponibilidad.

Ver características y ventajas (US)

Descubra más

Comprar Optim Database Administrator for DB2 for Linux, UNIX and Windows

IBM Software Suscription y Software Support está incluido en el precio del producto para el primer año.

Descarga del software online después de la compra - sin gastos de envío.

No disponible para la compra online. Otros medios de compra o solicitar información adicional.

¿Necesita ayuda? Contacte IBM

Mostrar información Ocultar información

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:

  • Federated Support – enables federated objects, such as wrappers, nicknames and user mappings, to be changed.

  • DB2 Command Line Processor (CLP) Generated Scripts - generates change management scripts in a format that is compatible with CLP.

  • Large Database Support - provides overall scalability and performance enhancements for environments with large volumes of objects.

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:

  • Document a complete history of changes, including scripts, models, logs, and reports to capture the entire change from start to finish

  • Integrate with the IBM Rational Software Delivery Platform V7.5 and IBM Rational ClearCase (or other eclipse-based configuration management system) to simplify archival of data design projects

  • Define database connections once and share with users of Optim Database Administrator, Optim Development Studio, InfoSphere Data Architect and Optim Query Tuner

Use Optim Database Administrator to:

  • Compare, synchronize, copy, clone, or merge database schema definitions from the source to the target

  • Specify masks and ignores to simplify the comparison of models

  • Migrate objects from physical data models, live database connections, or from scripts

  • Move objects and data with copy and paste, drag and drop, or directly from a comparison

  • Integrate with DB2 High Performance Unload to accelerate the change process.

Una manera fácil de adquirir nuestros productos u obtener más información.

Contáctenos

Una manera fácil de adquirir nuestros productos u obtener más información.

Optim Database Administrator for DB2 for Linux, UNIX and Windows

IBM Software

*Pricing:  Catalog prices are exclusive of tax and subject to change without notice. Passport Advantage customers will see their Relationship Suggested Volume Pricing during checkout.

Processor Value Unit (PVU): Learn more about Processor Value Unit (PVU) licensing. Find the price for your hardware with the Value Unit Calculator.