Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. POWERCENTERHELP
  17. Session Properties Reference
  18. Workflow Properties Reference

Database Connection Resilience

Database Connection Resilience

Database connection resilience is the ability of the Integration Service to tolerate temporary network failures when connecting to a relational database or when the database becomes unavailable. The Integration Services is resilient to failures when it initializes the connection to the source or target database and when it reads data from or writes data to a database.
You configure the resilience retry period in the connection object. You can configure the retry period for source, target, SQL, and Lookup transformation database connections. When a network failure occurs or the source or target database becomes unavailable, the Integration Service attempts to reconnect for the amount of time configured for the connection retry period. If the Integration Service cannot reconnect to the database in the amount of time for the retry period, the session fails.
The Integration Service will
not
attempt to reconnect to a database in the following situations:
  • The database connection object is for an Informix connection.
  • The transformation associated with the connection object is not configured for deterministic and repeatable output.
  • The value for the DTM buffer size is less than what the session requires.
  • The truncate the target table option is enabled for a target and the connection fails during execution of the truncate query.
  • The database connection fails during a commit or rollback.
Use the retry period with the following connection types:
  • Relational database connections
  • FTP connections
  • JMS connections
  • WebSphere MQ queue connections
  • HTTP application connections
  • Web Services Consumer application connections
For a database connection to be resilient, the database must be a highly available database and you must have the high availability option or the real-time option.