How To Fix DB6CK117 - Exclude event monitor tables from AUTO REORG

DB6CK117 - Overview

• Message type: E = Error

• Message class: DB6CK - DB6: System Check Messages

• Message number: 117

• Message text: Exclude event monitor tables from AUTO REORG

In SAP Note 975352, it is recommended to disable the offline
maintenance window:
Choose <LS>Configuration -> Automatic Maintenance</>.
Choose the <LS>Configure</> pushbutton.
In step 2, disble the offline maintenance window.
Implement the changed automatic maintenance policy.

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

If you still want to have the offline maintenance window enabled, you
must exclude the event monitor tables from automatic offline
reorganization:
RESET N1
Choose <LS>Configuration -> Automatic Maintenance</>.
Choose the <LS>Configure</> pushbutton.
In step 7, choose the <LS>SAP Default</> configuration profile or
ensure that the following table filter is specified:
(TABSCHEMA, TABNAME) NOT IN (SELECT TABSCHEMA, TABNAME FROM
SYSCAT.EVENTTABLES)

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6CK117 - Exclude event monitor tables from AUTO REORG ?

  The SAP error message DB6CK117 indicates that the system has detected that certain event monitor tables are being excluded from the automatic reorganization (AUTO REORG) process. This is typically related to database performance and maintenance tasks.
  
  Cause:
  The error message is triggered when the database system identifies that specific tables, particularly those related to event monitoring, are not suitable for automatic reorganization. This can happen for several reasons:
  
  The tables may be actively used for monitoring purposes, and reorganizing them could disrupt ongoing processes.
  The tables may have specific configurations or settings that prevent them from being included in the AUTO REORG process.
  There may be a lack of necessary permissions or configurations in the database settings.
  
  
  Solution:
  To resolve this issue, you can take the following steps:
  
  
  Review the Event Monitor Tables: Identify which event monitor tables are being excluded. You can check the database documentation or use SQL queries to list the tables and their configurations.
  
  
  Check