Administrator
- Administrator
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Property
| Description
|
|---|---|
Connection Name
| A name for the Db2 for z/OS Bulk Load connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
Spaces at the beginning or end of the name are trimmed and are not saved as part of the name.
Maximum length is 100 characters. Connection names are not case sensitive.
|
Description
| Description of the Db2 for z/OS Bulk Load connection. Maximum length is 4000 characters.
|
Type
| Type of connection. For Db2 for z/OS Bulk Load, the type must be
Db2 for z/OS Bulk Load .
|
Runtime Environment
| Name of the runtime environment that contains the Secure Agent that you want to use to run mapping tasks.
|
Listener Location
| Host name or IP address of the system where the PowerExchange Listener that processes requests for Db2 for z/OS Bulk Load runs. Also include the Listener port number. Enter the value in the following format, where
host_name can be a host name or IP address:
For example:
|
Database Name
| The Db2 subsystem or database name.
|
User Name
| A user name that can be used to access the PowerExchange Listener when PowerExchange Listener security is enabled. For more information, see the SECURITY statement in the
PowerExchange Reference Manual .
|
Password
| Password that is associated with the user name that is specified in the
User Name property.
|
Schema Name
| Schema used for the source or target.
|
Code Page
| The code page that the Secure Agent for the Data Integration Service uses to extract data from the source database.
|
Environment SQL
| SQL commands that run in the database environment.
|
Correlation ID
| A value to use as the Db2 Correlation ID for Db2 requests.
This value overrides the value in the SESSID statement in the PowerExchange DBMOVER configuration file.
|
Array Size
| Valid values are from 1 through 5000. Default is 25.
|
Replace Low Values with Spaces
| Controls whether to replace embedded nulls in character data with spaces. Select this property to replace embedded nulls. By default, this property is selected.
|
Connection Retry Period
| Number of seconds that the PowerExchange Bulk Reader tries to reconnect to the PowerExchange Listener after the initial connection attempt fails. If a connection cannot be established within the retry period, the mapping task fails. The default is 0, which disables connection retries.
|
Write Mode
| Options are:
|
Custom Properties
| Custom properties that you can specify to override PowerExchange default settings. You can enter multiple properties by using a semicolon (;) as the separator. Normally, you set custom properties only at the direction of Informatica Global Customer Support.
These properties are equivalent to the
PWX Override options for the PowerExchange Client for PowerCenter (PWXPC) Db2 for z/OS Bulk Load connections in PowerCenter.
|
