Quest Central® for DB2

Space Management

Quest Central’s Space Management component replaces time-consuming, error-prone methods of managing database space usage, reducing the risk of space related slowdowns or failures. Quest Central has the capability to collect both growth and performance related statistics and retain this information in a DB2 repository. Quest Central uses these statistics to proactively forecast and graph database growth, giving DBAs time to plan for system upgrades and reorganizations. The Space Management component also offers exception reporting that can immediately identify all space-and performance-related exceptions in your database with one concise report.

Key Benefits:

• Predicts out of space conditions, minimizing downtime
  
• Improves database performance by identifying and resolving space-related problems
  
• Reduces the learning curve by providing one solution for both mainframe and distributed environments
  
• Maximizes current hardware investments
  
• Reduces storage by accurately sizing your database
  
• Built-in expertise removes time-consuming analysis
  

Key Features

• Immediately identifies all tablespaces running low on space
• Quickly detects tables in need of reorganization
• Generate syntax for all native IBM utilities as well as all third-party OS/390 utilities
• Forecasts "out of space" conditions based upon a statistics repository
  
• Automates the collection of growth and performance-related statistics for trend analysis
  
• Provides detailed space calculator with "what if" capabilities to plan for object growth
  
• Supports DB2 on both distributed and mainframe platforms
  

The Space Management piece is fully integrated with Quest Central's other solutions: Database Administration, Performance Diagnostics, and SQL Tuning.