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

DB6CK116 - Overview

• 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