Environment
Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 Inventory
Novell ZENworks 10 Configuration Management with Support Pack 3 - 10.3 DatabaseNovell ZENworks 11 Configuration Management - ZCM 11 Database
Situation
Very slow database performance/utilization, with Asset Management queries.
Database query is not using correct join option.
High CPU utilization when running Asset management reports.
Database query is not using correct join option.
High CPU utilization when running Asset management reports.
Resolution
For ZCM 11: This is fixed in version 11.1 - see KB 7008746 "ZENworks Configuration Management 11.1 - update information and list of fixes" which can be found at https://www.novell.com/support
For ZCM 10.3.4: 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 10.3.4: 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
Additional Information
Root Cause:
A cartesian join is missing when joining LC_COMPONENT and NC_WORKSTATION tables.