Data Description

The HDB_DBCC_MTABID event is used in SAP to missing tables and indexes for the HANA DB.

Potential Use Cases

This event could be used in the following scenarios:

  • Correlate missing tables and indexes to poor SQL query performance or transaction failures.

  • Identify performance improvements after code changes move in the environment.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Execute the dbacockpit transaction in the system. Open the Diagnostics folder and double-click on “Missing Tables and Indexes”. The information displayed on the right side of the screen will match the data that is extracted and sent to Splunk.