High availability and recoverability are a DBA's biggest challenge. Meeting service level agreements and compliance requirements are harder then ever, especially in shops with little or no batch window.

RealTime DBAExpert (RTDX) is a comprehensive DB2 database administration tool kit that you can use to automate maintenance and manage databases in a predefined batch window or on demand. RTDX also controls the execution of DB2 utilities and DB2 commands as well as efficiently manages space.

RTDX performs critical tasks in the following areas:

• Real-time information and analysis:
  Uses real-time statistics for database analysis, scheduling maintenance activity in a predefined batch window or on demand.
• Database utility generation:
  Integrates with database utilities, initiating utility generation as needed.
• Dynamic space assurance prevents unplanned outages caused by
  
  • running out of data sets (linear page set audit)
  • running out of SMS storage group volume space
  • running out of extents
• Batch control:
  Using a rules-based system, manages batch jobs for DB2 utilities to successful completion.

RTDX leaves it up to you whether DB2 database maintenance should be done the classic way, in a predefined batch window, or the On Demand way, dynamically once a threshold is exceeded. Whatever you decide, job execution and management features like Utility Runtime Prediction, WLM Control and Utility Governance always assure that it easily aligns securely with your production workload.