Table of Contents

Search

  1. Preface
  2. Command Line Programs and Utilities
  3. Installing and Configuring Command Line Utilities
  4. Using the Command Line Programs
  5. Environment Variables for Command Line Programs
  6. Using infacmd
  7. infacmd as Command Reference
  8. infacmd aud Command Reference
  9. infacmd autotune Command Reference
  10. Infacmd bg Command Reference
  11. infacmd ccps Command Reference
  12. infacmd cluster Command Reference
  13. infacmd cms Command Reference
  14. infacmd dis Command Reference
  15. infacmd dps Command Reference
  16. infacmd edl Command Reference
  17. Infacmd es Command Reference
  18. infacmd ihs Command Reference
  19. infacmd ipc Command Reference
  20. infacmd isp Command Reference
  21. infacmd ldm Command Reference
  22. infacmd mas Command Reference
  23. infacmd mi Command Reference
  24. infacmd mrs Command Reference
  25. infacmd ms Command Reference
  26. infacmd oie Command Reference
  27. infacmd ps Command Reference
  28. infacmd pwx Command Reference
  29. infacmd roh Command Reference
  30. infacmd rms Command Reference
  31. infacmd rtm Command Reference
  32. infacmd sch Command Reference
  33. infacmd search Command Reference
  34. infacmd sql Command Reference
  35. infacmd tdm Command Reference
  36. infacmd tools Command Reference
  37. infacmd wfs Command Reference
  38. infacmd ws Command Reference
  39. infacmd xrf Command Reference
  40. infacmd Control Files
  41. infasetup Command Reference
  42. pmcmd Command Reference
  43. pmrep Command Reference
  44. Working with pmrep Files

Integration Service Options

Integration Service Options

Enter Integration Service options in the following format:
infacmd CreateIntegrationService ... -so option_name=value option_name=value ...
To enter multiple options, separate them with a space. To enter a value that contains a space or other non-alphanumeric character, enclose the value in quotation marks.
The following table describes Integration Service options:
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:
  • ASCII
  • Unicode
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 2592000. Default is 0 (retry the target write immediately).
ErrorSeverityLevel
Optional. Minimum level of error logging for the Integration Service logs:
  • Fatal
  • Error
  • Warning
  • Info
  • Trace
  • Debug
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:
  • Auto. Flushes recovery data for all real-time sessions with a JMS or WebSphere MQ source and a non-relational target.
  • Yes. Flushes recovery data for all sessions.
  • No. Does not flush recovery data. Select this option if you have highly available external systems or if you need to optimize performance.
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. Minimum value is 0. Maximum value is 2592000. 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:
  • Normal
  • Safe
Default is Normal.
OperatingModeOnFailover
Optional. Operating mode for the Integration Service when the service process fails over:
  • Normal
  • Safe
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:
  • None. Integration Service does not store any session or workflow run-time information in the repository.
  • Normal. Integration Service stores workflow details, task details, session statistics, and source and target statistics in the repository.
  • Verbose. Integration Service stores workflow details, task details, session statistics, source and target statistics, partition details, and performance details in the repository.
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. Minimum value is 0. Maximum value is 2592000. 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:
  • Null
  • Low
  • High
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 when the following conditions are true:
  • The PowerCenter Integration Service has written data to the target.
  • The PowerCenter Integration Service has not issued a commit.
The PowerCenter Integration Service may commit to the target before or after the configured commit interval.
Minimum value is 60. Maximum value is 2592000. Default is 60.
XMLWarnDupRows
Optional. Writes duplicate row warnings and duplicate rows for XML targets to the session log. Default is Yes.


Updated August 15, 2019