database_verify

Compares database schema, Teamcenter types, tools, release statuses, and units of measure between two specified Multi-Site Collaboration sites and generates a report of any database discrepancies. You can use this utility to query types and classes from a specified remote site and create a local dataset named TCTYPES_SITEsiteid containing those mappings. There is one dataset for each remote site defined with the -site argument. You can also create and update the local dataset of remote class and types mappings for a specified remote site. Run this utility whenever there are changes for the POM transmit file of a specified site. Syntax database_verify [-u=user-id {-p=password | -pf=password-file} -g=group] -from=site-name1 -to=site-name2 [-schema] [-type] [-tool] [-status] [-uom] [-all] [-output=file-name] [-site=site-name] -force -offline [-filename=file-name] [-v] [-h] Arguments -u Specifies the user ID. This is a user with Teamcenter administration privileges. 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. -g Specifies the group associated with the user. If used without a value, the user's default group is assumed. -from Specifies a Teamcenter database site to be verified. -to Specifies a Teamcenter database site to be verified. -output Specifies the output format. The report is output to a file if a file name is specified. If not, the report is displayed in a shell. -schema Compares schema between the two sites. -type Compares types between the two sites. -tool Compares tools between the two sites. -status Compares release status types between the two sites. -uom Compares units of measure between the two sites. -notetype Compares note types. -all Compares classes, types, tools, status types and units of measures between the two sites. This is the default if no argument is supplied. -site Specifies the site name where types and classes would be persisted locally. If the value of this argument is set to ALL, the utility generates these datasets for all sites in the database. -force Generates the type-class mappings file even when the POM transmit files for the remote and local sites have not changed. -offline Specifies the site identified with the -site argument is offline. If you specify this argument, you must also specify the -filename argument. -filename Specifies the file name generated by this utility from the -site argument. This argument is required if the -offline argument is specified. -v Runs utility in verbose mode. Displays maximum amount of information. Typically, nonverbose utility sessions only display error messages. -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 Teamcenter. Restrictions To use this utility, you must be a user with system administration privileges or be granted authorization by a user with system administration privileges. The -from and -to arguments must be specified. Related Topics TC XML and PLM XML Configuration for Data Import and Export Multi-Site Collaboration