High table counts in database degrading ZCM performance

  • 7007240
  • 22-Nov-2010
  • 26-Feb-2013

Environment

Novell ZENworks 11 Configuration Management
Novell ZENworks 10 Configuration Management

Situation

NC_COMPCHANGES table has millions of entries
ZENserver service hangs, slow responsiveness in zcc.
The tables are so large they are taxing the server to perform queries.

Resolution

For ZCM 10.3: This is fixed in version 10.3.4 - see KB 7008244 "ZENworks Configuration Management 10.3.4 - update information and list of fixes" which can be found at https://www.novell.com/support
 
 For ZCM 11.x:  This is fixed in version 11.2 - see KB 7010044 "ZENworks Configuration Management 11.2 - update information and list of fixes" which can be found at https://www.novell.com/support

Feedback service temporarily unavailable. For content questions or problems, please contact Support.