IBM DB2 Monitoring
Usage, availability and health of IBM DB2 databases under continuous monitoring, on servers running any operating system.
Practical support for DBAs
DB2 is IBM’s RDBMS (Relational DataBase Management System), a database system based on the relational model that competes with Oracle for leadership of the relational database market.
To support DBAs, Sentinet³ provides the Sentinet³ DB2 Pattern, a comprehensive package of checks that analyses system usage, availability and health. Monitoring of IBM DB2 servers is continuous and flags potential problems before they hit the system.
| At a glance | |
|---|---|
| Pattern | Sentinet³ DB2 Pattern |
| Scope | Servers running any operating system, database performance |
The Pattern’s checks
The Pattern includes 19 checks. Each has configurable thresholds and generates a notification when values exceed them.
Server (any operating system)
| Check | What it verifies |
|---|---|
| Reachability | The server responds on the network |
| CPU | Percentage of CPU utilisation |
| Memory | Memory usage |
| Disk | Free disk space |
Database performance
| Check | What it verifies |
|---|---|
| Backup File | Whether backup is active or not |
| Buffer Pool Block Size | Block size of the buffer pool |
| Cpu Parsing | Percentage of CPU spent on parsing |
| Cpu Recursive | Percentage of CPU spent on recursive calls |
| Bg Elapsed Time | Time spent in background processes |
| Free Shared Pool | Free memory in the shared pool |
| Free Sga | Free memory in the System Global Area |
| Ts Size | Free space in the tablespace |
| Ts Status | Tablespace status and its free space |
| UsersList | List of database users |
| User State | Users connected to the database |
| DB Size | Database size |
| Shutdown Pending State | Whether a shutdown is pending |
| Long Query | Whether long-running queries are present |
| Last Analyzed | Date of the last analysis run on the database |
Like having a virtual DBA at your side
- Prevention: continuous monitoring reports potential problems before they hit the system.
- Best practice: the information gathered helps eliminate weak points, improve replication and optimise performance.
Related topics
Want to see Sentinet³ on your infrastructure?
Tell us about your environment: sites, technologies, critical services. We will show you how Core and Infinity can work on your case.