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