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. |
-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 user realm specified during installation. |
-Gateway -hp | 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. |
-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. 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. |
-ServiceName -sn | service_name | Required. Name of the PowerCenter Integration 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: / * ? < > " | |
-FolderPath -fp | full_folder_path | Optional. Full path, excluding the domain name, to the folder in which you want to create the Integration Service. Must be in the following format: /parent_folder/child_folder Default is “/” (the domain). |
-NodeName -nn | node_name | Required if you do not specify the grid name. Name of the node where you want the PowerCenter Integration Service process to run. If the PowerCenter environment is configured for high availability, this option specifies the name of the primary node. To apply changes, restart the Integration Service. |
-GridName -gn | grid_name | Required if you do not specify the node name. Name of the grid where you want the PowerCenter Integration Service process to run. To apply changes, restart the PowerCenter Integration Service. |
-BackupNodes -bn | 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. |
-RepositoryService -rs | repository_service_name | Required. Name of the PowerCenter Repository Service that the PowerCenter Integration Service depends on. To enter a name that contains a space or other non-alphanumeric character, enclose the name in quotation marks. To apply changes, restart the PowerCenter Integration Service. |
-RepositoryUser -ru | repository_user | Required for native or LDAP authentication. User name used to connect to the PowerCenter repository. To enter a name that contains a space or other non-alphanumeric character, enclose the name in quotation marks. To apply changes, restart the PowerCenter Integration Service. |
-RepositoryPassword -rp | repository_password | Required for native or LDAP authentication. User password. You can set a password with the -rp option or the environment variable INFA_REPOSITORY_PASSWORD. If you set a password with both methods, the password set with the -rp option takes precedence. To apply changes, restart the PowerCenter Integration Service. |
-RepositoryUserSecurityDomain -rsdn | repository_user_security_domain | Required for LDAP. Optional if the domain uses native authentication. Name of the security domain to which the PowerCenter repository user belongs. The security domain name is case sensitive. If you do not specify this option, the command sets the repository user security domain to native. |
-ServiceDisable -sd | - | Optional. Creates a disabled service. You must enable the service before you can run it. |
-ServiceOptions -so | option_name=value | Optional. Service properties that define how the PowerCenter Integration Service runs. |
‑ServiceProcessOptions -po | option_name=value | Optional. Service process properties for the PowerCenter Integration Service. In a grid or multi-node environment, infacmd applies these properties to the primary node, grid, and backup node. |
-EnvironmentVariables -ev | name=value | Optional. Specify environment variables as PowerCenter Integration Service process options. You may want to include additional variables that are unique to your PowerCenter environment. To apply changes, restart the node. |
-LicenseName -ln | license_name | Required if you create an enabled service. Name of the license you want to assign to the PowerCenter Integration Service. To apply changes, restart the PowerCenter Integration Service. |
Option | Description |
|---|---|
$PMFailureEmailUser | Optional. Email address of the user to receive email when a session fails to complete. To enter multiple addresses on Windows, use a distribution list. To enter multiple addresses on UNIX, separate them with a comma. |
$PMSessionErrorThreshold | Optional. Number of non-fatal errors the Integration Service allows before failing the session. Default is 0 (non-fatal errors do not cause the session to stop). |
$PMSessionLogCount | Optional. Number of session logs the Integration Service archives for the session. Minimum value is 0. Default is 0. |
$PMSuccessEmailUser | Optional. Email address of the user to receive email when a session completes successfully. To enter multiple addresses on Windows, use a distribution list. To enter multiple addresses on UNIX, separate them with a comma. |
$PMWorkflowLogCount | Optional. Number of workflow logs the Integration Service archives for the workflow. Minimum value is 0. Default is 0. |
AggregateTreatNullAsZero | Optional. Treats nulls as zero in Aggregator transformations. Default is No. |
AggregateTreatRowAsInsert | Optional. Performs aggregate calculations before flagging records for insert, update, delete, or reject in Update Strategy expressions. Default is No. |
ClientStore | Optional. Enter the value for ClientStore using the following syntax: <path>/<filename> For example: ./Certs/client.keystore |
CreateIndicatorFiles | Optional. Creates indicator files when you run a workflow with a flat file target. Default is No. |
DataMovementMode | Optional. Mode that determines how the Integration Service handles character data:
Default is ASCII. |
DateDisplayFormat | Optional. Date format the Integration Service uses in log entries. Default is DY MON DD HH 24:MI:SS YYYY. |
DateHandling40Compatibility | Optional. Handles dates as in PowerCenter 1.0/PowerMart 4.0. Default is No. |
DeadlockSleep | Optional. Number of seconds before the Integration Service retries writing to a target on database deadlock. Minimum value is 0. Maximum value is 2,147,483,647. Default is 0 (retry the target write immediately). |
ErrorSeverityLevel | Optional. Minimum level of error logging for the Integration Service logs:
Default is Info. |
ExportSessionLogLibName | Optional. Name of an external library file to write session log messages. |
FlushGMDWrite | Required if you enable session recovery. Flushes session recovery data for the recovery file from the operating system buffer to the disk. Specify one of the following levels:
Default is Auto. |
HttpProxyDomain | Optional. Domain for authentication. |
HttpProxyPassword | Required if the proxy server requires authentication. Password for the authenticated user. |
HttpProxyPort | Optional. Port number of the HTTP proxy server. |
HttpProxyServer | Optional. Name of the HTTP proxy server. |
HttpProxyUser | Required if the proxy server requires authentication. Authenticated user name for the HTTP proxy server. |
IgnoreResourceRequirements | Optional. Ignores task resource requirements when distributing tasks across the nodes of a grid. Default is Yes. |
JCEProvider | Optional. JCEProvider class name to support NTLM authentication. For example: com.unix.crypto.provider.UnixJCE. |
JoinerSourceOrder6xCompatibility | Optional. Processes master and detail pipelines sequentially as in PowerCenter versions prior to 7.0. Default is No. |
LoadManagerAllowDebugging | Optional. Allows you to use this Integration Service to run debugger sessions from the Designer. Default is Yes. |
LogsInUTF8 | Optional. Writes all logs using the UTF-8 character set. Default is Yes (Unicode) or No (ASCII). |
MSExchangeProfile | Optional. Microsoft Exchange profile used by the Service Start Account to send post-session email. |
MaxLookupSPDBConnections | Optional. Maximum number of connections to a lookup or stored procedure database when you start a session. Minimum value is 0. Default is 0. |
MaxMSSQLConnections | Optional. Maximum number of connections to a Microsoft SQL Server database when you start a session. Minimum value is 100. Maximum value is 2,147,483,647. Default is 100. |
MaxResilienceTimeout | Optional. Maximum amount of time in seconds that the service holds on to resources for resilience purposes. Default is 180. |
MaxSybaseConnections | Optional. Maximum number of connections to a Sybase database when you start a session. Minimum value is 100. Maximum value is 2,147,483,647. Default is 100. |
NumOfDeadlockRetries | Optional. Number of times the Integration Service retries writing to a target on a database deadlock. Minimum value is 10. Maximum value is 1,000,000,000. Default is 10. |
OperatingMode | Optional. Operating mode for the Integration Service:
Default is Normal. |
OperatingModeOnFailover | Optional. Operating mode for the Integration Service when the service process fails over:
Default is Normal. |
OutputMetaDataForFF | Optional. Writes column headers to flat file targets. Default is No. |
PersistRuntimeStatsToRepo | Optional. Level of run-time information stored in the repository. Specify one of the following levels:
Default is Normal. |
Pmserver3XCompatibility | Optional. Handles Aggregator transformations as the PowerMart Server did in PowerMart 3.5. Default is No. |
RunImpactedSessions | Optional. Runs sessions that are impacted by dependency updates. Default is No. |
ServiceResilienceTimeout | Optional. Amount of time in seconds that the service tries to establish or reestablish a connection to another service. Default is 180. |
StoreHAPersistenceInDB | Optional. Stores process state information in persistence database tables in the associated PowerCenter repository database. Default is no. |
TimestampWorkflowLogMessages | Optional. Appends a timestamp to messages written to the workflow log. Default is No. |
TreatCharAsCharOnRead | Optional. Keeps trailing spaces when reading SAP or PeopleSoft CHAR data. Default is Yes. |
TreatDBPartitionAsPassThrough | Optional. Uses pass-through partitioning for non-DB2 targets when the partition type is Database Partitioning. Default is No. |
TreatNullInComparisonOperatorsAs | Optional. Determines how the Integration Service evaluates null values in comparison operations:
Default is Null. |
TrustStore | Optional. Enter the value for TrustStore using the following syntax: <path>/<filename> For example: ./Certs/trust.keystore |
UseOperatingSystemProfiles | Optional. Enables use of operating system profiles. Use this option if the Integration Service runs on UNIX. |
ValidateDataCodePages | Optional. Enforces data code page compatibility. Default is Yes. |
WriterWaitTimeOut | Optional. In target-based commit mode, the amount of time in seconds the writer remains idle before it issues a commit. Minimum value is 60. Maximum value is 2,147,483,647. Default is 60. |
XMLWarnDupRows | Optional. Writes duplicate row warnings and duplicate rows for XML targets to the session log. Default is Yes. |
Option | Description |
|---|---|
$PMBadFileDir | Optional. Default directory for reject files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/BadFiles. |
$PMCacheDir | Optional. Default directory for index and data cache files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/Cache. |
$PMExtProcDir | Optional. Default directory for external procedures. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/ExtProc. |
$PMLookupFileDir | Optional. Default directory for lookup files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/LkpFiles. |
$PMRootDir | Optional. Root directory accessible by the node. It cannot include the following special characters: * ? < > " | , Default is C:\Informatica\PowerCenter8.6\server\infa_shared. |
$PMSessionLogDir | Optional. Default directory for session logs. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/SessLogs. |
$PMSourceFileDir | Optional. Default directory for source files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/SrcFiles. |
$PMStorageDir | Optional. Default directory for run-time files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/Storage. |
$PMTargetFileDir | Optional. Default directory for target files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/TgtFiles. |
$PMTempDir | Optional. Default directory for temporary files. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/Temp. |
$PMWorkflowLogDir | Optional. Default directory for workflow logs. It cannot include the following special characters: * ? < > " | , Default is $PMRootDir/WorkflowLogs. |
Codepage_ID | Required. Code page ID number for the Integration Service process. |
JVMClassPath | Optional. Java SDK classpath. |
JVMMaxMemory | Optional. Maximum amount of memory the Java SDK uses during a PowerCenter session. Default is 64 MB. |
JVMMinMemory | Optional. Minimum amount of memory the Java SDK uses during a PowerCenter session. Default is 32 MB. |