DB2

DB2 version

DB2 UDB <version number>

The version of your DB2 client. This is the version of DB2 that the datastore accesses.

Use Data Source (ODBC)

Yes

No

Select to use a DSN to connect to the database.

By default, this option is set to Yes. To use a DSN connection, you must also specify the ODBC data source name.

If you set this option to No, you must also specify the Database server name, Database name, and Port number for a DSN-less connection.

ODBC data source name

Refer to the requirements of your database

The ODBC data source name (DSN) defined for connecting to your database.

This option is required if Use Data Source (ODBC) is set to Yes.

Database server name

Refer to the requirements of your database

The DB2 database server name.

This option is required if Use Data Source (ODBC) is set to No.

Database name

Refer to the requirements of your database

The name of the database defined in DB2.

This option is required if Use Data Source (ODBC) is set to No.

Port number

Integer

The number of the database port.

This option is required if Use Data Source (ODBC) is set to No.

User name

Alphanumeric characters and underscores

The user name of the account through which the software accesses the database.

Password

Alphanumeric characters, underscores, and punctuation

The password of the account through which the software accesses the database.

Additional connection information

String with key value pairs separated by a semicolon and ending with a semicolon.

Example: key1=value1;key2=value2;

To connect to a DB2 iSeries 7.4 or higher datastore, Additional connection information must be populated with at least the following key-pair:

TXNIsolation=32;

Populating this field for DB2 iSeries prior to 7.4 is not necessary.

Language

SAP-supported ISO three-letter language codes or <default>

Select the language from the possible values in the drop-down list. The <default> option sets the language to the system language of the SAP Data Services Agent host system.

Code page

-

Specify the character encoding of character data in the datastore.

Aliases

-

Enter the alias name and the owner name to which the alias name maps.