Command Line Purge Examples
com.tibco.mdm.clipassword.enable property is set to
true in the Configurator.
| Example | Specify in Command Line | Expected Output |
|---|---|---|
| Purge History and Event | ||
| Purge History Older than 100 Days for All Enterprises | datacleanup.bat -o history
|
Purge history older than 100 days for all enterprises. |
| Purge History Older than 100 Days for an Enterprise ID 239382 | datacleanup.bat -o history |
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 |
Purge history older than 100 days, for enterprise = MYENTP1 and member ID=20101 |
| Purge history older than 90 days for a specific enterprise | datacleanup.bat -o history
|
Purge history older than 90 days, for enterprise = MYENTP1 and member ID=20101
PurgePolicy
|
| Purge History for a Repository with start date and end date | datacleanup.bat -o history |
Purge history for an enterprise "35320" with start date "2016-01-14" and end date "2016-01-17". |
| Purge History Older than 100 Days and In-progress Event for All Enterprises | datacleanup.bat -o historyForce
|
Purge history older than 100 days, including the inprogress events for all the enterprises using an ID of the superuser, that is, tadmin. |
| Purge Policy | datacleanup.bat -o history
|
Purges history older than 90 days, for enterprise = TEST1 (Purge history PurgePolicy MEDIUM means a 90-day retention). |
| Purge an Event ID | datacleanup.bat -o event
|
Purge an event with an event ID 38990 for enterprise = MYENTP1 and member ID=20101. |
| Record Versions | ||
| Clean up Record Versions for a Repository | datacleanup.bat -o recordversions |
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
|
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
|
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
|
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 | datacleanup.bat -o recordversions |
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 Record Versions for a Repository and Retain Only the Golden Copy Version | datacleanup.bat -o recordversionsGoldenCopy
|
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
|
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.
|
| Time and Record Count Bounded Purge
When both the execution modes are specified, time bounded purge takes precedence. It is best to use one execution mode at a time. |
||
| Cleans up record versions for a specific time duration for all repositories within an enterprise | datacleanup.bat -o recordversions
|
Cleans record versions for an hour with cut off date as 30 days with at least 3 versions prior to cut off date for all repositories in the ACME enterprise for ACME member name. |
| Purges records based on the specific record count for all repositories within an enterprise | datacleanup.bat -o recordversions
|
Cleans one million records with cut off date as 30 days with at least 3 versions prior to cut off date for all repositories in the ACME enterprise for ACME member name. |
| Cleans up golden copy record versions for a specific time duration for all repositories within an enterprise | datacleanup.bat -o recordversionsGoldenCopy
|
Cleans golden copy record versions for one hour for all repositories within ACME enterprise. |
| Purges golden copy records based on the record count specified; purge applies to all repositories within an enterprise | datacleanup.bat -o recordversionsGoldenCopy
|
Cleans one million golden copy records with cut off date as 30 days with at least 3 versions prior to cut off date for all repositories in the ACME enterprise for ACME member name. |
| Cleans up record versions for the specified duration. You can specify the job name for all repositories within an enterprise | datacleanup.bat -o recordversions
|
Cleans record versions for the x111 name for an hour with cut off date as 30 days with at least 3 versions prior to cut off date for all repositories in the ACME enterprise for ACME member name.If the name (
|
| Clean up Repository | ||
| Purge All Records of a Repository | datacleanup.bat -o repository
|
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
|
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
|
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
|
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
|
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
|
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
|
Cleans metadata for all repositories ID 68990 and member ID 20101. |
| Clean up Metadata for a Data Source | datacleanup.bat -o metadata
|
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
|
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
|
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
|
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
|
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
|
Cleans metadata for all datasource for all enterprises and tadmin user ID. |
| Clean up Metadata Versions | ||
| Clean up Metadata Version for a Repository | datacleanup.bat -o metadataversions
|
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
|
Cleans metadata versions for all repositories of enterprise ID 68990 and member ID 20101. |
| Clean up Records | ||
| Purge Multiple Records with Bulk Mode | datacleanup.bat -o record
|
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
|
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. |
| Purge a Record with a Key | datacleanup.bat -o record
|
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.
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 |
| Delete Record Hierarchy | ||
| Purge the entire hierarchy for an enterprise | datacleanup.bat -o record
|
Purges the entire hierarchy for the specified records with the
34948 repository ID and the
10023 record key ID from the
ACME enterprise.
|
| Purge hierarchy from the input file. The file path is relative to the user home. | datacleanup.bat -o record
|
Purges the entire hierarchy for the specified records and the
purge.txt input file from the
|
| Purge hierarchy from the input file. The file path is absolute. | datacleanup.bat -o record
|
|
| Purge hierarchy from the input file, excluding multiple relationships. | datacleanup.bat -o record
|
Purges the entire hierarchy for the specified records and the
purge.txt input file from the
ACME enterprise excluding the
EmployeetoDepartment1 and
EmployeetoDepartment2 relationship names.
The file is placed at a path relative to the user home. |
| Purge hierarchy with the preview mode. | datacleanup.bat -o record
|
Print preview of qualified records in the purge log. Records are not deleted. |
| Purge relationships along with root records | datacleanup.bat -o record
-r 41162 -uf "purge.txt" -
-ic rel1,rel2 -m
36483 -pwd Admin1234 |
Use You can specify relationships for the If |
| Deleted Records | ||
| Purge All Deleted Records From a Repository | datacleanup.bat -o deletedRecord
|
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
|
Purges 10,000 deleted records with the enterprise name TEST1 with member name admin and repository name MYREPO. |
| Others | ||
| Purge Enterprise | datacleanup.sh -o enterprise
where
|
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. |