How do I clean up previous data lineage information and clear out FLOWS* tables that grow too large?
The FLOWS_FLOW, FLOWS_ASSET, FLOWS_CONTAINMENT tables have grown large over time since we use Data Lineage in our IGC environment.
Answer by GH_IIS_Support (1) | Feb 20, 2017 at 07:42 PM
Use IGC's internal utilities: https://::port/iis/igc/secure/utils/utilMenu.jsp
Note, the Utils Menu is not packaged with IGC by default. This URL will only be available after downloading & installing a utils zip file (eg. utils-11.5_1_.zip) The utils zip file must be requested directly from IBM Information Server Support by opening a Support Case.
There are two options under Recovery section: 1. Delete the content of the 'Flows' model entirely 2. Delete and Repopulate the content of the 'Flows' model and fix the old data connections
The first one truncates the FLOWS_* tables, the second truncates and recreates them.