Data Description

The MSS_DB02_OVVW event is used in SAP to view the space associated with the database and the database log.

Potential Use Cases

This event could be used in the following scenarios:

  • Alert if the log is filling up.

  • Alert if there are space issues with the database.

  • Trend database file size over time.

Splunk Event

The event will look like this in Splunk:

SAP Navigation

Log into the managed system and execute the dbacockpit transaction code. Then expand the Space menu option on the left side of the screen and double-click the Overview option. Then click on the Overview tab that appears in the center of the screen. The information shown will match the data that is extracted and sent to Splunk.

Field Mapping

Field

Description

Unit of Measure

CURRENT_TIMESTAMP

The date time stamp when the information was collected

YYYYMMDDHHMMSS

DATAFREEMB

Data free MB

Number

DATAFREEPCT

Data free percentage

Number (Percent)

DATALLOCMB

Data allocated MB

Number

DATALLOCPCT

Allocated MB percentage

Number (Percent)

DATANUMFILES

Number of Files

Number

DATATOTALFREEDISKMB

Free MB

Number

DATATOTALMB

Total database size

Number

EVENT_SUBTYPE

String

EVENT_TYPE

MSS_DB02_OVVW

String

LOGALLOCMB

Log allocated MB

Number

LOGFREEMB

Log free MB

Number

LOGFREEPCT

Log free percent

Number (Percent)

LOGNUMFILES

Number of log files

Number

LOGTOTALMB

Log total MB

Number

LOGUSEDPCT

Log used percentage

Number (Percent)

OBJ_DB

Database name

String

OBJ_SCHEMA

Schema name

String

RECOVERY

Recovery model

String

REUSEWAITREASON

Reuse wait reason

String

RT_MINS

Runtime [minutes]

Number

SQLSESSID

SQL session ID

Number

SUMMARYMESS

Summary

String

TRANSTARTIME

Oldest open transaction start time

Month DD YYYY HH:MM

UTCDIFF

The UTC OFFSSET in HHMMSS that the data was collected in

HHMMSS

UTCSIGN

The UTC positive or negative OFFSET indicator. Positive (+) means add UTCDIFF to find the time zone of the data, negative (-) means subtract the UTCDIFF to find the time zone adjusted date time the data was collected in.

+ | -