Environment
Novell ZENworks 10 Configuration Management with Support Pack 1 - 10.1 Database
Microsoft SQL 2005 Cluster
Situation
After about two hours the ZCC becomes unresponsive.
If the SQL cluster is rebooted, the ZCC becomes responsive again and users can login.
SQL log file shows database is waiting on 'update zUserPrimaryDeviceInformation'
Resolution
This is fixed in version 10.1.3 - see KB 7002526 "ZENworks 10 Configuration Management 10.1.3" which can be found at https://www.novell.com/support