SAP MaxDB Monitoring
Last updated
Last updated
SAP MaxDB is a powerful, enterprise-grade relational database management system designed for high performance and scalability. It offers robust features such as data integrity, transaction management, and advanced backup and recovery capabilities. With support for various platforms, it's an ideal choice for businesses requiring reliable data management solutions.
Monitoring MaxDB helps maintain reliability, performance, and security. IT-Conductor allows monitoring of several components, such as SQL report automation, space usage, etc. You can also view historical data depending on the selected time range.
Before configuring an SAP MaxDB for monitoring in IT-Conductor, follow the instructions below.
Login to the Sqlcli with your SYSDBA/DBADMIN user as shown below:
Create a database user with a STANDARD user class using the following script:
To configure SAP MaxDB monitoring in IT-Conductor, follow the instructions below.
Visit service.itconductor.com and enter your login credentials.
Navigate to Dashboards → Administrator to access the Administrator's Dashboard.
Locate the MaxDB Instances actions panel and click the title to access the complete list.
Click the New MaxDB System button to start adding a new system for monitoring.
Description - refers to any relevant information about the system being added.
Organization - refers to an administrative structure that defines objects with a common goal or purpose. If you previously created an organization, please select it.
Role - refers to the environment where the system will be used.
Site - refers to a logical object that describes a particular area or location, depending on the context in which it is used.
Gateway - allows communication between the customer's site network and the IT-Conductor cloud platform. Select the previously configured gateway from the dropdown menu. See Gateway Setup for more details.
DB Name - refers to the name of the SAP MaxDB instance being added.
Hostname - refers to the hostname or IP address of the server hosting the SAP MaxDB instance.
SQL Mode - refers to the SQL mode setting that determines the SQL compatibility level for the database, influencing syntax and behavior.
Cache - refers to the memory cache the SAP MaxDB uses to store frequently accessed data.
Unicode - indicates whether the database supports Unicode character encoding for multilingual support.
Session TimeOut - specifies the duration of inactivity before a database session is automatically terminated.
Comm TimeOut - defines the maximum time allowed for communication between the database server and client applications.
Verify SQL - refers to an option to validate SQL statements for syntax errors and compatibility before execution.
Description - refers to any relevant information about the user account being added.
Application - refers to the name given to the system being added.
Person - refers to the name of the user who is adding the system.
User Name - refers to the SAP MaxDB user created aligned with the Account Requirements.
Password - refers to the password of the previously created SAP MaxDB user.
Retype Password - refers to the same password provided in the Password field.
Verify if the system was added to the MaxDB Instances actions panel and check its status.
Navigate to the service grid and verify if the system was added under the MaxDB Servers node.
Note: The system will appear in the service grid within 5-15 minutes.
To view the availability and performance metrics of a SAP MaxDB system, locate the MaxDB Servers node in the service grid.
Availability - refers to the operational state and accessibility of the MaxDB system.
Connection Failures - refer to the events where attempts to establish a connection are unsuccessful.
Heartbeat - refers to the periodic signal sent to the system, enabling real-time detection of system downtime.
Missing Account - refers to the absence of a required user account or resource within the MaxDB system.
Retriever Failures - refer to the errors or issues encountered during the retrieval process of essential data or information within the MaxDB system.
Note: All metrics will not show data when a system is unavailable.
To view the usage or the disk space consumed by the system processes, locate and expand the Data node in the service grid.
Log Files Usage
To view the usage consumed by the log files, locate and expand the Log node in the service grid.
SQL Jobs
To view and run SQL jobs, navigate to the specific MaxDB server node and click SQL Jobs.
You will be redirected to the SQL Jobs page that lists all active SQL jobs. To view the job details of a specific SQL job, click the title, and you will be redirected to another page, as shown in Figure 10.
Fill out all the necessary information in the New MaxDB System wizard. Once completed, click to add the system.
Provide the account information in the New Account screen and click to complete the configuration.
Note: The status will remain on Ready for a few minutes. Refresh the panel if needed. If there are configuration issues, such as incorrect connection parameters or an invalid account, the status will remain Ready. Click to display the logs and troubleshoot. If everything is configured correctly, the status will change to In Progress.
To access a historical view of each of these metrics, click and a pop-up chart will be displayed.
To view the tools or the different actions you can perform on the SQL job, click .
