Shared Content for Data Engineering All Products
CreateRepositoryService <-DomainName|-dn> domain_name <-UserName|-un> user_name <-Password|-pd> password [<-SecurityDomain|-sdn> security_domain] [<-Gateway|-hp> gateway_host1:port gateway_host2:port...] [<-ResilienceTimeout|-re> timeout_period_in_seconds] <-ServiceName|-sn> service_name <-NodeName|-nn> node_name [<-BackupNodes|-bn> node1 node2 ...] [<-ServiceDisable|-sd>] <-ServiceOptions|-so> option_name=value ... [<-LicenseName|-ln> license_name] [<-FolderPath|-fp> full_folder_path]
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.
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.
|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.|
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.
gateway_host1:port gateway_host2:port ...
Required if the gateway connectivity information in the domains.infa file is out of date. The host names and port numbers for the gateway nodes in the domain.
Optional. Amount of time in seconds that infacmd attempts to establish or re-establish a connection to the domain. If you omit this option, infacmd uses the timeout value specified in the INFA_CLIENT_RESILIENCE_TIMEOUT environment variable. If no value is specified in the environment variable, the default of 180 seconds is used.
Required. Name of the PowerCenter Repository 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 have leading or trailing spaces, include carriage returns or tabs, exceed 79 characters, or contain the following characters:
\ / : * ? < > " |
Required. Name of the node where you want the PowerCenter Repository Service process to run. If the PowerCenter environment is configured for high availability, this option specifies the name of the primary node.
node1 node2 ...
Optional. Nodes on which the service can run if the primary node is unavailable. You can configure backup nodes if you have high availability.
Optional. Creates a disabled service. You must enable the service before you can run it.
Required. Service properties that define how the PowerCenter Repository Service runs.
Required if you create an enabled service. Name of the license you want to assign to the PowerCenter Repository Service.
Optional. Full path, excluding the domain name, to the folder in which you want to create the PowerCenter Repository Service. Must be in the following format:
Default is “/” (the domain).
infacmd CreateRepositoryService ... -so option_name=value option_name=value ...
Optional. Uses PowerCenter Client tools to modify metadata in the repository when repagent caching is enabled. Default is Yes.
Optional. Requires users to add comments when checking in repository objects. Default is Yes. To apply changes, restart the PowerCenter Repository Service.
Required. Code page description for the database. To enter a code page description that contains a space or other non-alphanumeric character, enclose the name in quotation marks.
Required. Database connection string specified during PowerCenter Repository Service setup. To apply changes, restart the PowerCenter Repository Service.
Required. Repository database password corresponding to the database user. You can set a password with the -so option or the environment variable INFA_DEFAULT_DATABASE_PASSWORD. If you set a password with both methods, the password set with the -so option takes precedence.
To apply changes, restart the PowerCenter Repository Service.
Optional. The minimum number of idle database connections allowed by the PowerCenter Repository Service. For example, if there are 20 idle connections, and you set this threshold to 5, the PowerCenter Repository Service closes no more than 15 connections. Minimum is 3. Default is 5.
Optional. The interval, in seconds, at which the PowerCenter Repository Service checks for idle database connections. If a connection is idle for a period of time greater than this value, the PowerCenter Repository Service can close the connection. Minimum is 300. Maximum is 2,592,000 (30 days). Default is 3,600 (1 hour).
Required. Account for the database containing the repository. To apply changes, restart the PowerCenter Repository Service.
Optional. Number of rows to fetch each time an array database operation is issued, such as insert or fetch. Default is 100. To apply changes, restart the PowerCenter Repository Service.
Optional. Amount of time in seconds that the PowerCenter Repository Service attempts to establish a connection to the database management system. Default is 180.
Optional. Maximum number of connections to the repository database that the PowerCenter Repository Service can establish. Minimum is 20. Default is 500.
Required. Type of database that stores the repository metadata. To apply changes, restart the PowerCenter Repository Service.
Optional. Enables the repository agent caching feature. Default is Yes.
Optional. Minimum level of error messages written to the PowerCenter Repository Service log:
Default is Info.
Optional. Interval at which the PowerCenter Repository Service verifies its connections with clients of the service. Default is 60 seconds.
Optional. Maximum amount of time in seconds that the service holds on to resources for resilience purposes. Default is 180.
Optional. Maximum number of connections the repository accepts from repository clients. Default is 200.
Optional. Maximum number of locks the repository places on metadata objects. Default is 50,000.
Optional. Mode in which the PowerCenter Repository Service is running:
Default is Normal. To apply changes, restart the PowerCenter Repository Service.
|OptimizeDatabaseSchema||Optional. Optimizes the repository database schema when you create repository contents or back up and restore an IBM DB2 or Microsoft SQL Server repository. When enabled, the PowerCenter Repository Service tries to create repository tables that contain Varchar columns with a precision of 2000 instead of CLOB columns. Use Varchar columns to increase repository performance. When you use Varchar columns, you reduce disk input and output, and the database can cache the columns.
To use this option, verify the page size requirements for the following repository databases:
Default is disabled.
Optional. Preserves MX data for prior versions of mappings. Default is disabled.
Optional. Number of objects that the cache can contain when repository agent caching is enabled. Default is 10,000.
Optional. Tracks changes made to users, groups, privileges, and permissions. Default is No.
Optional. Amount of time in seconds that the service tries to establish or reestablish a connection to another service. Default is 180. To apply changes, restart the PowerCenter Repository Service.
Optional. Name of the owner of the repository tables for an IBM DB2 repository.
Optional. Tablespace name for IBM DB2 repositories. To apply changes, restart the PowerCenter Repository Service.
Optional. Uses Windows authentication to access the Microsoft SQL Server database. Default is No. To apply changes, restart the PowerCenter Repository Service.