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 zOS 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 z/OS instance. |
Password | The password to use for connecting to the Db2 for z/OS 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 z/OS location that you want to access. For Db2 for z/OS, your system administrator can determine the name of your Db2 location using the command DISPLAY DDF. |
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. |
CDC Stored Procedure Schema | For incremental change data capture processing, the name of the schema for the z/OS stored procedure that is required to collect change data from the Db2 log. This value is specified in the #STPINST data set that you customized when setting up the stored procedure on z/OS. No default value is provided. |
CDC Stored Procedure Name | For incremental change data capture processing, the name of the z/OS stored procedure that is required to collect change data from the Db2 log. This value is specified in the #STPINST data set that you customized when setting up the stored procedure on z/OS. The default value is INFALOG. |
Advanced Connection Properties | Advanced properties for the Progress DataDirect JDBC Db2 driver, which is used to connect to the Db2 for z/OS source. If you specify more than one property=value entry, separate them with a semicolon (;). The driver properties that you can enter in this field are described in the Progress DataDirect documentation at https://docs.progress.com/bundle/datadirect-connect-jdbc-51/page/Connection-Properties_10.html. 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. |