tcxml_clean_sync_tables

Provides options for optimizing TC XML data in synchronization tables. Syntax tcxml_clean_sync_tables -u=user-name {-p=password | -pf=password-file} [-g=group] {-quiet} {-delete_subscription_table [-app_ids=application-ids]} {-update_subscription_table [-app_id=app_ids] [-lpd=lpd]} {-delete_scratch_table {-null_lsd} {-stale_data} {-classes=class-names} {-truncate}} [-h] Arguments -u Specifies the user ID. This is a user with Teamcenter administration privileges. -p Specifies the user's password. This argument is mutually exclusive with the -pf argument. -pf Specifies the password file. The file must be a single-line ASCII file containing the password in clear text. Teamcenter Environment Manager prompts you for a password and creates the password file during installation. This argument is mutually exclusive with the -p argument. -g Specifies the group associated with the user. If used without a value, the user's default group is assumed. -quiet Runs the utility with no confirmation prompts when deleting or updating the synchronization tables. -delete_subscription_table Removes data from SUBSCRIPTION_TABLE. Used with the -app_ids argument. -app_ids Specifies application IDs to be removed from SUBSCRIPTION_TABLE. Multiple IDs are delimited with commas. Used with the -delete_subscription_table argument. -update_subscription_table Updates the last processed date (lpd) in SUBSCRIPTION_TABLE for the ID specified by -app_id. Used with the -app_id and -lpd arguments. -app_id Specifies the ID of the lpd in SUBSCRIPTION_TABLE to be updated by -update_subscription_table. -lpd Specifies the value -update_subscription_table uses to update the last processed date in SUBSCRIPTION_TABLE. The value has the format "DD-MMM-YYYY HH:MM:SS"" (double quotes included). DD specifies the day (01-31) MMM specifies the month (jan-dec). Letter case is not significant. YYYY specifies the year (0001-9999) HH specifies the hour (00-23) MM specifies the minute (00-59) SS specifies the second (00-59) -delete_subscription_table Removes data from SCRATCH_TABLE. Used with the -null_lsd, -stale_data, -classes, and -truncate arguments. -null_lsd Removes the NULL lsd records from SCRATCH_TABLE. Used with the -delete_subscription_table argument. -stale_data Removes already-synchronized data from SCRATCH_TABLE. Used with the -delete_subscription_table argument. -classes Specifies the names of data classes to remove from SCRATCH_TABLE. Multiple class names are delimited with commas. Used with the -delete_subscription_table argument. -truncate Removes all data from (truncates) SCRATCH_TABLE. Used with the -delete_subscription_table argument. -h Displays help for this utility. Environment As specified in Setting up a Teamcenter command-line environment. Files As specified in the Log files produced by TeamcenterLog files produced by Teamcenter. Restrictions None. Examples Removes two application IDs from SUBSCRIPTION_TABLE: Copy tcxml_clean_synch_tables -u=Tc-admin-user -p=password -g=group -delete_subscription_table -apps=app01,app_02 Updates the last processed date for a specific application ID in SUBSCRIPTION_TABLE: Copy tcxml_clean_synch_tables -u=Tc-admin-user -p=password -g=group -update_subscription_table -app_id=app01 -lpd="31-Aug-2018 13:20:00" Removes NULL LSD data from SCRATCH_TABLE: Copy tcxml_clean_synch_tables -u=Tc-admin-user -p=password -g=group -delete_scratch_table -null_lsd Removes a list of data classes from SCRATCH_TABLE: Copy tcxml_clean_synch_tables -u=Tc-admin-user -p=password -g=group -quiet -delete_scratch_table -classes=class01,class02,class03 Removes all the data from SCRATCH_TABLE: Copy tcxml_clean_synch_tables -u=Tc-admin-user -p=password -g=group -delete_scratch_table -truncate Related Topics TC XML and PLM XML Configuration for Data Import and Export Multi-Site Collaboration