DBGeneral's Performance Monitor allows a DBA to monitor all database servers in a network environment. Unattended distributed agents continually analyze servers and alert the DBA when anomalies occur. Performance Monitor's standard set of rules may be used, or easily customized to the DBA's own rules and desired alert actions.
Any supported and licensed client PC on the network can connect to DBGeneral agents at any time. When connected, a complete set of high level views are available and quickly reveal general problem areas. From this view, the DBA can drill-down through several levels of detail to pinpoint specific problems.
DBGeneral is an integrated set of applications tool to monitor and manage enterprise database performance, perform SQL code tuning, space management, and general day to day maintenance functions. DBGeneral's product family consist of the following functions:
The server module is the set of programs used to collect data, automate analysis of the database, perform tablespace reorganizations and object manipulations, collect SQL statements for tuning, and many other DBA functions.
The client module is the set of programs that the end user runs to view real-time performance data, configure the connectionless monitoring, alerting, historical collection of performance data, issue structural changes to tables, administer priviledges, configure and start object reorganizations, select SQL statements for tuning, and many other functions.
The object request broker (ORB) sits between client programs and server agents directing traffic and delivering messages. The ORB determines which agent should perform the work requested from the client module. The ORB returns the results to the client module and allows the client module to disconnect and reconnect for status information later.