Command Line Purge Examples

Note: The password or encrypted password is required when the com.tibco.mdm.clipassword.enable property is set to true in the Configurator.
Example Name Specify in Command Line Expected Output
Purge History
Purge History Older than 100 Days for All Enterprises
datacleanup.bat -o history -an ALL -d 100 -m = IDofSuperuser
Purge history older than 100 days for all enterprises.
Purge History Older than 100 Days for an Enterprise ID 239382
datacleanup.bat -o history -a 239382 -d 100 -m 20101
Purge history older than 100 days for an enterprise ID 239382.
Purge History Older than 100 Days for a Specific Enterprise
datacleanup.bat -o history -an MYENTP1 -d 100 -m 20101
Purge history older than 100 days, for enterprise = MYENTP1 and member ID=20101
Purge History Older than 100 Days and In-progress Event for All Enterprises
datacleanup.bat -o historyForce -an ALL -d 100 -m IDofSuperuser
Purge history older than 100 days, including the inprogress events for all the enterprises using an ID of the superuser, that is, tadmin.
Purge History for a Repository with start date and end date
datacleanup.bat -o history -a 35320 -sd "2016-01-14 00:00:00" -ed "2016-01-17 00:00:00" -m 35623 -pwd k
Purge history for an enterprise "35320" with start date "2016-01-14" and end date "2016-01-17" .
Record Versions
Clean up Record Versions for a Repository
datacleanup.bat -o recordversions -r 68990 -d 90 -v 3 -m 20101
Cleans all record versions for a repository ID 68990 and member ID 20101 with cut off date as 90 days and at least 3 versions prior to cut off date.
Clean up Record Versions for a Repository within an Enterprise
datacleanup.bat -o recordversions -rn MYREPO -a 68990 -d 90 -v 3 -m 20101
Cleans all record versions for a repository= MYREPO and enterprise ID 68990 and member ID 20101 with cut off date as 90 days and at least 3 versions prior to cut off date.
Clean up Record Versions for All Repositories within an Enterprise
datacleanup.bat -o recordversions -a 68990 -rn ALL -d 90 -v 3 -m 20101
Cleans record versions for all repositories in an enterprise ID 68990 and member ID 20101 with cut off date as 90 days and at least 3 versions prior to cut off date.
Clean up Record Versions for All Repositories within All Enterprises
datacleanup.bat -o recordversions -an ALL -rn ALL -d 90 -v 3 -m = tadmin user id.
Cleans record versions for all repositories in all enterprise for using tadmin user ID with cut off date as 90 days and at least 3 versions prior to cut off date.
All Records
Purge all Records for a Repository with Start Date and End Date
datacleanup.bat -o recordversions -r 36000 -sd "2016-01-14 00:00:00" -ed "2016-01-17 00:00:00" -v 3 -m 35623 -pwd k
Purge record versions for repository ID "36000" with start date "2016-01-14" and end date "2016-01-17" for member ID "35623" and at least three versions prior to end date.
Purge All Records of a Repository
datacleanup.bat -o repository -r 29390 -m 20101
Purges all records of a repository ID 29390 and member ID 20101.
Purge All Records for a Repository with an Enterprise ID
datacleanup.bat -o repository -rn MYREPO -a 68990 -m 20101
Purges all records of a repository =MYREPO and enterprise ID 68990 and member ID 20101.
Purge All Records for a Repository within an Enterprise
datacleanup.bat -o repository -rn MYREPO -an MYENTP1 -m 20101
Purges all records of a repository =MYREPO and enterprise = MYENTP1 and member ID 20101.
Purge All Records for All Repositories of an Enterprise
datacleanup.bat -o repository -a 69390 -rn ALL -m 20101
Purges all records of all repositories and enterprise ID 69390 and member ID 20101.
Clean up Metadata
Clean up Metadata for a Repository within an Enterprise
datacleanup.bat -o metadata -a 68990 -rn MYREPO -m 20101
Cleans metadata for a repository = MYREPO and enterprise ID 68990 and member ID 20101.
Clean up Metadata for a Repository within an Enterprise
datacleanup.bat -o metadata -an MYENTP1 -rn MYREPO -m 20101 
Cleans metadata for a repository = MYREPO and enterprise = MYENTP1 and member ID 20101.
Clean up Metadata for All Repositories within an Enterprise
datacleanup.bat -o metadata -a 68990 -rn ALL -m 20101
Cleans metadata for all repositories ID 68990 and member ID 20101.
Clean up Metadata Version for a Repository
datacleanup.bat -o metadataversions -r 68990 -m 20101
Cleans metadata versions for a repository ID 68990 and member is 20101.
Clean up Metadata Version for All Repositories within an Enterprise
datacleanup.bat -o metadataversions -a 68990 -rn ALL -m 20101
Cleans metadata versions for all repositories of enterprise ID 68990 and member ID 20101.
Clean up Metadata for a Data Source
datacleanup.bat -o metadata -ds 34291 -a 34326 -m 20101
Cleans metadata for a datasource 34291 for enterprise ID 34326 and member is 20101.
Clean up Metadata for a Data Source for an Enterprise
datacleanup.bat -o metadata -dsn MYDS -an MYENTP1 -m 20101
Cleans metadata for a datasource named MYDS for enterprise = MYENTP1 and member ID 20101.
Clean up Metadata for a Data Source for an Enterprise
datacleanup.bat -o metadata -dsn MYDS -a 68890 -m 20101
Cleans metadata for a datasource named MYDS for enterprise ID 68990 and member ID 20101.
Clean up Metadata for All Data Sources for an Enterprise
datacleanup.bat -o metadata -a 68990 -dsn ALL -m 20101
Cleans metadata for all datasource for enterprise ID 68990 and member ID 20101.
Clean up Metadata for All Data Sources for an Enterprise
datacleanup.bat -o metadata -an MYENTP1 -dsn ALL -m 20101
Cleans metadata for all datasource for enterprise = MYENTP1 and member ID 20101.
Clean up Metadata for All Data Sources for All Enterprises
datacleanup.bat -o metadata -an ALL -dsn ALL -m = tadmin user id
Cleans metadata for all datasource for all enterprises and tadmin user ID.
Multiple Records
Purge Multiple Records with Bulk Mode
datacleanup.bat -o record -r 36000 -uf "../../MyResource/my_test.csv" -m 20101 -b Y -pwd Abcdef1234 
Purges multiple records with repository ID "3600" in the my_text.csv file with member ID "20101". The file path is relative to the user's home.
Purge Multiple Records with Batch Mode
datacleanup.bat -o record -r 36561 -uf "../../MyResource/example.csv" -m 36483 -pwd Admin1234 
Purges multiple records with repository ID "36561" in the example.csv file with member ID "36483". The file path is relative to the user's home.
Deleted Records
Purge All Deleted Records From a Repository
datacleanup.bat -o deletedRecord -an TEST1 -mn admin -rn MYREPO  
Purges all deleted records with the enterprise name TEST1 with member name admin and repository name MYREPO.
Purge 10,000 Deleted Records From a Repository
datacleanup.bat -o deletedRecord -an TEST1 -mn admin -rn MYREPO   -l 10000
Purges 10,000 deleted records with the enterprise name TEST1 with member name admin and repository name MYREPO.
Others
Purge an Event ID
datacleanup.bat -o event -an MYENTP1 -e 38990 -m 20101
Purge an event with an event ID 38990 for enterprise = MYENTP1 and member ID=20101.
Purge a Record with a Key
datacleanup.bat -o record -r 34921 -p 349390 -m 20101
Purges a record for repository ID 34921 with a key ID 349390 and member ID 20101.

When you purge a record with a record key, only the specified record is purged.

  • all the history for the specific record is removed.
  • the relationship between parent and child record is removed.
However, the child record is not removed until you explicitly remove it from the repository.
Note: To purge multiple record IDs in a single command, specify comma separated record IDs. For example,
datacleanup.bat -o record -r 34921 -p 349390,349440,339678 -m 20101
Purge Record Versions for a Repository and Retain Only the Golden Copy Version
datacleanup.bat -o recordversionsGoldenCopy -an TEST1 -mn admin -rn MYREPO
Purges record versions and only retains the Golden Copy version with the enterprise name TEST1 with member name admin and repository name MYREPO.
Incremental Purge
datacleanup.bat -o recordversions -an TEST1 -mn admin -rn MYREPO -d 90 -v 3 -ip Y -n JOBNAME1 
Purges all record versions with Incremental=true for the repository name MYREPO and enterprise name TEST1 and the user admin with cut off date as 90 days and at least 3 versions prior to cut off date and the job name as JOBNAME1.
Purge Policy
datacleanup.bat -o history -an TEST1 -mn admin -pp MEDIUM
Purges history older than 90 days, for enterprise = TEST1 (Purge history PurgePolicy MEDIUM means a 90 day retention).
Purge Enterprise
datacleanup.sh -o enterprise -an ACME -mn tadmin -pwd 'euc!1dAl'

where ACME is the enterprise to be purged and tadmin and euc!1dAl are super user credentials.

Removes all data pertaining to an enterprise. Be careful before deleting the enterprise as this command purges the entire enterprise.
Warning: Only the super user can delete an enterprise. If other user deletes the enterprise, a warning message is displayed: The user does not have a super user role permission. Only the super user can delete an enterprise.