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

DB6CK114 - Overview

• 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 *