RE: How do I automate the cleanup of the residual tform tables created by Diyotta?

How do I automate the cleanup of the residual tform tables created by Diyotta?

Pshah Beginner Asked on July 15, 2019 in Tools & Utilities.
Add Comment
1 Answers

Unless you are debugging an issue, it is recommended that, in your data flows and job flows to have the “TFORM Cleanup option” to “YES” (this is the default). This ensures the tables, stage files created by Diyotta are cleaned up on successful execution of the flows. In case where there are many tables, stage files that remain in the database and server, use the CLI command “dicmd cleanup” to perform cleanup of these objects.

If you have scheduler license, schedule this as a command task and run it at desired interval. An example command is provided below.

dicmd cleanup -c tform -p DEV_PROJECT -n 7

The command help can be seen by typing “dicmd” from the controller/agent nodes.

RE: How do I automate the cleanup of the residual tform tables created by Diyotta?

Expert Answered on July 15, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.