OpenMaster SLM managing databases

Consolidated database administration

A typical organization uses dozens of databases, some shared by multiple applications. And, while standardizing on a single database vendor is clearly a good idea, historical constraints and performance issues mean that it is rarely followed in practice.

Imagine the convenience of being able to consolidate database administration under a single uniform interface, for all database types on all platforms. That's OpenMaster SLM. Functions available for all managed databases include:

• Monitoring database status. Because OpenMaster SLM also provides system management functions, administrators can intervene directly when, for example, a database is running out of disk space
• Setting alarm thresholds to alert you when manual intervention seems necessary, typically allowing you to detect performance bottlenecks before they affect production work
• Performance analysis and tuning, whether scheduled or launched on demand. OpenMaster SLM allows you to manage all cost and performance gauges and review high-level parameters. For mission-critical databases, you can easily add dedicated counters
• Trace Management: OpenMaster SLM's OpenAgent technology allows you to make use of the wealth of information in their trace log or error files. For example:
  • Take action you when error files are created
  • Supervise application processes
  • Dispatch alarms to the console
  • Detect when specific problems occur using pattern matching and automatically execute corrective scripts

Nomadic Web interface

Often, different people will be in charge of administering individual databases. Since administration is via a Java-based web interface, they can work from their own workstations rather than needing to install a dedicated console. Role-based management ensures that they can only modify their own databases.

The web interface can keep productivity high even if you prefer to limit database administration rights to a central administration team - they can work from anywhere, typically making changes to an Oracle database during a meeting in the application developers' office.