Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data
  26. POWERCENTERHELP

Advanced Workflow Guide

Advanced Workflow Guide

Assigning Resources to Tasks

Assigning Resources to Tasks

PowerCenter resources are the database connections, files, directories, node names, and operating system types required by a task to make the task succeed. The Load Balancer may use resources to dispatch tasks. If the Integration Service is not configured to run on a grid or check resources, the Load Balancer ignores resource requirements. It dispatches all tasks to the master Integration Service process running on the node.
If the Integration Service runs on a grid and is configured to check resources, the Load Balancer uses resources to dispatch tasks. The Integration Service matches the resources required by tasks in a workflow with the resources available on each node in the grid to determine which nodes can run the tasks. The Load Balancer distributes the Session, Command, and predefined Event-Wait tasks to nodes with available resources. For example, if a session requires a file resource for a reserved words file, the Load Balancer dispatches the session to nodes that have access to the file. A task fails if the Integration Service cannot identify a node where the required resource is available.
In the Administrator tool, you define the resources that are available to each node. Resources are either predefined or user-defined. Predefined resources include connections available to a node, node name, and operating system type. User-defined resources include file/directory resources and custom resources.
In the task properties, you assign PowerCenter resources to nonreusable tasks that require those resources. You cannot assign resources to reusable tasks.
The following table lists resource types and the repository objects to which you can assign them:
Resource Type
Predefined/
User-Defined
Repository Objects that Use Resources
Custom
User-defined
Session, Command, and predefined Event-Wait task instances and all mapping objects within a session.
File/Directory
User-defined
Session, Command, and predefined Event-Wait task instances, and the following mapping objects within a session:
  • Source qualifiers
  • Aggregator transformation
  • Custom transformation
  • External Procedure transformation
  • Joiner transformation
  • Lookup transformation
  • Sorter transformation
  • Custom transformation
  • Java transformation
  • HTTP transformation
  • SQL transformation
  • Union transformation
  • Targets
Node Name
Predefined
Session, Command, and predefined Event-Wait task instances and all mapping objects within a session.
Operating System Type
Predefined
Session, Command, and predefined Event-Wait task instances and all mapping objects within a session.
If you try to assign a resource type that does not apply to a repository object, the Workflow Manager displays the following error message:
The selected resource cannot be applied to this type of object. Please select a different resource.
The Workflow Manager assigns connection resources. When you use a relational, FTP, or external loader connection, the Workflow Manager assigns the connection resource to sources, targets, and transformations in a session instance. You cannot manually assign a connection resource in the Workflow Manager.
To assign resources to a task instance:
  1. Open the task properties in the Worklet or Workflow Designer.
    If the task is an Event-Wait task, you can assign resources only if the task waits for a predefined event.
  2. On the General tab, click Edit.
  3. In the Edit Resources dialog box, click the Add button to add a resource.
  4. In the Select Resource dialog box, choose an object you want to assign a resource to. The Resources list shows the resources available to the nodes where the Integration Service runs.
  5. Select the resource to assign and click Select.
  6. In the Edit Resources dialog box, click OK.


Updated July 04, 2018