Db2 for i connection properties

Property	Description
Connection Name	A name for the Db2 for i 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 i connection. Maximum length is 4000 characters.
Type	Type of connection. For Db2 for i, the type must be Db2 for i.
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 i 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: host_name:port_number For example: DB2ILSNR:14675
Database Name	The Db2 for i 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	The schema name of the Db2 for i 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.
Isolation Level	The Db2 for i isolation level to use for the source database. Options are: - ALL - CS - CHG - None - RR Default is CS
Database File Overrides:	A value to override the database file default. This value overrides the value in the DB_FILE statement in the PowerExchange DBMOVER configuration file.
Library List:	The name of the Db2 for i Library List to use for the connection.
Environment SQL	SQL commands that run in the database environment.
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.
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. Note: These properties are equivalent to the PWX Override options for the PowerExchange Client for PowerCenter (PWXPC) Db2 for i connections in PowerCenter.
Write Properties	Write Mode. Options are: - Confirm Write On. Sends data to the PowerExchange Listener and waits for a success or no success response before sending more data. This mode sends data synchronously to the PowerExchange Listener rather than buffering the data. - Confirm Write Off. Sends data asynchronously to the PowerExchange Listener by buffering the data. This mode does not wait for a success or no success response. - Asynchronous with Fault Tolerance. Combines the speed of Confirm Write Off with the error detection of Confirm Write On. This mode buffers the data and sends it asynchronously to the PowerExchange Listener. When an SQL error occurs, PowerExchange creates a reject file on the target machine, which contains the data records that the writer could not write to the target. View the file contents to identify and correct the errors without reloading the entire table. You can also specify how to handle specific SQL return codes. Default is Confirm Write On.
Reject File	Overrides the default prefix of PWXR for the reject file. PowerExchange creates the reject file on the target machine when the Write Mode is Asynchronous with Fault Tolerance. Note: Enter PWXDISABLE to prevent creation of the reject files.