Command Line Purge Examples

Note: The password or encrypted password is required when 
com.tibco.mdm.clipassword.enable
property is set to true in the ConfigValues.xml
Purge History Older than 100 Days for All Enterprises
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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" .
Purge an Event ID
Specify in Command Line Expected Output 
  • 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.
Clean up Record Versions for a Repository
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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.
Purge all Records for a Repository with Start Date and End Date
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • datacleanup.bat -o repository -a 69390 -rn ALL -m 20101
 Purges all records of all repositories and enterprise ID 69390 and member ID 20101.
Purge a Record with a Key
Specify in Command Line Expected Output 
  • 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
Clean up Metadata for a Repository within an Enterprise
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • 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
Specify in Command Line Expected Output 
  • datacleanup.bat -o metadata -an ALL -dsn ALL -m = tadmin user id
 Cleans metadata for all datasource for all enterprises and tadmin user ID.