How To Fix DB6CK116 - Event monitor tables are not excluded from AUTO REORG

SAP Error Message - Details

• Message type: E = Error

• Message class: DB6CK - DB6: System Check Messages

• Message number: 116

• Message text: Event monitor tables are not excluded from AUTO REORG

AUTO_REORG is enabled for the system and the automatic maintenance
policy does not exclude event monitor tables.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Automatic maintenance = &AUTO_MAINT&
Automatic table maintenance = &AUTO_TBL_MAINT&
Automatic reorganization = &AUTO_REORG&
Policy installed = &POLICY_INSTALLED&
Offline maintenance window = &OFFLINE_MAINT_WINDOW&
Event monitor tables excluded = &EVT_TBL_EXCLUDED&
The DB2 fast writers (db2fw*) hold a permanent exclusive table lock on
the corresponding event monitor tables. If an offline REORG is triggered
by AUTO_REORG on these tables, the automatic maintenance (db2hmon)
cannot obtain the table lock and continues to wait. These lock waits
can result in "transaction log full" situations.
Another impact of this lock-wait situation can be that data
collectors for table-related metrics or data collectors based on event
monitors get the following SQL error:
SQL0911N The current transaction has been rolled back because of a
deadlock or timeout. Reason code "68". SQLSTATE=40001

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6CK116 - Event monitor tables are not excluded from AUTO REORG ?

  The SAP error message DB6CK116 indicates that the event monitor tables in your database are not excluded from the automatic reorganization (AUTO REORG) process. This can lead to issues because event monitor tables are typically used for logging and monitoring purposes, and reorganizing them can disrupt their functionality.
  Cause:
  The primary cause of this error is that the event monitor tables are included in the list of tables that are subject to automatic reorganization. This can happen due to misconfiguration in the database settings or the reorganization settings.
  Solution:
  To resolve this issue, you need to exclude the event monitor tables from the AUTO REORG process. Here are the steps to do this:
  
  
  Identify Event Monitor Tables: Determine which tables are classified as event monitor tables in your SAP system. These tables usually have specific naming conventions or are documented in your system's configuration.
  
  
  Modify AUTO REORG Settings:
  
  Access the database configuration settings where the AUTO REORG parameters are defined.
  Exclude the identified event monitor tables from the AUTO REORG process. This can typically be done by modifying the configuration file or using a database management tool.
  
  
  
  Verify Changes: After making the changes, verify that the event monitor tables are no longer included in the AUTO REORG process. You can do this by checking the configuration settings again or running a test to see if the error persists.
  
  
  Monitor System Behavior: After the changes, monitor the system to ensure that the event monitor tables are functioning correctly and that the error message does not reappear.
  
  
  Related Information:
  
  Documentation: Refer to the SAP documentation or your database vendor's documentation for specific instructions on configuring AUTO REORG settings.
  Database Management Tools: Use database management tools provided by your database vendor to manage and configure table settings more easily.
  SAP Notes: Check SAP Notes for any specific recommendations or patches related to this error message, as there may be updates or fixes available.
  
  If you continue to experience issues after following these steps, consider reaching out to SAP support or your database administrator for further assistance.