Thanks to the innovative patterns developed in Sentinet3, it is possible to monitor at the same time hundreds of parameters for more complex servers with a simple click.
In this article we will show you what you can do on a DB2 database.
DB2 is a RDBMS (Relational DataBase Management System), a database system based on the relational model,of the IBM brand, which now contends the first place on the market for relational databases with Oracle.
To support DBA, which manage the database, Sentinet3 provides the “Sentinet3 DB2 Pattern”, a complete control package that analyzes system utilization, availability, and the "health" of the same.
Sentiniet3 performs a continuous monitoring of IBM DB2 servers through the use of this pattern and alerts you of potential problems before they hit your system. It's like having a "Virtual DBA" on your side to recommend to you the best practices necessary to delete security vulnerabilities, improve replication, optimize performance, and much more.
The controls that “Sentinet3 DB2 Pattern” does on DB are:
Server (with any oparation system)
- Reachability of the machine
- CPU utilization
- Mem usage
- Disk space
Database performace
- Backup File check if the backup is running or not
- Buffer Pool Block Size Buffer Pool Block size
- Cpu Parsing Cpu parsing usage
- Cpu Recursive Cpu recursive usage
- Bg Elapsed Time time running in background
- Free Shared Pool free shared pool
- Free Sga free memory area in the System global
- Ts Size free space in TS
- Ts Status TS status
- UsersList DB user list
- User State User DB connected
- DB Size DB size
- Shutdown Pending State check shoutdown pending state
- Long Query long query active/not active
- Last Analyzed check last analysis on DB
