DB2 Monitor
Monitors the backups and tablespaces of a DB2 database
General
| Executable | DB2_Monitor.exe |
| Connection method | ODBC |
| Ports |
|
| Lookup files |
|
Default parameters
| Parameter name | Possible values | Default | Description |
|---|---|---|---|
| Host | <ip> | <hostname> | empty | Hostname or IP of the database system. |
| DBName | string | empty | Name of the database |
| DBPort | number | 5912 | Port to establish ODBC connection. |
| DBUsername | string | empty | Database user |
| DBPassword | string | empty | Password of the database user |
Sensor-specific parameters
| Parameter name | Possible values | Default | Description |
|---|---|---|---|
| Days | 10 | ||
| IgnoreTBSPAutoresize | 1 |
Channels
| Channel name | Description | Lookup file |
|---|---|---|
| Successful Backups | Number of successful backups in the last <Days> | |
| Error Backups | Number of backups with errors in the last <Days> | |
| Successful LogBackups | Number of successful log backups in the last <Days> | |
| Error LogBackups | Number of log backups with errors in the last <Days> | |
| HADR State | HADR Status | itesys.db2monitor.hadr.ovl |
| TBSP <tablespace> - % free | Percentage free space of tablespaces with auto-resize = disabled and tablespaces with auto-resize = enabled (is deactivated by default) | |
| TBSP with Max Size enabled | Checks the activation of MAXSIZE of auto-resized tablespaces and if there is enough free space available before the defined MAXSIZE value has reached | itesys.db2monitor.tblspacemaxsize.ovl |
Important notes
warning
Please check the channel limits in PRTG if they fit for your alerting.
Troubleshooting
| Symptom | Possible solution |
|---|---|
Not all tablespaces are shown under channel TBSP <tablespace> - % free | By default the value of parameter IgnoreTBSPAutoresize is set to 1 which means that only the tablespaces for which the auto-resize is disabled are displayed. By using 0 instead of 1 also tablespaces with auto-resize is enabled are shown. |
Receiving error message Could not connect to DB2 database: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified | Please install 32-bit IBM DB2 ODBC driver on the PRTG probe. |
Changelog
| Version | Changes |
|---|---|
| 2023.03 | Corrected wrong count of backups when using different backup tools. |
| 2020.06 |
|
| 1.4.0.1 | Rebuild for new signature of AddChannel method |
| 1.4.0.0 | Build for installer 1.4.0 |
| 1.3.6.0 | First stable release |