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:

  • Show details Hide details
  • 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

    Already have an account? Login here!




Instant HelpGet instant SAP help. Sign up for our Free Essentials Plan.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
The AI Support Assistant is great. It provides comprehensive assistance even on the most difficult issues. I highly recommend this service.
Rate 1
John Jordan
SAP Consultant & Author