Show TOC

E2E DB Reporting: Database Log Size - Overview Locate this document in the navigation structure

Query Query: 0E2EREP_ALLSYS_DBH_LOGSIZE

 

This query is used in interactive reporting in the Technical Monitoring work center. For the selected databases, the report shows the utilization of the log memory and remaining free memory space in the log memory, that is, the memory space that is used for logs in the respective database.

This query is used in the following report:

  • Start of the navigation path Overview Next navigation step Capacity Next navigation step Log Utilization End of the navigation path

The query is used in the following Web Template:

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Metric Type

0DBH_METY

= DB Capacity [DB Capacity]
Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

System ID

0SMD_LSID

—
Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Log Memory Usage [GB]

= ‘Mean used log memory [MB]’/1024

Free Log Memory [GB]

= ‘Log Size [GB]’ – ‘Used Log Memory [GB]’

Log Size [GB]

= ‘Mean total log memory [MB]’/1024

Mean used log memory [MB]

‘Key value’ [1KYFNM] = ‘Mean’ [0DBH_MP01_CK000]

‘Metric name’ [0DBH_MENA] = Log Used Size [MB]

Mean total log memory [MB]

‘Key value’ [1KYFNM] = ‘Mean’ [0DBH_MP01_CK000]

‘Metric name’ [0DBH_MENA] = Log Size [MB]