DB6PMHSD - DB6: Database Performance Statistics History

DB6: Database Performance Statistics History information is stored in SAP table DB6PMHSD.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".

Fields for table DB6PMHSD

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SYSIDName of SAP SystemXSYSYSIDCHAR8
COMPTIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS)XDB6TSTAMPCHAR14
PARTITNDB6: partition numberXINT44
PL_D_LRSDB6: data logical readsDEC12
PL_D_PRSDB6: data physical readsDEC12
PL_D_WSDB6: data physical writesDEC12
PL_I_LRSDB6: index logical readsDEC12
PL_I_PRSDB6: index physical readsDEC12
PL_I_WSDB6: index physical writesDEC12
CMMT_SQLSTDB6: commit statementsDEC12
RBCK_SQLSTDB6: rollback statementsDEC12
LCK_WAITSDB6: lockwaits since 1st db connectionDEC12
LCK_W_TMDB6: total time db waited on locks in millisecondsDEC12
DEADLOCKSDB6: deadlocks since 1st db connectionDEC12
LCK_ESCALSDB6: lock escalations since 1st db connectionDEC12
XLK_ESCALSDB6: X lock escalations since 1st db connectionDEC12
BP_AV_RTMDB6: Average Physical Read Time (ms)DEC12
BP_AV_WTMDB6: Average Physical Write Time (ms)DEC12
Privacy Policy