A smart pilot for your database

iDBA-Online is an intelligent piloting solution for administering and maintaining DB2 database operations for z/OS. The software optimizes useful tasks such as reorganizations and back-ups, according to business constraints and their impact on application costs.

See related resources

A DBA at the heart of your system

Through the analysis of application costs and operational impacts, iDBA-Online organizes maintenance operations so that global system performance system can be optimized, while data integrity is guaranteed.

  • iDBA-Online manages planning and execution of on-line or off-line reorganization, synchronous or asynchronous back-ups and data loading and unloading operations.
  • Reorganizing tables and indices generates costs. Non-reorganization leads to increased resource consumption and performance deterioration. iDBA-Online assesses these costs to identify the objects to reorganize, and schedules practical tasks.
  • iDBA-Online optimizes the back-up frequency to reduce costs while ensuring a maximum level of security.
  • iDBA-Online defines operational strategies, guarantees compliance with business constraints and techniques, as well as data availability, back-up policies, CPU consumption, etc.
  • iDBA-Online is fully compatible with standard DB2 utilities, and also includes its own ultra-fast utilities for reorganization, back-up, loading and unloading.

Intelligent planning

iDBA-Online supervises all or part of company databases.

  • iDBA-Online analyzes available information via Real Time Statistics, or directly using the database datasets.
  • Key information is stored in the internal iDBA-Online repository to reduce access to the statistics catalogue and take into account the data history in analyses.
  • Utility performance and processing times are recorded to improve future organizational operations.
  • Simulation mode detects necessary maintenance operations and assesses their processing times.
  • The planner complies with user-defined constraints as well as forbidden times, data availability, CPU consumption, etc.

A clear and metric vision

As an industrial piloting tool for databases, iDBA-Online can operate in command line mode or via a web interface.

  • Accessible via an internet browser, the interface facilitates configuration of core business constraints and offers a graphical view of planning.
  • With this interface, the user can also directly launch and plan the utilities.
  • Clear and precise statuses display the database metrics concerned and monitor maintenance operations.
  • Intelligent planning of maintenance operations reduces both database costs and administration loads.