Connections > DB2 Loader connection properties > Connect to DB2 Loader
  

Connect to DB2 Loader

Let's configure the DB2 Loader connection properties to connect to a DB2 database.

Before you begin

Before you get started, you'll need to install the DB2 Loader JDBC driver and DB2 client on the Secure Agent machine to establish a DB2 Loader connection.
Check out Prerequisites to learn more about the configuration prerequisites.

Connection details

The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
Type
db2loader
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
This property is not supported by Data Ingestion and Replication.
When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
For information about how to configure and use a secrets manager, see Secrets manager configuration.
Runtime Environment
The name of the runtime environment where you want to run tasks.
Select a Secure Agent.
Host Name
The name of the machine that hosts the DB2 database server.
Database
The name of the DB2 database.
Port
The port number that connects to the DB2 database server.
Default is 50000.
Schema
The schema name in the DB2 database server to fetch the metadata.
This property doesn't apply when you configure a DB2 Loader connection.
User Name
The user name to connect to the DB2 account.
Password
The password to connect to the DB2 account.
Connection String
The alias name to connect to the DB2 database.

Advanced settings

The following table describes the advanced connection properties:
Property
Description
Encryption Method
Encrypts data exchanged between the Secure Agent and the database server.
Select one of the following encryption methods from the list:
  • - No Encryption. Establishes a connection without using SSL. Data is not encrypted.
  • - SSL. Establishes a connection using SSL. Data is encrypted using SSL.
Default is No Encryption.
Validate Server Certificate
Determines whether the Secure Agent validates the certificate that is sent by the database server.
This property appears only if you select the encryption method as SSL.
Select one of the following options from the list:
  • - False. The Secure Agent does not validate the certificate.
  • - True. The Secure Agent validates the certificate.
Default is False.
Truststore
The path and file name of the truststore file that contains the SSL certificate to connect to DB2.
This property appears only if you select the encryption method as SSL and validate server certificate as True.
Specify both the directory and file name in the following format:
/root/<folder name>/<truststore file name>.p12
Truststore Password
The password to access the truststore file that contains the SSL certificate.
This property appears only if you select the encryption method as SSL and validate server certificate as True.
Host name in Certificate
The name of the machine that hosts the secure database.
This property appears only if you select the encryption method as SSL and validate server certificate as True.
The Secure Agent validates the host name specified in this property with the host name in the SSL certificate.
Authentication Method
The authentication method that the driver uses to establish a connection.
Select one of the following authentication methods from the list:
  • - Clear Text. Sends the user ID and password in clear text to the DB2 server for authentication.
  • - Encrypted Password. Sends the user ID in clear text and encrypted password to the DB2 server for authentication.
Default is Clear Text.
Is Staged
Method to load data.
Select Is Staged to load data to a flat file staging area before loading to the database.
Default is disabled.
Recoverable
Sets the DB2 tablespace in backup pending state.
Before you enable the Recoverable option and run a mapping, you need to fully back up the database to perform any other operation on the tablespace.
Default is enabled.
DB2 Server Location
The DB2 database server location.
Select one of the following locations from the list:
  • - Remote. The DB2 database server resides on another machine.
  • - Local. The DB2 database server resides on the Secure Agent machine.
Default is Remote.
External Loader Executable
The DB2 external loader executable file name.
The Secure Agent uses the DB2 external loader executable file of the IBM data server client 9.5 version and later.
Default is db2load.
Operation Mode
The operation for DB2 external loader to perform.
Select one of the following operation modes to determine how the DB2 external loader writes data to the target table based on the mode that you selected in the DB2 external loader:
  • - Insert. Loads data to the table.
  • - Replace. Deletes existing data from the table, and then adds data to the table.
  • - Restart. Restarts a previously interrupted load operation.
  • - Terminate. Terminates a previously interrupted load operation and rolls back the operation to the starting point, even if consistency points are passed.
Default is Insert.
Additional Metadata Connection Properties
Additional metadata connection properties that you want to pass to the driver. If you specify more than one property, separate each key-value pair with a semicolon.
For example, <parameter name1>=<value1> ; <parameter name2>=<value2>