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 |
Lookup values
Values, states and texts defined in the lookup files of this sensor.
Lookup file: itesys.db2monitor.hadr.ovl
| Value | State | Description |
|---|---|---|
0 | OK | OK |
1 - 99 | Error | Error |
100 | OK | Not Configured |
Lookup file: itesys.db2monitor.tblspacemaxsize.ovl
| Value | State | Description |
|---|---|---|
0 | OK | No Max Size configured |
1 | OK | Free space at least 10% |
2 | Warning | Free space below 10% |
3 | Error | Free space below 5% |
Important notes
warning
Please check the channel limits in PRTG if they fit for your alerting.
Troubleshooting
| Error Code | Error Message | Possible Solution |
|---|---|---|
[SCN-050-000] | The following parameters has not been provided: <parameters> Please read the sensor documentation for further information! | Specify the listed parameters in the profile or in the sensor-specific parameters. |
[SCN-050-105] | Could not connect to IBM DB2 database: <message> | Check the parameters Host, DBPort, DBName, DBUsername and DBPassword and that the database is reachable from the PRTG probe. If the message is ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, please install the 32-bit IBM DB2 ODBC driver on the PRTG probe. |
| - | 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 enabled are shown. |
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 |