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.

Environment

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

Situation

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.

Resolution

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.

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>
..."

Disclaimer

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:28-NOV-12
- NovellZENworks Asset Management
  ZENworks Configuration Management
  ZENworks Patch Management

Did this document solve your problem? Provide Feedback