clean_backpointer

Removes relation_type object references and ImanRelation primary and secondary object references from the backpointer table. As of 2606, these objects are stored in the ImanRelation table to improve performance. Run this utility after upgrading from a version previous to 2606 if your previous deployment stored relation_type object references and ImanRelation primary and secondary object backpointer references the backpointer table, rather than the ImanRelation table. Before running this utility, ensure that the database is backed up. Running this utility drops any manually created indexes or triggers from the POM_BACKPOINTER table. These indexes and triggers must be manually re-created after running the utility. The utility temporarily creates a copy of the POM_BACKPOINTER table while cleaning up the contents of the table. After the copy is created, the original POM_BACKPOINTER table is deleted and the copy is renamed to POM_BACKPOINTER. Caution Due to renaming of the POM_BACKPOINTER table, when running the clean_backpointer utility in CLEAN mode or DO_IT mode, make sure the system administrator has exclusive use of the system. The default tablespace is used to host this temporary copy of the table if the tablespace argument (-ts) is not used. If the -ts argument is used, the tablespace specified by the argument is used. Whichever option is used, ensure that the tablespace has enough space to support the size table being created. Tip Run the following to find the size needed for the tablespace: Copy WITH cte1 AS ( SELECT table_name FROM user_tables WHERE table_name='POM_BACKPOINTER' UNION ALL SELECT index_name FROM user_indexes WHERE table_name='POM_BACKPOINTER' ), cte2 AS ( SELECT SUM(blocks)*8/1024 MB from dba_extents, cte1 where owner in ( SELECT sys_context( 'userenv', 'current_schema' ) FROM dual ) AND segment_name=cte1.table_name ) SELECT 1.25 *SUM(MB) FROM cte2; If the results of the preceding show that the default tablespace is too small, Siemens Digital Industries Software recommends that you create a new tablespace to hold the modified copy of the POM_BACKPOINTER table. Using the size value obtained from the preceding script, create the new tablespace: Copy CREATE TABLESPACE table-space-name ADD datafile 'location\database-file-name.dbf' size tablespace-sizeG; When you run the utility, specify the new tablespace using the -ts argument. Syntax clean_backpointer -u=admin-user-id {-p=password | -pf=password-file} [-g=dba-group] [-m= INFO | CLEAN | DO_IT] [-ts=tablespace-name] [-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. One of the two mutually exclusive password elements is required. -g Specifies the administrative group associated with the user. If used without a value, the user's default group is assumed. -m Specifies whether to provide information about the backpointer table or delete the specified number of objects. Valid values are: INFO Provides the ImanRelation reference count and a count of -1 cpids. CLEAN Deletes the ImanRelation references and fixes -1 cpids from the backpointer. DO_IT Cleans the POM_BACKPOINTER table without performing the data analysis performed in CLEAN mode. -ts Specifies the tablespace used to create a modified copy of the POM_BACKPOINTER table. This is only for Oracle, and the tablespace must be created beforehand. Ensure that the tablespace is large enough to support the size of the POM_BACKPOINTER table. If the utility is run without the -ts argument, the default tablespace is used. The new table is moved to the location of the original POM_BACKPOINTER table upon successful completion of the utility run after the original POM_BACKPOINTER table has been deleted. -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 determine how many ImanRelation primary and secondary object references exist in your backpointer table, enter the following command on a single line: Copy clean_backpointer -u=Tc-admin-user -p=password -g=group -m=INFO The utility returns the total number of backpointer entries, as well as the number of ImanRelation objects identified for deletion. To delete all ImanRelation primary and secondary object references from your backpointer table, enter the following command on a single line: Copy clean_backpointer -u=Tc-admin-user -p=password -g=group m=CLEAN To rebuild the POM_BACKPOINTER table, enter the following command on a single line: Copy clean_backpointer -u=Tc-admin-user -p=password -g=group m=DO_IT