How To Fix D3066 - Threshold for statistics counter ignored

SAP Error Message - Details

• Message type: E = Error

• Message class: D3 - CCMS - DB2 on OS390

• Message number: 066

• Message text: Threshold for statistics counter ignored

What causes this issue?

DB2 offers the possibility to filter the statements in the dynamic
statement cache by a number of statistics field with a given threshold.
To be eligible for reporting, a cached statement must have a value for
the selected statistics field that is not smaller than the threshold.
This option is not available for times counters.

System Response

The threshold for the selected statistics field is ignored.

How to fix this error?

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message D3066 - Threshold for statistics counter ignored ?

  The SAP error message D3066, which states "Threshold for statistics counter ignored," typically relates to the performance monitoring and statistics collection within the SAP system. This message indicates that the system has encountered a situation where the threshold set for a specific statistics counter is not being applied or is being ignored.
  Cause:
  
  Threshold Configuration: The threshold for the statistics counter may not be configured correctly or may not be applicable in the current context.
  System Settings: There may be system-wide settings or parameters that override the specific threshold settings for the statistics counter.
  Performance Monitoring: The system may be in a state where it cannot apply the threshold due to performance monitoring settings or limitations.
  Version or Patch Issues: There could be bugs or issues in the specific version of SAP you are using that affect how thresholds are handled.
  
  Solution:
  
  Check Configuration: Review the configuration settings for the statistics counters in the SAP system. Ensure that the thresholds are set correctly and are applicable to the current context.
  Review System Parameters: Check the system parameters that might affect the statistics counters. Look for any global settings that could override individual thresholds.
  Update SAP System: If you suspect that the issue is due to a bug, check for any available patches or updates for your SAP version that might address this issue.
  Consult Documentation: Refer to the SAP documentation or notes related to performance monitoring and statistics counters for any specific guidance on this error message.
  Contact SAP Support: If the issue persists and you cannot find a resolution, consider reaching out to SAP support for assistance. They may provide insights based on your specific system configuration and version.
  
  Related Information:
  
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address this specific error message or provide additional context.
  Performance Monitoring Tools: Familiarize yourself with the tools available in SAP for monitoring performance and statistics, such as the SAP Solution Manager or transaction codes like ST03N (Workload Analysis).
  Community Forums: Engage with the SAP community forums or user groups where similar issues may have been discussed, and solutions shared.
  
  By following these steps, you should be able to diagnose and potentially resolve the D3066 error message in your SAP system.