Die wichtigsten SAP Basis Transaktionen im Überblick: Symptome: Hilfreich bei der Analyse von Datenbankgrössen und Statistiken zur Optimierung der Datenbankleistung. Zweck: Anzeige von Datenbankstatistiken zur Optimierung der Datenbankstruktur. Vorbedingungen: Datenbankzugriffsrechte und statistische Analysekenntnisse. Der Zweck von SAP DB02 ist die Überwachung und Analyse der Datenbankperformance im SAP-System. Mit DB02 können Administratoren Informationen über die Auslastung […]
The script is useful for automated monitoring of SAP system connectivity and logging connection events, making it ideal for system administrators to ensure the availability and integrity of their SAP systems. The Bash script checks the connection to a MessageServer of a SAP system instance. Here is a summary of its functionalities:
Connection Test: The script tests the nc connection to a MessageServer of a SAP system instance. It utilizes the check_connection function to perform the connection check.
Logging: The script logs the test results in two files: connectiontest.txt contains all test results, while connectiontest-failed.txt stores only failed connection attempts.
Notification on Connection Failures: In case of a connection failure, the script sends an email notification to the specified email address.
Cleanup of Old Entries: The script deletes old timestamps from the connectiontest.txt log file after 10 days to maintain file cleanliness and save storage space.
Endless Loop for Periodic Testing: The script includes a commented-out endless loop that performs connection tests at regular intervals. This feature can be enabled to continuously monitor the connection. It is recommended to set up a cronjob for this purpose.
Termination of nc Sessions: Upon completion of the script, it terminates all running nc sessions belonging to the current user.
bash script for the NETCAT connection test to a SAP S/4HANA system Read More »
Our security.txt generator according to RFC 9116 is user-friendly and offers a customized creation of the security.txt file. You do not need extensive technical knowledge to benefit from this service. The file is created according to the latest Internet Engineering Task Force (IETF) standards and can contain important information such as contact details, vulnerability reporting guidelines and encryption information where applicable.
This file serves as a direct communication bridge between security researchers and your organization to report vulnerabilities efficiently and securely. Having a clearly defined contact option on your website can be critical to quickly addressing and remediating potential security risks.
When researchers discover vulnerabilities, there is often a lack of appropriate reporting channels. As a result, vulnerabilities may not be reported. This document defines a machine-readable format (“security.txt”) to help organizations describe their vulnerability disclosure practices to make it easier for researchers to report vulnerabilities.
security.txt generator for enterprise Read More »
HowTo:
When a column is loaded, it is copied from persistence into SAP HANA column store memory.
Unloads are table column displacements from column store memory.
In this SAP Note we focus on loads and unloads of columns in column store. Tables in row store are typically loaded during startup and remain in memory permanently.
Hot Data: Used to store very critical data for fast & real-time and analytical processing usually stored in DRAM [dynamic RAM], PMEM [Persistent Memory]
Warm Data: Used to store data that are not frequently used and need not reside continuously in SAP HANA memory. NSE manages this data as an expanded disk. Query performance on warm data might be reduced compared to hot data.
Cold Data: Used to store data that is rarely accessed.
SAP Native Storage Extension [NSE] – SAP HANA Native Storage Extension is HANA’s built-in warm storage solution. By default, in HANA 2.0 SP 04 & in SAP HANA CLOUD NSE is enabled, there is no different action needed aside from implementing correct SQL/DDL declarations.
SAP HANA Native Storage Extension with Partition of table EDID4 Read More »
Neues OpenAI GPT Tool mit SAP Datenbank-Fokus: Der SAP HANA DevOps Co-Pilot wurde trainiert, um die Entwicklung, den Betrieb und die Verwaltung von SAP HANA zu vereinfachen. Dank des SAP HANA DevOps Co-Pilot können Unternehmen die Performance der SAP HANA Datenbank signifikant verbessern, was zu schnelleren Berichterstattungen und einer effizienteren Entscheidungsfindung führte. Der gesamte Prozess wird durch die Automatisierung und die Expertise des Co-Pilots effizient und risikoarm.
Um den SAP HANA DevOps Co-Pilot selbst zu testen ist lediglich ein OpenAI Account erforderlich. Dieser Artikel zeigt unterschiedliche Themengebiete der Datenbank-Administration und liefert fünf Beispiele wie der SAP HANA DevOps Co-Pilot helfen kann:
Administration der SAP HANA Datenbank: Integration von LDAP in SAP HANA mit dem DevOps Co-Pilot.
Entwicklung auf der SAP HANA Platform: Die Erstellung einer “Hello World” XSA-Anwendung in SAP HANA .
Performance Optimierung SAP HANA SQL: Optimierung der SQL-Performance durch Partitionierung in SAP HANA.
Integration auf der SAP HANA Platform: Einrichtung einer Remote Source und Anlegen virtueller Tabellen mit SAP HANA Smart Data Access (SDA).
Machine Learning auf der SAP HANA Platform: Optimierung von Sicherungsbestand und optimaler Bestellmenge mit SAP HANA und Machine Learning.
SAP HANA DevOps Co-Pilot Read More »
