index_verifier

Detects missing indexes in a Teamcenter database and describes how to create the indexes. This utility ensures that all indexes created at installation or upgrade are in place by consulting the internal Teamcenter pom_indices data dictionary. The index_verifier utility examines each Teamcenter object class and checks for missing indexes. If it finds missing indexes, it reports them in the output file. Use the index_verifier utility with the -o=DO_IT argument to find the missing indexes and create the replacement indexes in one step, for example: Copy index_verifier -u=username -p=password -g=group -o=DO_IT There are five types of indexes that can be detected using this utility: Indexes on the primary key of each Teamcenter class. The PUID (internal attribute of each table mapped to a Teamcenter class) must have a unique index. Indexes on variable length arrays (VLA). Each VLA must have two indexes, as follows: An index on the PUID+PSEQ. This index must be unique. An index on the PVAL attribute (pvalu_0 for POM_typed/untyped_reference and pval_0 for the other data type). Indexes created by Teamcenter. These indexes are created using Teamcenter POM ITK and information about these indexes resides in the POM data dictionary pom_indexes table. Functional indexes This utility detects the necessary functional indexes required by the version of Teamcenter in use. These functional indexes may include, but are not limited to the following: A functional index on WorkspaceObject.object type A functional index on WorkspaceObject.object_desc A functional index on WorkspaceObject.object_name A functional index on Item.Item_id A functional index on ItemRevision.Item_revision_id Indexes on system tables such as pom_backpointer, pom_m_lock, and the pm_process_list tables. Syntax index_verifier [-u=user-id {-p=password | -pf=password-file} -g=group] [-o= [DRYRUN|DO_IT]] [-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 -u and -p 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 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 group associated with the user. If used without a value, the user's default group is assumed. -o Specifies the action to take with the output of the index_verifier utility. The -o argument has the following parameters. -o DRYRUN Specifies to identify missing indexes but not create the missing indexes in the database. This is the same behavior as not using the -o argument. -o DO_IT Specifies to identify missing indexes and immediately create missing indexes in the database. For Oracle, if the SA user who runs index_verifier wants missing indexes to be created in a specific tablespace, the SA user must set the TC_INDEX_STORAGE environment variable: Copy TC_INDEX_STORAGE TABLESPACE tablespace-name -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 This utility can be run while users are logged on to Teamcenter. Related Topics Introduction to administering volumes