7.11 Managing Truncate Manager

The data management subsystem calls the run_truncate_manager.sh script to truncate tables that require complete replacement of their data.

Logs

The log.category.TRUNCATE_MANAGER.location property in the <OFSAAI Installed Directory>/database/db_tools/mantas_cfg/categories.cfg file controls logging for this utility. The system writes log information for this process to the following location: <OFSAAI Installed Directory>/database/db_tools/logs/truncate_manager.log

Using the Truncate Manager

For the run_truncate_manager.sh script to take the table name as an argument, the table must exist in the BD ATOMIC schema. The script logs into the database using the user that the truncate.database.username property specifies in the <OFSAAI Installed Directory>/database/db_tools/mantas_cfg/install.cfg file.

The script has the following calling signature: run_truncate_manager.sh <table_name>

Note:

This process is not intended to be called independently; only the Ingestion Manager subsystem should use it.