How To Fix DB6CK107 - Check missing SYSPROC.WLM_COLLECT_STATS() procedure


DB6CK107 - Overview

  • Message type: E = Error

  • Message class: DB6CK - DB6: System Check Messages

  • Message number: 107

  • Message text: Check missing SYSPROC.WLM_COLLECT_STATS() procedure

  • Show details Hide details
  • As of IBM DB2 V9.5 FP7 and IBM DB2 V9.7 FP4, a new version of the DB2
    procedure SYSPROC.WLM_COLLECT_STATS was introduced.

    Error message extract from SAP system. Copyright SAP SE.


Smart SAP Assistant

  • What is the cause and solution for SAP error message DB6CK107 - Check missing SYSPROC.WLM_COLLECT_STATS() procedure ?
    The SAP error message DB6CK107, which indicates that the SYSPROC.WLM_COLLECT_STATS() procedure is missing, typically arises in the context of IBM Db2 databases. This procedure is part of the Workload Management (WLM) feature in Db2, which is used for collecting statistics on workload performance.
    
    Cause: The error can occur due to several reasons: Missing Procedure: The SYSPROC.WLM_COLLECT_STATS() procedure is not installed or has been removed from the database. Database Configuration: The database may not be configured to support workload management features. Version Compatibility: The version of Db2 being used may not support the WLM features or the specific procedure. Permissions: The user executing the command may not have the necessary permissions to access or execute the procedure.
    Solution: To resolve the DB6CK107 error, you can take the following steps: Check for Procedure Existence: Run a query to check if the WLM_COLLECT_STATS procedure exists in the SYSPROC schema:SELECT * FROM SYSCAT.PROCEDURES WHERE PROCNAME = 'WLM_COLLECT_STATS'; Install or Recreate the Procedure: If the procedure is

    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