Db2 for i

Configure a Db2® for i datasource on your Guardium® system.

Supported Authentication Methods

Authentication Supported
Local user Yes
LDAP No
Kerberos No
SSL No
Mutual SSL No

Parameters

Field Description
Host Name/IP Required. The hostname or IP address of the datasource.
Port number Required. Default value: 446.
Service name The service name of the database.
Schema The name of the database schema.
Connection property Properties that must be included in the JDBC URL to establish a JDBC connection with the datasource. The required format is property1=value;property2=value, where each property and value pair is separated by a semicolon.
For examples, refer to the database vendor's JDBC documentation.

When a password is due to expire, a warning prompt appears 7 days before the expiration date. This expiration message might cause the login to fail. To avoid this scenario, add prompt=false to the connection properties.

Custom URL The connection string to the datasource. When the custom URL is not provided, the datasource connection is made by using properties such as the hostname and port number.

Example: property1=com.ibm.as400.access.AS400JDBCDriver;translate binary=true