How To Fix DB6PM755 - DBCFG: invalid combination MAXLOCKS <---> MAXAPPLS

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 755

• Message text: DBCFG: invalid combination MAXLOCKS <---> MAXAPPLS

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message DB6PM755 - DBCFG: invalid combination MAXLOCKS <---> MAXAPPLS ?

  The SAP error message DB6PM755 DBCFG: invalid combination MAXLOCKS <---> MAXAPPLS typically indicates a configuration issue related to the database settings in the SAP system, specifically concerning the parameters MAXLOCKS and MAXAPPLS. 
  Cause:
  
  
  Parameter Mismatch: The error arises when the values set for MAXLOCKS and MAXAPPLS are incompatible. MAXLOCKS defines the maximum number of locks that can be held by a single application, while MAXAPPLS defines the maximum number of applications that can be connected to the database at the same time. If the configuration does not allow for a valid combination of these two parameters, the error will occur.
  
  
  Database Configuration: This can happen if the database configuration was changed without properly adjusting the related parameters, or if the parameters were set incorrectly during the initial setup.
  
  
  Solution:
  
  
  Review Parameter Settings: Check the current values of MAXLOCKS and MAXAPPLS in your database configuration. You can usually find these settings in the database configuration files or through the database management interface.
  
  
  Adjust Values: 
  
  Ensure that the value of MAXLOCKS is not greater than the product of MAXAPPLS and the maximum number of locks that each application can hold. 
  For example, if MAXAPPLS is set to 10 and each application can hold a maximum of 5 locks, then MAXLOCKS should not exceed 50.
  
  
  
  Consult Documentation: Refer to the specific database documentation for guidelines on setting these parameters. Each database system (like DB2, Oracle, etc.) may have different recommendations.
  
  
  Restart Database: After making changes to the configuration, you may need to restart the database for the changes to take effect.
  
  
  Test the Configuration: After adjustments, test the configuration to ensure that the error no longer occurs and that the system operates as expected.
  
  
  Related Information:
  
  Database Documentation: Always refer to the official documentation for your specific database system for detailed information on configuration parameters.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that might address this specific error or provide additional guidance.
  Monitoring Tools: Use database monitoring tools to keep track of lock usage and application connections to prevent similar issues in the future.
  
  If the problem persists after making the necessary adjustments, consider reaching out to SAP support or your database administrator for further assistance.