Connecting to a TLS enabled CA IDMS database

Import the CA IDMS certificate file and configure the JDBC settings. These steps are applicable to the CA IDMS JDBC driver.

Procedure

  1. Save the CA IDMS certificate file for the TLS enabled database as IDMS.CER in a file directory.
    Example: You can save IDMS.CER in the C:\Temp directory.
  2. Open Command Prompt as an administrator and navigate to the installation directory.
    • Example for QMF for Workstation: cd C:\Program Files\IBM\Db2 Query Management Facility\QMF for Workstation\jre\lib\security directory
    • Example for QMF for WebSphere®: d C:\Program Files\Java\ibm-semeru-certified-jdk_x64_windows_11.0.15.0\jdk-11.0.15+10\lib\security directory
  3. Run the following command: keytool -import -alias <alias_name> -file <path to .cer file> -keystore cacerts
    Example: C:\Program Files\IBM\Db2 Query Management Facility\QMF for Workstation\jre\lib\security>keytool -import -alias amsdevqmfrd01_server -file C:\temp\IDMS_Root_CA.cer -keystore cacerts
  4. Specify a password for keystore.
  5. Open the JDBC Advanced Settings dialog and set the ssl parameter to true:

Results

You can now connect to the TLS enabled database.