Bulk Data Movement Guide

10.5.3
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Using Connection Attributes to Tune Bulk Data Movement Sessions

In PowerCenter, you can customize options on PWX NRDB Batch application connections and PWX bulk relational connections to tune bulk data movement sessions.

The following table describes the connection attributes that you can use to tune bulk data movement sessions:

Connection Attribute	Description	Tuning Suggestion
Compression	Select this option to compress source data during the PowerCenter session. Default is disabled.	Do not use compression.
Encryption Type	The type of data encryption that PowerExchange uses. Default is None.	Do not use encryption.
Offload Processing	Select this option to request bulk data offload processing. Default is No.	For more information, see Bulk Data Offload and Multithreaded Processing.
Worker Threads	If you enable offload processing for data types that support worker threads, set this option to use multiple threads for offloaded processing on the Integration Service machine. Enter the number of threads that you want PowerExchange to use. Valid values are from 1 through 64. Default is 0, which disables multithreading.	For more information, see Bulk Data Offload and Multithreaded Processing.
Array Size	For VSAM data sets or sequential files, if the Worker Threads value is greater than zero, Array Size specifies the size of the storage array, in number of records, for the threads. For DB2 for z/OS tables, Array Size specifies the DB2 fetch array size. For DB2 for z/OS image copies, Array Size determines the maximum number of memory buffers that might need to be allocated. If zIIP processing is enabled, Array Size also specifies how many compressed rows to dispatch to the zIIP processor. Valid values are 25 through 5000. Default is 25.	Informatica recommends that you use the default value of 25 unless you are able to test and determine whether the extra memory that is allocated to a larger array size has been beneficial and has not degraded server performance. If you are able to make these determinations, Informatica recommends an array size of 500 to 1000 in the following cases: You enable offload processing and select a nonzero value for Worker Threads . You are using the SQL Server bulk load utility to load data to SQL Server tables. You use a compressed image copy as a data source for PowerExchange bulk data movement, and you have enabled zIIP processing on z/OS. Informatica does not recommend increasing the array size in the following cases: You are performing NRDB processing and not using offload processing. You are moving LOB columns or rows that are very large because they contain many columns.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Using Connection Attributes to Tune Bulk Data Movement Sessions

Using Connection Attributes to Tune Bulk Data Movement Sessions