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

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author