SAP MaxDB Monitoring

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.

Prerequisites

Before configuring an SAP MaxDB for monitoring in IT-Conductor, follow the instructions below.

Account Requirements

1. Login to the Sqlcli with your SYSDBA/DBADMIN user as shown below:

>sqlcli -d <database_name> -u <dbadmin_user>,<dbadmin_password>

1. Create a database user with a STANDARD user class using the following script:

>CREATE USER <user_name> PASSWORD <user_password> STANDARD

Configure SAP MaxDB Monitoring in IT-Conductor

To configure SAP MaxDB monitoring in IT-Conductor, follow the instructions below.

Add New SAP MaxDB System

1. Visit service.itconductor.com and enter your login credentials.

2. Navigate to Dashboards → Administrator to access the Administrator's Dashboard.

3. Locate the MaxDB Instances actions panel and click the title to access the complete list.

Figure 1: MaxDB Instances Actions Panel in Administrator's Dashboard

1. Click the New MaxDB System button to start adding a new system for monitoring.

Figure 2: MaxDB Instances Actions Panel Page

1. Fill out all the necessary information in the New MaxDB System wizard. Once completed, click to add the system.

Figure 3a: New MaxDB System Wizard (New MaxDB Instance Screen)

• 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.

1. Provide the account information in the New Account screen and click to complete the configuration.

Figure 3b: New MaxDB System Wizard (New Account Screen)

• 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.

1. Verify if the system was added to the MaxDB Instances actions panel and check its status.

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.

1. 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.

Monitor SAP MaxDB System in IT-Conductor

To view the availability and performance metrics of a SAP MaxDB system, locate the MaxDB Servers node in the service grid.

Figure 4: SAP MaxDB Servers View in Service Grid

SAP MaxDB Systems Key Metrics

• 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 access a historical view of each of these metrics, click and a pop-up chart will be displayed.

Figure 5: SAP MaxDB Availability Chart in Service Grid

Data Disk Usage

To view the usage or the disk space consumed by the system processes, locate and expand the Data node in the service grid.

Figure 6: SAP MaxDB Data Disk Used Chart in Service Grid

Log Files Usage

To view the usage consumed by the log files, locate and expand the Log node in the service grid.

Figure 7: SAP MaxDB Log Files Used Chart in Service Grid

SQL Jobs

To view and run SQL jobs, navigate to the specific MaxDB server node and click SQL Jobs.

Figure 8: SQL Jobs Object Menu in Service Grid

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.

Figure 9: SAP MaxDB SQL Jobs

Figure 10: SAP MaxDB SQL Job Details

To view the tools or the different actions you can perform on the SQL job, click .

Figure 11: SAP MaxDB SQL Job Tools