Secure JDBC URL Configuration for DB2 Database

Products

• CA Identity Suite
• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

This article outlines the required syntax for establishing a secure JDBC connection string when connecting to a DB2 database. Use these parameters to ensure SSL/TLS encryption is correctly applied to the connection.

Environment

Identity Manager

Resolution

The JDBC URL format requires a specific structure, including the trailing semi-colon. Use the following syntax:

jdbc:db2://HOST:PORT/DbName:sslConnection=true;sslTrustStoreLocation=KeystorePath;sslTrustStorePassword=KeystorePassword;

Ensure the following variables are replaced with your specific environment details:

• HOST: The hostname or IP address of the DB2 server.
• PORT: The port number used for the secure connection.
• DbName: The name of the database.
• KeystorePath: The full path to the truststore file.
• KeystorePassword: The password for the truststore.