LMDB Tools

LMDB Tools comprises several pages that allow you to report on the LMDB content or to maintain advanced configurations, like disaster recovery (DR)

LMDB Reporting for Technical Systems

LMDB Reporting for technical systems offers information about the header data of technical systems such as EXTSID, system type, Installation Number, short display text, Lifecycle status, and IT Admin role. Additionally, the system database, status of data supplier completeness checks, and consistency checks are provided. You can customize the columns and order of the result set and export it to Microsoft Excel.

  1. Open LMDB Tools
  2. Select "LMDB Reporting for Technical Systems"
  3. Enter the filters to restrict the reported technical systems
  4. Click the "Go" button

Mass-Maintenance for Custom Attributes

Starting with SAP Focused Run 4.0 FP02 it is possible to maintain several additional custom attributes at once via LMDB Tools.

Prerequisites:

  • Before you can maintain additional attributes you need to maintain them in transaction SM34, select view cluster VC_LMDB_ADD_ATTR, and choose Maintain.
  1. After selecting the systems in scope as described above, click the button "Edit Additional Attribute" on top of the results table
  2. Select the additional attribute you want to maintain
  3. Select if you want to edit or delete the additional attribute
  4. Enter the value for the additional attribute
  5. Select the systems from the list below
    1. You will only see systems for whose component and system type this additional attribute is available, as per cluster view VC_LMDB_ADD_ATTR
  6. Click "Update Additional Attribute Value"

New Technical System Editor

With SAP Focused Run 4.0 FP02, we introduced a new technical system editor in the "Technical Systems" view. 

This new technical system editor shows the managed system in a hierarchical view.

  • For SAP Focused Run 4.0 FP02 only Application Server ABAP and Java and SAP HANA Databases are supported.
  • With SAP Focused Run 4.0 FP03 we support all system types
  • Currently, the technical system editor only supports read access to the managed systems. Changes still have to be made in the classical technical system editor. 

To open the technical system editor click on the hierarchy icon next to the technical system name in the technical system list.

Access Editor

On the left side of the editor, you see the system hierarchy. On the right side, you see the details for the system component currently selected in the graph to the left.

For bigger systems, you can switch to a convenient tree view.

On the right, you will find the new Detail View and related links. The related links can take you to the classical technical system editor or use cases supported for the selected component.

Data Supplier Completeness Check

In LMDB Tools you can see the status of the data supplier completeness check for each system. 

The status shown in LMDB Tools is the last status provided by the Self-Monitoring Data Supplier Completeness Check metric. This means to see the status in LMDB Tools, you need to setup the Self-Monitoring for the managed system using a template where the metric is active.

Click on the data supplier status in the column "Data Supplier Completeness" to see the details for each data supplier. 

 

To (re)configure missing and outdated data suppliers, see SAP note 1869701 - Overview of the SLD Data Suppliers of Technical Systems

Consistency Checks

In LMDB, the status of system consistency can be evaluated via LMDB consistency checks.

Click on the check result bar in the column "Consistency Check" to see the checks and their results in detail.

 

The consistency checks can be executed one by one or all at once executing the report RLMDB_CHECK_REPAIR as described in SAP note 3457006.

To execute a consistency check for a specific system:

  1. Click on the check result bar in the column "Consistency Check"
  2. Click on the "Repeat Check" button on top of the table

For some checks, you can repair inconsistencies automatically. If this is possible the "Repair inconsistencies" button on top of the check table will be active. 

Find more information in the single checks in SAP note 3315520 - LMDB Consistency Checks

LMDB Reporting for Technical Instances (ABAP, JAVA and HANA systems)

LMDB Reporting for Technical Instances offers information about technical instances for ABAP, JAVA, and HANA systems like instance host, type, and name. You can customize the columns and order of the result set and export it to Microsoft Excel.

  1. Open LMDB Tools
  2. Select "LMDB Reporting for Technical Instances (ABAP, JAVA and HANA systems)"
  3. Enter the filters to restrict the reported technical instances
  4. Click the "Go" button

LMDB Reporting for Products and Software Components

The LMDB Reporting for Products and Software Components offers reporting in the LMDB for software components and product versions. Based on a reporting use case, different filter options are available to perform searches and create reports on the objects in LMDB. You can customize the columns and order of the result set and export it to Microsoft Excel.

  1. Open LMDB Tools
  2. Select "LMDB Reporting for Products and Software Components"
  3. Select the "Reporting Use Case" you want to use
  4. Enter the filters depending on the selected use case
  5. Click the "Go" button

LMDB Reporting for Hosts

LMDB Reporting for Hosts provides an overview of all currently existing hosts. In addition to the default columns, you can also display specific additional attributes of the hosts. Furthermore, you can perform searches, customize columns, sort, and export the table content to Microsoft Excel.

  1. Open LMDB Tools
  2. Select "LMDB Reporting for Hosts"
  3. Enter the filters to restrict the reported hosts
  4. Click the "Go" button

Cross Data Center Database Replication Association Maintenance

Cross Datacenter Database Replication Association Maintenance enables you to maintain associations across different namespaces in the LMDB.

This concerns the "Disaster Recovery of Databases" use case, where the whole database setup is done in multiple data centers, resulting in a setup using multiple namespaces. An overall description of disaster recovery of SAP HANA is provided here.

For the technical implementation in the LMDB, you should consider the following example:

For disaster recovery (DR), we assume there are two data centers: one in Rot, where the primary and secondary databases are located, and one in Amsterdam, where the tertiary database is located. 

 

 

The registration information from Rot is sent via reverse proxy. It arrives in the persistence layer via the WBEM client and CIMOM. The databases are stored in Namespace 1. In LMDB, the primary database is associated with the secondary database. The secondary database is also associated with the tertiary database. However, since the tertiary database is not in Namespace 1, it is only an empty placeholder.

The data center in Amsterdam reports the information for the tertiary database via the reverse proxy into LMDB. The database is reported for Namespace 2. The database appears to be complete. There are no associations to the databases in Namespace 1. This is our starting point.

We have enhanced the LMDB with the LMDB tool Cross Data Center Database Replication Association Maintenance to realize associations between databases in different namespaces. In this tool, you can create the namespace-independent associations.

In case of a failover, the primary and disaster recovery databases are exchanged.

  1. Open LMDB Tools
  2. Go to "Cross Data Center Database Replication Association Maintenance"
  3. Click "Create Cross Association"
  4. Select the database in the Primary Data Center, that has the logical association to the database in the Disaster Recovery Data Center (in our example the secondary DB)
  5. Select the database that belongs to it in the Disaster Recovery Data Center
  6. Click the "Create" button