Message type: E = Error
Message class: DB6CK - DB6: System Check Messages
Message number: 107
Message text: Check missing SYSPROC.WLM_COLLECT_STATS() procedure
Error message extract from SAP system. Copyright SAP SE.
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
Get instant SAP help. Sign up for our Free Essentials Plan.
DB6CK106
Enable monitoring request metrics in database configuration
To enable the monitoring request metrics in the database configuration, proceed as follows: Choose <LS>Configuration -> Database</>. C...
DB6CK105
Monitoring request metrics are not enabled in database configuration
The configuration of the monitoring request metrics MON_REQ_METRICS is not enabled in the database configuration. The current value of the database c...
DB6CK108
Check of configuration of monitoring activity metrics
The configuration of the monitoring activity metrics MON_ACT_METRICS is enabled in the database configuration. The current value of the database conf...
DB6CK109
Monitoring activity metrics are not enabled in database configuration
The configuration of the monitoring activity metrics MON_ACT_METRICS is not enabled in the database configuration. The current value of the database ...
Click on this link to search all SAP messages.