Novell is now a part of Micro Focus

My Favorites


Please to see your favorites.

ZCM Primary server can consume more database connections than specified in zdm.xml

This document (7011428) is provided subject to the disclaimer at the end of this document.


Novell ZENworks Configuration Management 11.2 Database
Novell ZENworks Asset Management 11.2
Novell ZENworks Patch Management 11.2


The server is configured to have the default number of maximum database connections.

The MaxPoolSize value in the zdm.xml configuration file is set to 100.

Monitoring the number connections to the database port using netstat shows that the number can exceed 100.


This is expected behavior: both main ZCM Primary server processes connecting to the SQL database, zenloader and zenserver, maintain their own database connection pool. Both pools can grow up to the configured MaxPoolSize number. So effectively the maximum number connections is actually twice the configured number.

ZENworks Reporting Server has additional database connections not controlled by this MaxPoolSize value.

Note also in 11.3 and later, the inventory process and zenloader batch process maintain a separate connection pool of 100 in addition to above.  Additionally, zenloader and zenserver maintain connections to the Adit Database.  For more information see

Additional Information

The zdm.xml is located at:
- Windows: %zenworks_home%\conf\datamodel
- Linux: /etc/opt/novell/zenworks/datamodel

By default the MaxPoolSize value is:
<entry key="MaxPoolSize">100</entry>


This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7011428
  • Creation Date:28-NOV-12
  • Modified Date:14-OCT-14
    • NovellZENworks Asset Management
      ZENworks Configuration Management
      ZENworks Patch Management

Did this document solve your problem? Provide Feedback