Db2 for z/OS

Configure a Db2® for z/OS® datasource on your Guardium® system.

Prerequisite

Download and install the Db2 for z/OS JDBC license file from Passport Advantage. For more information, see Uploading a JDBC license file for mainframe hosts to the Guardium system.

Supported Authentication Methods

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

Parameters

Field Description
Host Name/IP Required. The hostname or IP address of the datasource.
Location name Required. The location of the database.
Port number Required. Default value: 446.
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.

To enhance database performance, enter resultSetHoldability=2

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.