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

DB6PM888 - Overview

• 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