Connectors and Connections

Back Next

Db2 for i Database Ingestion connection properties

When you define a Db2 for i Database Ingestion connection, you must configure connection properties. You can use this connection type in

database ingestion and replication

tasks, which you configure in the

Data Ingestion and Replication

service.

The following table describes the connection properties:

Property	Description
Connection Name	A name for the 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	An optional description for the connection. Maximum length is 255 characters.
Type	The type of connection. Ensure that the type is Db2 for i Database Ingestion .
Runtime Environment	The name of the runtime environment where you want to run database ingestion and replication tasks. You define runtime environments in Administrator .
User Name	The user name to use for connecting to the Db2 for i instance.
Password	The password to use for connecting to the Db2 for i instance.
Host	The name of the machine that hosts the database server.
Port	The network port number used to connect to the database server.
Location Name	The name of the Db2 for i location that you want to access. Your system administrator can determine the name of the Db2 location by using the WRKRDBDIRE command. In the output, find the name of the database that is listed as *LOCAL and then use that value as the value of this property.
JDBC Driver	The type of JDBC driver. Select one of the following options: Data Direct JTOpen Default is Data Direct.
Code Page for Bit Data	The code page that Database Ingestion and Replication uses to read character data that is stored as bit data. This value must be a canonical name for the java.io API and java.lang API. For more information, see the supported encodings in the Oracle Java documentation. Specify this property if you have FOR BIT DATA source columns.
Advanced Connection Properties	Advanced properties for the JDBC driver which is used to connect to the Db2 for i source. If you specify more than one `property`=`value` entry, separate them with a semicolon (;). For information about the DataDirect JDBC driver connection properties, see Progress DataDirect documentation. For example, you can set the ConnectionRetryCount property to control the number of times the driver retries attempts to connect to the primary database server. For information about the JTOpen JDBC driver connection properties, see IBM Toolbox for Java JDBC properties.
Encryption Method	The data encryption method for the JTOpen JDBC Driver. Select one of the following options: No Encryption SSL Default is No Encryption. If you select SSL, you must add the required certificates to the Informatica Cloud Secure Agent JRE cacerts keystore in one of the following locations: For Linux: `Secure Agent Directory`\jdk\jre\lib\security\cacerts For Windows: `Secure Agent Directory`\apps\jdk`LatestVersion`\jre