Integration Service Process

The Integration Service starts an Integration Service process to run and monitor workflows. The Integration Service process accepts requests from the PowerCenter Client and from pmcmd. It performs the following tasks: 

• ƒ Manages workflow scheduling. 
• ƒ Locks and reads the workflow. 
• ƒ Reads the parameter file. 
• ƒ Creates the workflow log. 
• ƒ Runs workflow tasks and evaluates the conditional links connecting tasks. 
• ƒ Starts the DTM process or processes to run the session. 
• ƒ Writes historical run information to the repository. 
• ƒ Sends post-session email in the event of a DTM failure. 

Managing Workflow Scheduling 

The Integration Service process manages workflow scheduling in the following situations: 

When you start the Integration Service. When you start the Integration Service, it queries the repository for a list of workflows configured to run on it. 

When you save a workflow. When you save a workflow assigned to an Integration Service to the repository, the Integration Service process adds the workflow to or removes the workflow from the schedule queue. 

Locking and Reading the Workflow 

When the Integration Service process starts a workflow, it requests an execute lock on the workflow from the repository. The execute lock allows it to run the workflow and prevent you from starting the workflow again until it completes. If the workflow is already locked, the Integration Service process cannot start the workflow. A workflow may be locked if it is already running. The Integration Service process also reads the workflow from the repository at workflow run time. It reads all links and tasks in the workflow except sessions and worklet instances. The DTM retrieves the session and mapping from the repository at session run time. It reads the worklets from the repository when the worklet starts.