Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Catalog Service
  4. Content Management Service
  5. Data Integration Service
  6. Data Integration Service Architecture
  7. Data Integration Service Management
  8. Data Integration Service Grid
  9. Data Integration Service Applications
  10. Interactive Data Preparation Service
  11. Enterprise Data Preparation Service
  12. Informatica Cluster Service
  13. Mass Ingestion Service
  14. Metadata Access Service
  15. Metadata Manager Service
  16. Model Repository Service
  17. PowerCenter Integration Service
  18. PowerCenter Integration Service Architecture
  19. High Availability for the PowerCenter Integration Service
  20. PowerCenter Repository Service
  21. PowerCenter Repository Management
  22. PowerExchange Listener Service
  23. PowerExchange Logger Service
  24. SAP BW Service
  25. Search Service
  26. System Services
  27. Test Data Manager Service
  28. Test Data Warehouse Service
  29. Web Services Hub
  30. Application Service Upgrade
  31. Appendix A: Application Service Databases
  32. Appendix B: Connecting to Databases from Windows
  33. Appendix C: Connecting to Databases
  34. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Advanced Properties

Advanced Properties

You can configure the properties that control the behavior of PowerCenter Integration Service security, sessions, and logs. To edit the advanced properties, select the PowerCenter Integration Service in the Navigator, and then click the Properties view. Edit the Advanced Properties section.
The following table describes the advanced properties:
Property
Description
Error Severity Level
Level of error logging for the domain. These messages are written to the Log Manager and log files. Specify one of the following message levels:
  • Error. Writes ERROR code messages to the log.
  • Warning. Writes WARNING and ERROR code messages to the log.
  • Information. Writes INFO, WARNING, and ERROR code messages to the log.
  • Tracing. Writes TRACE, INFO, WARNING, and ERROR code messages to the log.
  • Debug. Writes DEBUG, TRACE, INFO, WARNING, and ERROR code messages to the log.
Default is INFO.
Resilience Timeout
Number of seconds that the service tries to establish or reestablish a connection to another service. If blank, the value is derived from the domain-level settings.
Valid values are between 0 and 2,592,000, inclusive. Default is 180 seconds.
Limit on Resilience Timeouts
Number of seconds that the service holds on to resources for resilience purposes. This property places a restriction on clients that connect to the service. Any resilience timeouts that exceed the limit are cut off at the limit. If blank, the value is derived from the domain-level settings.
Valid values are between 0 and 2,592,000, inclusive. Default is 180 seconds.
Timestamp Workflow Log Messages
Appends a timestamp to messages that are written to the workflow log. Default is No.
Allow Debugging
Allows you to run debugger sessions from the Designer. Default is Yes.
LogsInUTF8
Writes to all logs using the UTF-8 character set.
Disable this option to write to the logs using the PowerCenter Integration Service code page.
This option is available when you configure the PowerCenter Integration Service to run in Unicode mode. When running in Unicode data movement mode, default is Yes. When running in ASCII data movement mode, default is No.
Use Operating System Profiles
Enables the use of operating system profiles. You can select this option if the PowerCenter Integration Service runs on UNIX. To apply changes, restart the PowerCenter Integration Service.
TrustStore
Enter the value for TrustStore using the following syntax:
<path>/<filename
>
For example:
./Certs/trust.keystore
ClientStore
Enter the value for ClientStore using the following syntax:
<path>/<filename
>
For example:
./Certs/client.keystore
JCEProvider
Enter the JCEProvider class name to support NTLM authentication.
For example:
com.unix.crypto.provider.UnixJCE.
IgnoreResourceRequirements
Ignores task resource requirements when distributing tasks across the nodes of a grid. Used when the PowerCenter Integration Service runs on a grid. Ignored when the PowerCenter Integration Service runs on a node.
Enable this option to cause the Load Balancer to ignore task resource requirements. It distributes tasks to available nodes whether or not the nodes have the resources required to run the tasks.
Disable this option to cause the Load Balancer to match task resource requirements with node resource availability when distributing tasks. It distributes tasks to nodes that have the required resources.
Default is Yes.
Run sessions impacted by dependency updates
Runs sessions that are impacted by dependency updates. By default, the PowerCenter Integration Service does not run impacted sessions. When you modify a dependent object, the parent object can become invalid. The PowerCenter client marks a session with a warning if the session is impacted. At run time, the PowerCenter Integration Service fails the session if it detects errors.
Persist Run-time Statistics to Repository
Level of run-time information stored in the repository. Specify one of the following levels:
  • None. PowerCenter Integration Service does not store any session or workflow run-time information in the repository.
  • Normal. PowerCenter Integration Service stores workflow details, task details, session statistics, and source and target statistics in the repository. Default is Normal.
  • Verbose. PowerCenter Integration Service stores workflow details, task details, session statistics, source and target statistics, partition details, and performance details in the repository.
To store session performance details in the repository, you must also configure the session to collect performance details and write them to the repository.
The PowerCenter Workflow Monitor shows run-time statistics stored in the repository.
Flush Session Recovery Data
Flushes session recovery data for the recovery file from the operating system buffer to the disk. For real-time sessions, the PowerCenter Integration Service flushes the recovery data after each flush latency interval. For all other sessions, the PowerCenter Integration Service flushes the recovery data after each commit interval or user-defined commit. Use this property to prevent data loss if the PowerCenter Integration Service is not able to write recovery data for the recovery file to the disk.
Specify one of the following levels:
  • Auto. PowerCenter Integration Service flushes recovery data for all real-time sessions with a JMS or WebSphere MQ source and a non-relational target.
  • Yes. PowerCenter Integration Service flushes recovery data for all sessions.
  • No. PowerCenter Integration Service does not flush recovery data. Select this option if you have highly available external systems or if you need to optimize performance.
Required if you enable session recovery.
Default is Auto.
If you select Yes or Auto, you might impact performance.
Store High Availability Persistence in Database
Enables the PowerCenter Integration Service to store process state information in the high availability persistence tables in the PowerCenter repository database.
The process state information contains information about which node was running the master PowerCenter Integration Service and which node was running the sessions.
Default is no.
This property does not determine where the service stores the state of operation files used for recovery. The PowerCenter Integration Service always stores the state of each workflow and session operation in files in the $PMStorageDir directory of the PowerCenter Integration Service process.