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

SAP Error Message - Details

• Message type: E = Error

• Message class: DB6CK - DB6: System Check Messages

• Message number: 107

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

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 missing, you may need to reinstall or recreate it. This typically involves running a script provided by IBM Db2 to set up the WLM features.
  
  
  
  Database Configuration:
  
  Ensure that your Db2 database is configured to support workload management. You may need to enable WLM features in your database configuration.
  
  
  
  Check Permissions:
  
  Verify that the user has the necessary permissions to execute the procedure. You may need to grant execute permissions:
  GRANT EXECUTE ON PROCEDURE SYSPROC.WLM_COLLECT_STATS TO <user>;
  
  
  
  
  Consult Documentation:
  
  Refer to the official IBM Db2 documentation for your specific version to ensure that you are following the correct procedures for setting up and using WLM.
  
  
  
  Contact Support:
  
  If the issue persists after trying the above steps, consider reaching out to IBM support or your database administrator for further assistance.
  
  
  
  Related Information:
  
  Db2 Version: Ensure you are aware of the version of Db2 you are using, as features and procedures may vary between versions.
  WLM Documentation: Familiarize yourself with the Workload Management documentation provided by IBM to understand how to properly configure and utilize these features.
  SAP Notes: Check SAP Notes for any specific guidance or patches related to this error message, as SAP may have specific recommendations for their applications running on Db2.
  
  By following these steps, you should be able to diagnose and resolve the DB6CK107 error effectively.