cleanup_recovery_table

Locates and removes all recipe objects resulting from time-out sessions and client crashes. (Teamcenter recipe objects are used to facilitate transparent recovery when a TcServer instance crashes.) Typically, recipe objects are deleted when users log off. But during client crashes or session time-outs, recipe objects may remain in the database if the session or objects are not recovered. Run this utility periodically to clear the database of recipe objects. Syntax cleanup_recovery_table -u=user-id {-p=password | -pf=password-file} [-g=group] [-age=number-of-days] [-report=output-file] [-verbose] [-dryrun] [-h] Arguments -u Specifies the user ID. This is a user with Teamcenter administration privileges. Note If Security Services single sign-on (SSO) is enabled for your server, the user and password arguments are authenticated externally through SSO rather than being authenticated against the Teamcenter database. If you do not supply these arguments, the utility attempts to join an existing SSO session. If no session is found, you are prompted to enter a user ID and password. -p Specifies the user's password. This argument is mutually exclusive with the -pf argument. -pf Specifies the password file. For more information about managing password files, see Manage password files. 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. -age Specifies the age (in days) recipe objects must reach to be eligible for deletion. Recipe objects older than the specified age are deleted when the utility is run. By default, the age is processed as 30 if you do not specify a value for this argument. -report Specifies the name of the output report file to which a summary of deleted recipe objects are logged. The summary states how many recipe objects were deleted, from how many dead sessions. Accepts the relative or full path and file name. -verbose Logs a complete list of all deleted recipe objects (as opposed to a summary) to the file specified by the -report argument. If the -report argument is not specified, the report is output to the console. -dryrun Generates a report stating how many recipe objects exist in the database for how many dead sessions. No recipe objects are deleted. Siemens Digital Industries Software recommends running this argument first, before actually deleting recipe objects from the database. If this argument is run with the -age argument, the report states how many recipe objects of the specified age exist in the database, relative to the total number of recipe objects. If the -report argument is not specified, the report is output to the console. -h Displays help for this utility. Environment As specified in Setting up a Teamcenter command-line environment. Files As specified in Log files produced by Teamcenter. Restrictions None. Examples To delete all recipe objects older than 30 days and write a summarized report of the deleted objects to the deletedrecipes.txt file, enter the following command on a single line: cleanup_recovery_table -age=30 -report=deletedrecipes.txt To delete all recipe objects older than 10 days and write a full report of all deleted objects to the deletedrecipes.txt file, enter the following command on a single line: cleanup_recovery_table -age=10 -report=deletedrecipes.txt -verbose To test the removal of all recipe objects older than 30 days and write a summarized report of the deleted objects to the deletedrecipes.txt file, enter the following command on a single line: cleanup_recovery_table -age=30 -report=deletedrecipes.txt -dryrun