MaxDB Monitor
Monitors Usage, Backups und SAP CheckDB
General
| Executable | MaxDB_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 target system. If you use a virtual hostname on your SAP servers, please use also the virtual host to connect. |
| DBName | string | empty | Name of the database |
| DBUsername | string | empty | Database user |
| DBPassword | string | empty | Password of the database user |
Sensor-specific parameters
| Parameter name | Possible values | Default | Description |
|---|---|---|---|
| Days | 10 | ||
| SAP_Schemaowner | DB Username |
Channels
| Channel name | Description | Lookup file |
|---|---|---|
| Successful Backups | Number of successful backups in the past <Days> | |
| Successful Incremental Backups | Number of successful incremental backups in the past <Days> | |
| Successful Log Backups | Number of successful log backups in the past <Days> | |
| Error Backups | Number of backups with errors in the past <Days> | |
| Error Incremental Backups | Number of incremental backups with errors in the past <Days> | |
| Error Log Backups | Number of log backups with errors in the past <Days> | |
| Last Backup | Status of the last backup
| itesys.maxdbmonitor.lastbackup.ovl |
| Last Incremental Backup | Status of the last incremental backup
| itesys.maxdbmonitor.lastincrbackup.ovl |
| Data Usage | Filling level data volume | |
| Log Usage | Filling level log volume | |
| Log Mode Check | Log Mode Check
| itesys.maxdbmonitor.logmodecheck.ovl |
| Bad Indexes | Number of bad indexes | |
| Used sessions | Number of currently used sessions | |
| Used sessions % | Used sessions in relation to maximum number of sessions |
Lookup values
Values, states and texts defined in the lookup files of this sensor.
Lookup file: itesys.maxdbmonitor.lastbackup.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Successful |
1 | Error | Error |
2 | Warning | No backups yet |
Lookup file: itesys.maxdbmonitor.lastbackupsap.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Successful |
1 | Warning | Warning |
2 - 9998 | Error | Error |
9999 | OK | Running |
Lookup file: itesys.maxdbmonitor.lastcheckdb.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Successful |
1 | OK | Warning |
2 - 9998 | Warning | Error |
9999 | OK | Running |
Lookup file: itesys.maxdbmonitor.lastincrbackup.ovl
| Value | State | Description |
|---|---|---|
0 | OK | Successful |
1 | Error | Error |
2 | OK | No incremental backups yet |
Lookup file: itesys.maxdbmonitor.logmodecheck.ovl
| Value | State | Description |
|---|---|---|
0 | OK | OK |
1 | Warning | Warning |
Important notes
Please check the channel limits in PRTG if they fit for your alerting.
Troubleshooting
| Error Code | Error Message | Possible Solution |
|---|---|---|
[SCN-052-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-052-106] | Could not connect to MaxDB database: <message> | Check the parameters Host, DBPort, DBName, DBUsername and DBPassword and that the database is reachable from the PRTG probe. |
[SCN-052-300] | dbmcli.exe error: <message> | dbmcli.exe returned an error. Check that the MaxDB client (dbmcli.exe) is installed on the PRTG probe and that the database credentials are correct. Run the same dbmcli command manually to get more details. |
| - | Backup channels are missing |
|
Changelog
| Version | Changes |
|---|---|
| 2023.03 | Count of differential backups has been corrected. |
| 2022.08 | The sensor now also supports older MaxDB versions like 7.6. |
| 2022.05 | Corrected wrong count of incremental backups in some cases |
| 2021.09 | Corrected wrong counting of incremental backups in some cases
|
| 1.4.0.2 | Corrected last backup check |
| 1.4.0.1 | Rebuild for new signature of AddChannel method |
| 1.4.0.0 | Build for installer 1.4.0 |
| 1.3.7.0 | Corrected wrong counting of incremental backups in some cases
|
| 1.3.6.1 | Fixed LogModeCheck to act correctly if AUTOLOG is ON and Log Overwrite is ON |
| 1.3.6.0 | First stable release |