Optim Database Administrator for DB2 for Linux, UNIX and Windows

Gérez vos bases de données et leurs modifications sans subir d'interruptions

Optim Database Administrator (ex-Data Studio Administrator) fait partie de la famille Optim de solutions de gestion des données dans les environnements hétérogènes.

Optim Database Administrator améliore la productivité et réduit les pannes d'applications en cas de modifications structurelles complexes, afin de rationaliser les scénarios de modifications in situ et de migrations des bases de données. Optim Database Administrator offre les atouts suivants :

  • Automatisation et scriptage des modifications structurelles de la base de données afin d'aider les administrateurs de base de données à mieux gérer les bases de données de test et à accélérer les déploiements.
  • Comparaison, conception descendante et rétroconception des schémas entre les modèles, la base de données et les DDL.
  • Prise en charge des modifications étendues nécessitant de supprimer et de recréer des tables et de gérer la préservation des données.
  • Simplification de l'analyse des impacts et des dépendances en vue de limiter les risques.
  • Migration des objets de base de données, des données et des privilèges, et génération de commandes d'utilitaire de maintenance.
  • Documentation et génération de rapports sur les modifications envisagées et terminées à des fins de collaboration et d'audit.
  • Simplification de la navigation dans la base de données, des commandes et des utilitaires de gestion.
  • Les nouvelles fonctionnalités améliorées de la version 2.2 améliorent les tâches administratives globales et prennent mieux en charge les environnements de base de données partitionnés, tout en permettant une reprise après incident, avec à la clé, la haute disponibilité.

Voir les caractéristiques et les avantages (US)

En savoir plus

Logiciels IBM
Découvrez comment les logiciels intelligents répondent à vos besoins.

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

La 1ère année d'IBM Software Subscription and Support est inclus dans le prix d'achat.

Téléchargement en ligne du logiciel après achat - pas de frais de transport.

En savoir plusFermer

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.

Des moyens d'achats faciles ou en savoir plus.

Besoin d'aide ?

Des moyens d'achats faciles ou en savoir plus.

Optim Database Administrator for DB2 for Linux, UNIX and Windows

Logiciels IBM

*Pricing:  IBM Price excluding tax is above. IBM price including taxes are: Les taxes sont 6,501.46 et 6,948.37 ou 69.37 per PVU, respectively. For pricing inclusive of applicable sales taxes, "Tax" implies GST, VAT or other taxes that may be applicable for purchases in your country. Catalog prices are subject to change without notice. Taxes shown are estimates only and may be recalculated based on the billing and shipping address advised during check out. 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.