Campaign cleanup utility options

The unica_acclean utility supports the following options.

Option	Syntax	Description
-d	-d	Deletes temp tables and files. All flowchart files are scanned, and based on the result, temporary files and tables are determined.
-f	-f < log file name >	Specifies the name of the file where errors are logged, located in the < PARTITION_HOME >/logs directory. By default, this file is named unica_acclean.log. You can modify the log file name, but specifying a different location is not currently supported.
-h	-h	Displays usage help. Any invalid command line invocation also displays the help.
-i	-i < clean file name >	Specifies the file listing the items to be deleted. Best practice is to use the same file generated by the cleanup tool, using the -o option.
-l	-l {low | medium | high | all}][-f < logFileName>]	Specifies logging level and the log file name. If no level is specified, medium is used by default.
-n	-n < partition name >	Use this option to supply the name of the partition. If the partition name is not specified, the default of “partition 1” is used.
-o	-o <listfilename>	Outputs the list of tables and files to the specified file, but does not delete them.
-p	-p < password >	Must be used when the -u option is used. The -u and -p options must be used together. Use this option to supply the password for the user specified with the -u option.
-r	-r	This option can be used only with the -w option for either campaignfolder or sessionfolder objects. When a folder is specified for cleanup and the -r option is added, the unica_acclean tool performs the operation for all subdirectories of the specified folder. If only the -w option is used with a folder, unica_acclean performs the operation only on the top level folder.
-s	-s < criteria>	Used with the -w option, defines criteria for cleanup, specified as a SQL query. The SQL LIKE operator can be used to do a search based on wild cards. Any data table column for the specified object can be used as a criterion: When specifying a campaign folder or session folder as the object, criteria are based on columns in the UA_Folder table. When specifying a campaign as the object, criteria are based on columns in the UA_Campaign table. When specifying a flowchart as the object, criteria are based on columns in the UA_Flowchart table. When specifying a session as the object, criteria are based on columns in the UA_Session table.
-u	-u < user name >	Must be used when the -p option is used. The -u and -p options must be used together. Use this option to supply the IBM Unica Marketing user name of the user running the utility.
-v	-v	Displays version and copyright information for the cleanup utility.
-w	-w {flowchart | campaign | session | sessionfolder | campaignfolder | orphan} -s <criteria> [-r]	Searches for temp files and tables associated with the specified object type, based on the specified criteria, except when used with the orphan option. Only when used with orphan, searches for orphaned temp files and tables across the entire system. Requires -s <criteria> for all options except “orphan”. For details, see -s. Optionally use the -r option to recursively search subfolders within folders. For details, see -r.