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

SAP Error Message - Details

• 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 Database Configuration: Ensure that the database settings allow for the reorganization of the tables in question. This may involve checking the database parameters or settings related to AUTO REORG.
  
  
  Manual Reorganization: If the tables cannot be included in the AUTO REORG process, consider performing a manual reorganization of these tables during a maintenance window when the impact on performance will be minimal.
  
  
  Consult Documentation: Refer to the SAP and database documentation for specific guidelines on managing event monitor tables and their reorganization.
  
  
  Database Administration: If you are not the database administrator, consult with your DBA team to understand the implications of reorganizing these tables and to ensure that any actions taken are in line with best practices.
  
  
  Monitoring and Alerts: Set up monitoring for the event monitor tables to ensure that they do not grow excessively and impact performance. This may involve creating alerts for when certain thresholds are reached.
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional context or solutions for this specific error message.
  Database Documentation: Review the documentation for the specific database you are using (e.g., HANA, Oracle, SQL Server) for best practices regarding table reorganization.
  Performance Tuning: Consider performance tuning strategies for your database to minimize the need for frequent reorganization.
  
  By following these steps, you should be able to address the DB6CK117 error and ensure that your event monitor tables are managed effectively.