Configurable Db2 log trimmer

Db2 log trimmer tool provides a mechanism to trim the informative logs that are generated by scanning a data source. It uses the Harvester CLI to ingest data into the IBM Data Cataloging.

Configurable Db2 log trimmer tool helps to better handle the filesystem usage by deleting informative files placed in the Db2 PVC.

From IBM Fusion 2.8.x release, the capabilities of the Db2 log trimmer are extended by a ConfigMap that gives an option of setting the currency for running the trimmer (in minutes). It selects and deletes the old files and .BAD extension files.
Important:
  • The Db2 .BAD files are log files that are generated by failed transactions in Db2 when trying to ingest data.
  • If there is failure at the Db2 level that requires the guidance of a Db2 expert, those .BAD files can be indispensable to perform the root cause analysis and it is recommended NOT TO DELETE those files unless needed.
The fields in the ConfigMap are the following:
  • time-limit-min - default value is "720" (files with more than 720 minutes of last modification)
  • bad-file-erase - default value is "0" (not to delete the .BAD files)
  • frequency-min - default value is "720" (run the log trimmer each 720 minutes)
You can edit the values of the ConfigMap by using the following command.
oc edit configmap db2-log-trimmer -n ibm-data-cataloging