How To Fix DB6PM888 - The current version of the MDC Advisor is subject to restrictions:

SAP Error Message - Details

• Message type: E = Error

• Message class: DB6PM - DB2 UDB for UNIX, Windows: Performance Monitoring

• Message number: 888

• Message text: The current version of the MDC Advisor is subject to restrictions:

The current version of the MDC Advisor only proposes MDC settings that
increase the size of the fact tables by up to 10%.
The SAP BW system allows MDC settings that increase the size of the fact
tables up to 33 %. Therefore, MDC settings can exist that increase the
performance of the SAP BW system, but that are not part of the proposal
of the MDC Advisor.
The current version of the MDC Advisor cannot take account of the two
time characteristics SID_0FISCPER and SID_0CALMONTH of SAP BW InfoCubes.
If the collected BW reporting queries have restrictions on these time
characteristics, the SAP BW system displays an additional message
together with the results of the MDC Advisor. The message explains that
the MDC advisor has not considered SID_0FISCPER and SID_0CALMONTH in its
estimation.
Note:
The SAP BW system allows MDC settings with the two time characteristics
SID_0FISCPER and SID_0CALMONTH for a SAP BW InfoCube. Considering these
two characteristics in the MDC configuration could increase SAP BW query
performance.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6PM888 - The current version of the MDC Advisor is subject to restrictions: ?

  The SAP error message DB6PM888 indicates that the current version of the Multi-Dimensional Database (MDC) Advisor is subject to certain restrictions. This error typically arises in the context of database management and optimization within SAP systems, particularly when using the MDC Advisor tool for performance tuning and analysis.
  Cause:
  
  Version Compatibility: The version of the MDC Advisor you are using may not be compatible with the current database version or the SAP system version.
  Licensing Issues: There may be licensing restrictions that limit the functionality of the MDC Advisor.
  Configuration Issues: The system may not be properly configured to utilize the full capabilities of the MDC Advisor.
  Feature Limitations: Certain features of the MDC Advisor may be restricted based on the database or system configuration.
  
  Solution:
  
  Check Version Compatibility: Ensure that you are using a version of the MDC Advisor that is compatible with your SAP system and database version. You may need to upgrade the MDC Advisor or your SAP system.
  Review Licensing: Verify that you have the appropriate licenses for the features you are trying to use within the MDC Advisor. If necessary, contact your SAP account representative for assistance.
  Configuration Review: Check the configuration settings of your SAP system and the MDC Advisor. Ensure that all necessary parameters are set correctly.
  Consult Documentation: Refer to the official SAP documentation for the MDC Advisor to understand any restrictions or limitations that may apply to your current setup.
  Contact SAP Support: If the issue persists, consider reaching out to SAP Support for further assistance. They can provide specific guidance based on your system configuration and the error message.
  
  Related Information:
  
  SAP Notes: Look for relevant SAP Notes that may address this specific error message or provide updates regarding the MDC Advisor.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they have found.
  System Logs: Check system logs for any additional error messages or warnings that may provide more context about the issue.
  
  By following these steps, you should be able to identify the cause of the DB6PM888 error and implement a suitable solution.