Environment
Novell ZENworks Configuration Management 11.2 Inventory
Novell ZENworks Asset Management 11.2
Novell ZENworks Asset Management 11.2
Situation
The ZCM SQL database is running on Sybase.
The SQL database has been growing on inventory information and it is desired to remove inventory and software usage tracking history.
The ZCM SQL database schema includes a function called zcm_purgehistory to remove historic inventory information as outlined in ZCM online documentation under Cleaning Up Historical Data from the Inventory (scroll down to '2.4.3 Cleaning Up Historical Data from the Inventory').
The script does not clean up all historic inventory data up to the configured daystokeep value.
The SQL database has been growing on inventory information and it is desired to remove inventory and software usage tracking history.
The ZCM SQL database schema includes a function called zcm_purgehistory to remove historic inventory information as outlined in ZCM online documentation under Cleaning Up Historical Data from the Inventory (scroll down to '2.4.3 Cleaning Up Historical Data from the Inventory').
The script does not clean up all historic inventory data up to the configured daystokeep value.
Resolution
This is fixed in version 11.2.3a - see KB 7011295 "ZENworks Configuration Management 11.2.3a - update information and list of fixes" which can be found at https://support.microfocus.com/kb/doc.php?id=7011295
Cause
It was possible that items in the NC_COMPONENT or NC_PRODUCT failed to delete because they were still referenced by child tables.
Additional Information
Novell Engineering revised the way inventory history is cleaned up. Now it is ensured the referencing entries in child tables get removed first before entries in NC_COMPONENT and NC_PRODUCT tables get deleted.