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