Purge

Deletes from the reference data warehouse any reference table that is no longer associated with a reference table object in the Model repository.

When you run infacmd cms Purge, the Content Management Service identifies the tables that store data for reference table objects in the associated Model repository. The Content Management Service deletes all other tables from the warehouse and generates a list of the deleted tables. Run infacmd cms Purge on the master Content Management Service for the Model repository.

Note: To prevent accidental data loss, the purge operation does not delete tables if the Model repository does not contain a reference table object.

Before you run infacmd cms Purge, verify the following prerequisites:

•The user name that you specify in the command has the Manage Service privilege on the domain.

•The Model repository user that the Content Management Service specifies has the Administrator role on the Model Repository Service.

•All Data Integration Services associated with the Model repository are available.

•There are no data operations in progress on the reference data warehouse.

•The reference data warehouse stores data for the reference table objects in a single Model repository.

•You updated the search index that the Model Repository Service uses to identify the objects in the Model repository. Update the index to verify that the Model Repository Service uses the current list of reference table objects in the reference data warehouse.

The infacmd cms Purge command uses the following syntax:

The following table describes infacmd cms Purge options and arguments:

Option	Argument	Description
-DomainName -dn	domain_name	Required. Name of the Informatica domain. You can set the domain name with the -dn option or the environment variable INFA_DEFAULT_DOMAIN. If you set a domain name with both methods, the -dn option takes precedence.
-ServiceName -sn	service_name	Required. Name of the Content Management Service. The name is not case sensitive and must be unique within the domain. The characters must be compatible with the code page of the associated repository. The name cannot exceed 128 characters, have leading or trailing spaces, or contain carriage returns, tabs, or the following characters: / * ? < > " \|
-UserName -un	user_name	Required if the domain uses Native or LDAP authentication. User name to connect to the domain. You can set the user name with the -un option or the environment variable INFA_DEFAULT_DOMAIN_USER. If you set a user name with both methods, the -un option takes precedence. Optional if the domain uses Kerberos authentication. To run the command with single sign-on, do not set the user name. If you set the user name, the command runs without single sign-on.
-Password -pd	password	Required if you specify the user name. Password for the user name. The password is case sensitive. You can set a password with the -pd option or the environment variable INFA_DEFAULT_DOMAIN_PASSWORD. If you set a password with both methods, the password set with the -pd option takes precedence.
-SecurityDomain -sdn	security_domain	Required if the domain uses LDAP authentication. Optional if the domain uses native authentication or Kerberos authentication. Name of the security domain to which the domain user belongs. You can set a security domain with the -sdn option or the environment variable INFA_DEFAULT_SECURITY_DOMAIN. If you set a security domain name with both methods, the -sdn option takes precedence. The security domain name is case sensitive. If the domain uses native or LDAP authentication, the default is Native. If the domain uses Kerberos authentication, the default is the LDAP security domain created during installation. The name of the security domain is the same as the user realm specified during installation.
-ResilienceTimeout -re	timeout_period_in_seconds	Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. You can set the resilience timeout period with the -re option or the environment variable INFA_CLIENT_RESILIENCE_TIMEOUT. If you set a the resilience timeout period with both methods, the -re option takes precedence. Default is 180 seconds.

Updating the Model Repository Search Index

Before you run infacmd cms Purge, update the search index that the Model Repository Service uses to identify the objects in the Model repository. Update the index to verify that the Model Repository Service can identify the current reference table objects in the repository.

The amount of time needed to re-index depends on the number of objects in the Model repository. You might want to update the search index at a time when most users are not logged in. During the re-indexing process, design-time objects in the Model repository are read-only.

1. In the Administrator tool, click Manage > Services and Nodes.

2. In the Domain Navigator, select the Model Repository Service.

3. On the Manage tab, click Actions > Search Index > Re-Index.