How To Fix DB6CK113 - Enable monitoring object metrics in database configuration

SAP Error Message - Details

• Message type: E = Error

• Message class: DB6CK - DB6: System Check Messages

• Message number: 113

• Message text: Enable monitoring object metrics in database configuration

To enable the monitoring object metrics in the database configuration,
proceed as follows:
Choose <LS>Configuration -> Database</>.
Change the parameter <NP>'MON_OBJ_METRICS'</> to value '&EXPECTED_VALUE&
'.
If you do not have sufficient authorizations in the DBA Cockpit, you can
also change the parameter on command line as follows:
RESET N1
Log on to the database server '&SERVER_NAME&' as user '&INSTANCE_OWNER&
'.
Execute the following command:
db2 "UPDATE DB CFG FOR &DATABASE_NAME& USING MON_OBJ_METRICS
&EXPECTED_VALUE& IMMEDIATE"

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6CK113 - Enable monitoring object metrics in database configuration ?

  The SAP error message DB6CK113 indicates that monitoring object metrics are not enabled in the database configuration. This is typically related to the database monitoring settings within the SAP system, which are crucial for performance monitoring and troubleshooting.
  Cause:
  The error occurs when the database monitoring settings are not properly configured to collect metrics for monitoring objects. This can happen due to:
  
  Database Configuration: The database monitoring settings may not be enabled or configured correctly in the SAP system.
  Missing Permissions: The user or service account may not have the necessary permissions to access or modify the database monitoring settings.
  Database Type: Certain database types may require specific configurations to enable monitoring.
  
  Solution:
  To resolve the DB6CK113 error, follow these steps:
  
  
  Check Database Configuration:
  
  Access the SAP system and navigate to the database configuration settings.
  Ensure that the monitoring object metrics are enabled. This can usually be done through transaction codes like DBACOCKPIT or DB02.
  
  
  
  Enable Monitoring:
  
  If monitoring is not enabled, you may need to enable it. This can typically be done in the database configuration settings or through the SAP GUI.
  Look for options related to "Enable Monitoring" or "Monitoring Object Metrics" and ensure they are checked.
  
  
  
  Review User Permissions:
  
  Ensure that the user account being used has the necessary permissions to modify database settings. You may need to consult with your SAP Basis administrator to verify and adjust permissions.
  
  
  
  Consult Documentation:
  
  Refer to the official SAP documentation for your specific database type (e.g., HANA, Oracle, SQL Server) for detailed instructions on enabling monitoring.
  
  
  
  Restart Services:
  
  In some cases, after making changes to the configuration, it may be necessary to restart the database services or the SAP application server for the changes to take effect.
  
  
  
  Check for Updates:
  
  Ensure that your SAP system is up to date with the latest patches and updates, as there may be bug fixes or enhancements related to monitoring.
  
  
  
  Related Information:
  
  SAP Notes: Check SAP Notes related to database monitoring for any specific instructions or known issues.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as DBACOCKPIT, DB02, and ST04 for database monitoring and performance analysis.
  SAP Community: Engage with the SAP Community forums for discussions and solutions related to similar issues faced by other users.
  
  If the issue persists after following these steps, consider reaching out to SAP support for further assistance.