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

  • 7011428
  • 28-Nov-2012
  • 14-Oct-2014


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 https://www.novell.com/documentation/zenworks113/zen11_cm_deployment_bp/data/b18zqmxk.html#b19nfm0o

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>