About orphaned files and tables
The unica_acclean utility uses the criteria described in this section to determine whether files and tables are orphaned.
Tables
The utility scans databases in the current partition to obtain the list of temporary tables. Tables are identified as "temporary" based on the "TempTablePrefix" properties specified for each data source on the Unica Platform Configuration page.
Once the list of temporary tables is compiled, all flowchart files in the system are scanned to see if any of these temporary tables are used by a flowchart. Any temporary table not referenced by a flowchart is considered orphaned.
Files
The utility scans two locations to identify temporary files:
- the partition's temp directory (<partition home>/<partition>/tmp) to obtain the list of files identified as "temporary" files based on the .t~# extension.
- the <partition home>/<partition>/[campaigns | sessions] directory for files having a known Unica Campaign temp file extension.
Once the list of temporary files is compiled, all flowchart files in the system are scanned to see if any of these temporary files are not used by any flowchart. Any temporary file not referenced by a flowchart is considered orphaned.