MaxDB Monitor

Monitors Usage, Backups und SAP CheckDB

General

Executable	MaxDB_Monitor.exe
Connection method	ODBC
Ports	7210
Lookup files	itesys.maxdbmonitor.lastbackup.ovl itesys.maxdbmonitor.lastbackupsap.ovl itesys.maxdbmonitor.lastcheckdb.ovl itesys.maxdbmonitor.lastincrbackup.ovl itesys.maxdbmonitor.logmodecheck.ovl

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 Successful Error No backup yet	itesys.maxdbmonitor.lastbackup.ovl
Last Incremental Backup	Status of the last incremental backup Successful Error No backup yet	itesys.maxdbmonitor.lastincrbackup.ovl
Data Usage	Filling level data volume
Log Usage	Filling level log volume
Log Mode Check	Log Mode Check OK NOK	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

Important notes

warning

Please check the channel limits in PRTG if they fit for your alerting.

Troubleshooting

Symptom	Possible solution
Backup channels are missing	The user has no access to SAP schema. The monitoring user needs to have permission to read the tables in the SAP schema If it is not an ABAP system, there will not be backup channels

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 Added new channels for incremental backups Added new channels for used sessions Added new channel for count of bad indexes
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 Added channels for last Backup and Check with lookup values Removed error tag from result and added limits to Backups and Check channels
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