Home
Running utilities
HCL Z Asset Optimizer provides utilities that you run to perform routine functional tasks to maintain the product lifecycle.
Deleting obsolete IQ audit records with the MDEL Deletion utility
Use the MDEL Deletion utiity to delete obsolete IQ audit records. During IQ Import, IQ audit records are collected. Over time, these obsolete records need to be deleted if they are no longer referenced.

Running utilities
HCL Z Asset Optimizer provides utilities that you run to perform routine functional tasks to maintain the product lifecycle.
- Condensing usage data with the ZCAT utility
  The ZCAT utility concatenates and condenses Usage Monitor data sets and generates a file that is then processed by the Usage Import program. When you condense the data produced by the Usage Monitor program, you can save storage space and improve the performance of the Usage Import program.
- Deleting usage data with the Usage Deletion utility
  Use the Usage Deletion utility to delete detailed, summarized, and aggregated usage data for a specified period for all systems in the repository. Each time you run the utility, usage data is aggregated to update the asset tables.
- Deleting a specific system with the System Deletion utility
  Use the System Deletion utility to delete discovery, usage, and hardware data for a specified system.
- Deleting obsolete data with the Physical Deletion utility
  Use the Physical Deletion utility to delete obsolete data that are no longer required.
- Deleting obsolete IQ audit records with the MDEL Deletion utility
  Use the MDEL Deletion utiity to delete obsolete IQ audit records. During IQ Import, IQ audit records are collected. Over time, these obsolete records need to be deleted if they are no longer referenced.
- High-level qualifier listing
  HCL Z Asset Optimizer collects large amounts of usage data. The High-level Qualifier Listing for the Usage Monitor utility creates a list of high-level qualifiers for the products that are to be identified.
- Updating the TPARAM table
  The TPARAM table in the repository can be set to an inconsistent state due to failures in jobs that update the repository tables. You can reset a parameter in the TPARAM table to rectify this inconsistent state.
- Tagging unidentified products with the Product Tagging utility
  The Product tagging utility allows you to create local entries for your in-house software in the Local Knowledge Database. It is not intended for creating IBM or ISV software, as this may cause unpredictable results. If you need to add products or versions that are not being identified, then notify HCL Support, so that they can then update the GKB. On certain occasions, HCL Support may consider your request to add HCL or ISV software to the LKB database, but contact them first before doing so.
- Importing subcapacity reporting data with the SCRT Import utility
  The SCRT Import utility imports data (CSV files) which are generated from the IBM Subcapacity Reporting Tool. The import tool now also supports the importing of Tailored Fit Pricing (TFP) data. New reports to show TFP data are available in the Analyzer under the Asset tab.
- Filtering out non-IBM® programs from the Inquisitor and Usage data utility
  You can run the IBM Filter utility to filter out non-IBM® programs. The output file generated from this utility can be sent to HCL support for diagnosis.
- Extracting data with the XML Export utility
  The XML Export utility extracts information in XML format that you can then import into IBM Control Desk (ICD).
- Compressing and decompressing data sets with the HZAZIP utility
  HZAZIP is a utility program that can compress a sequential or partitioned data set into a zip archive, decompress the contents of a zip archive into a sequential or partitioned data set, and report on the contents of a zip archive.
- Browsing zipped data
  Components such as the Inquisitor programs, the Usage Monitor, and the ZCAT utility deal with sequential data sets containing zip archives. Processing the data with a zip algorithm allows the same information to be conveyed in a fraction of the original size, but it does mean that browsing the file to quickly confirm the nature of its content becomes a more involved process.
- Browsing active collection data
  The Usage Monitor collects program usage information and writes out the collected data at least once each day. Once the data is in a data set, it is possible to browse it to determine if some expected usage was collected or not. Sometimes it would be advantageous to be able to determine if expected data collection has taken place without waiting for the collection cycle to end, either at the expected time or because it was triggered manually to facilitate data access.
- Verifying database changes since the product was released
  This utility verifies database changes that were introduced after the product was released.

Deleting obsolete IQ audit records with the MDEL Deletion utility

Use the MDEL Deletion utiity to delete obsolete IQ audit records. During IQ Import, IQ audit records are collected. Over time, these obsolete records need to be deleted if they are no longer referenced.

Running the MDEL Deletion Utility

To run the MDEL Deletion, use the job HZASMDEL, in the JCLLIB. This job is generated from the HZASCUST post-installation customization job.

TPARAM parameters

DSN=: Db2® location. Value assigned, as defined in job HZASCUST.
REPSCHEMA=: Repository qualifier. Name of qualifier is &REPZSCHM.
RETENTION=: Default is 24. Number of months prior to the current month for which IQ audit records are kept.
SID=: Default is ALLSIDS. System Identifier of system to be deleted.