How To Fix DB6CK114 - Procedure SYSPROC.WLM_COLLECT_STATS() is missing

SAP Error Message - Details

• Message type: E = Error

• Message class: DB6CK - DB6: System Check Messages

• Message number: 114

• Message text: Procedure SYSPROC.WLM_COLLECT_STATS() is missing

With IBM DB2 V9.5 FP7 and IBM DB2 V9.7 FP4 for Linux, UNIX, and Windows,
a new version of the DB2 procedure SYSPROC.WLM_COLLECT_STATS was
introduced. After a Fix Pack update, this procedure is registered
automatically when you execute the db6_update_db script from SAP Note
1365982.
If the new version of the SYSPROC.WLM_COLLECT_STATS procedure is not
found, the WLM statistics data collector cannot use the optimal
implementation for this database.
In these cases, check whether the db6_update_db script was really
executed.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6CK114 - Procedure SYSPROC.WLM_COLLECT_STATS() is missing ?

  The error message DB6CK114 Procedure SYSPROC.WLM_COLLECT_STATS() is missing typically occurs in IBM Db2 databases when the system is unable to find the specified stored procedure, which is related to workload management (WLM) statistics collection. This can happen for several reasons, including missing or improperly configured database objects.
  Causes:
  
  Missing Procedure: The procedure SYSPROC.WLM_COLLECT_STATS() may not exist in the database. This can happen if the database was not set up correctly or if the procedure was inadvertently dropped.
  Schema Issues: The procedure might exist in a different schema, and the current user does not have the necessary permissions to access it.
  Database Version: The version of Db2 you are using may not support this procedure, or it may have been deprecated in your version.
  Corrupted Database: In rare cases, database corruption could lead to missing system procedures.
  
  Solutions:
  
  
  Check for Existence: Verify if the procedure exists in the database by running a query against the system catalog:
  SELECT * FROM SYSIBM.SYSPROCEDURES WHERE NAME = 'WLM_COLLECT_STATS';
  If it does not exist, you may need to recreate it or restore it from a backup.
  
  
  Recreate the Procedure: If the procedure is missing, you may need to recreate it. This can often be done by running a script provided by IBM or by reinstalling the relevant Db2 components.
  
  
  Check Permissions: Ensure that the user executing the command has the necessary permissions to access the procedure. You can grant the required permissions using:
  GRANT EXECUTE ON PROCEDURE SYSPROC.WLM_COLLECT_STATS TO <user>;
  
  
  Database Version Compatibility: Check the documentation for your specific version of Db2 to ensure that the procedure is supported. If it is not, you may need to upgrade your database or find an alternative method for collecting WLM statistics.
  
  
  Consult Documentation: Refer to the official IBM Db2 documentation for your version to understand the context and usage of the WLM_COLLECT_STATS procedure.
  
  
  Contact Support: If the issue persists after trying the above solutions, consider reaching out to IBM support for assistance, especially if you suspect database corruption or other underlying issues.
  
  
  Related Information:
  
  Db2 Documentation: Always refer to the official IBM Db2 documentation for the most accurate and detailed information regarding procedures and their usage.
  Database Backup: Regularly back up your database to prevent loss of critical procedures and data.
  Monitoring and Maintenance: Implement regular monitoring and maintenance practices to ensure the health of your database and its objects.
  
  By following these steps, you should be able to diagnose and resolve the issue related to the missing SYSPROC.WLM_COLLECT_STATS() procedure.